Oracle Database 12c: Administration

Course details

Oracle Database 12c is the world's leading relational database management system. In this course, Oracle certified instructor and consultant David Yahalom provides an overview of this powerful database, focusing on those brand new to the software. David covers the Oracle database architecture in detail, including the shared pool, buffer cache, and physical and logical storage structures. He also discusses concepts such as tablespaces, data files, and redo logs. He then moves onto installation and configuration of the database itself, reviewing the Oracle CLI and GUI administration and development tools and typical administration tasks, including backup and recovery.

After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.

Learning objectives
Database instance and storage
Instance memory pools
Instance background processes
Client connections
Database storage file types
Control files and backup files
Multitenant databases
Starting and stopping the database
Installing Oracle 12c software
Using the developer tools
Database management

Concepts

0. Introduction

01 - Welcome
02 - Target audience
03 - Exercise files
04 - Learning supports

1. Architecture

05 - Database instance
06 - Database storage
07 - Server processes

2. Instance Memory Pools

08 - System global area
09 - Shared pool
10 - Buffer cache
11 - Redo log buffer
12 - Other SGA pools and the PGA
13 - SGA and PGA sizing

3. Instance Background Processes

14 - Database writer
15 - Log writer
16 - Checkpoint process
17 - SMON process
18 - PMON process
19 - RECO process
20 - LREG process
21 - Archiver process

4. Client Connections

22 - Oracle listener
23 - TNSNAMES.ORA config files
24 - How client connections work

5. Physical Database Structures

25 - Database storage file types
26 - Datafiles and tablespaces
27 - Special Oracle tablespaces
28 - Redo log files
29 - Control files
30 - Backup files
31 - Additional storage files

6. Multitenant Database

32 - Benefits of the 12c architecture
33 - New vs. old
34 - Backward compatibility

7. Start and Stop the Database

35 - Startup
36 - Shutdown

8. Install Oracle 12c software

37 - Prerequisites for installation
38 - O S configuration
39 - Download the software
40 - Install software

9. Create a Database Instance

41 - Use NETCA to create a listener
42 - Use DBCA to create a database

10. Tools for Developers and DBAs

43 - SQL Plus for administration
44 - SQL Developer for development
45 - Oracle Enterprise Manager

11. Management

46 - Start and stop the instance
47 - Start and stop the listener
48 - View and set parameters
49 - Create users and assign permissions
50 - Data dictionary
51 - Troubleshoot using the Alert Log
52 - Storage - Tablespaces and datafiles

Conclusion

53 - Next steps