Database Administration:

• Memory, process and disk structure
• instances and databases
• storage structures
• backup and recovery
• SQL and database tuning
• network resource management

Oracle Architecture:

• Disk structures
• parameter files
• control files
• data files
• redo log files
• password files
• segments, extents and blocks
• memory areas
• shared pool
• buffer cache
• redo log buffer
• processes
• database writer
• log writer
• system monitor
• process monitor
• archiver
• processing overview

Creating a Database:

• Configuring the operating system
• privileged account authentication
• creating a parameter file
• creating a database
• creation commands
• post creation actions
• data dictionary management

Starting and Stopping Oracle:

• Instance processing overview
• startup command
• startup stages
• command options
• shutdown commands and options
• checking instance status
• using the alert logs
• trace files

Tablespaces, Datafiles and Rollback Segments:

• Structure review
• tablespace types
• system tablespace
• non-system tablespaces
• inside a tablespace
• locally managed and dictionary managed tablespaces
• datafiles
• tablespace and datafile management
• segments, extents and blocks
• rollback segment operations
• creating and managing rollback segments

Tables and Indexes:

• Creating tables
• data types
• creation and management commands
• inside a table
• table management (alter, drop, move)
• partitioned tables
• indexes
• creating indexes and setting storage criteria
• index management

Database Integrity:

• Creating, altering and dropping constraints
• enabling and disabling constraints
• constraints and indexes
• more on index types
• index-organised tables
• bitmap indexes
• reverse key indexes

User and Resource Management:

• User accounts overview
• resource profiles
• system and password limits
• profile management
• authentication choices - password, operating system, database
• users and tablespaces
• privileges and roles
• creating and managing user account
• tablespace quotas; data dictionary information

Privileges:

• User and system privileges
• assigning privileges to users
• using roles
• stored code privileges
• invoker and definers rights

Oracle Best Practices:

• User and system privileges
• assigning privileges to users
• using roles
• stored code privileges
  invoker and definers rights