Installation & upgrade volume

Configuring the server for installation
• identify system requirements
• optimal flexible architecture (ofa)
• oracle_base
• oracle_home
• configure linux installation
• configure ms windows installation
• prerequisite checks & fixup utility

Enterprise edition installation
• more about the installation
• start the installation
• desktop class installation 11g r2
• server class installation 11g r2
• post-installation configuration

Verify the installation
• accessing the em database control
• using the em interface
• using sql*plus
• using em sql worksheet
• using ssh

Upgrade, deinstallation & patching
• database upgrade
• netca
• dbua
• online patching
• oracle deinstaller

Volume A:

Manually starting & stopping database services
• starting & stopping database control
• starting & stopping the listener
• starting & stopping the database
• sysdba

Exploring the oracle database architecture - General
• the oracle enterprise architecture
• general database architecture
• v$version

Exploring the oracle database architecture - Instance memory
• more about database instances
• using v$sga_dynamic_components
• about the pga
• managing memory

Exploring the oracle database architecture - Instance processes
• instance background processes
• sql execution processes
• using v$session

Creating an oracle database
• create a new database
• configure an existing database
• drop a database
• manage dbca templates
• manually create a database
• more about the database files

Enabling transparent data encryption
• transparent data encryption
• managing tde
• implementing column encryption

Manage database storage structures - Tablespaces
• about tablespaces
• tablespace management
• autoextend options
• drop tablespace
• alter tablespace

Manage database storage structures - advanced Tablespaces
• more about temporary tablespaces
• using v$sort_segment
• about temporary tablespace groups
• more about permanent tablespaces
• about database_properties
• more about bigfile tablespaces
• more about the sysaux tablespace

Manage database storage structures: data files & Temp files
• managing data files
• managing temp files
• enable oracle-managed files (omf)

Managing undo data
• about undo space management
• configure undo management
• undo_management
• undo_tablespace
• undo_retention
• guarantee undo retention
• monitor undo space
• use the undo advisor

Volume B:

Network environment: oracle net services
• oracle net services architecture
• oracle net configuration assistant
• oracle net manager
• configuration using em
• troubleshooting network problems
• countering database attacks
• Network environment: oracle shared servers
• shared servers architecture
• configure shared servers
• monitor shared servers
• v$shared_server
• v$shared_server_monitor
• v$session
• v$circuit
• v$dispatcher & v$dispatcher_config
• v$queue

Security: implementing database security
• database system privileges
• database object privileges
• auditing of database activity
• audit_trail parameter
• enhanced default security settings

Security: administering user security
• create & manage database accounts
• grant & revoke database privileges
• resource limits via profiles
• alter profile
• drop profile
• password management via profiles
• about role-based security
• with admin option
• with admin option & system privileges
• with grant option & object privileges
• alter user...default role
• set role
• enhanced default security settings
• sec_case_sensitive_logon setting

Moving data: SQL loader
• loader concepts
• control file options
• load methods
• using the em interface

Database maintenance & performance Monitoring
• management & advisory framework
• manage awr
• addm
• use metrics & alert thresholds
• automatic maintenance tasks

Managing concurrency & locks
• about latches & locks
• manage & monitor latches
• v$lock
• v$locked_object
• v$session
• v$session_wait
• dba_blockers & dba_waiters
• dba_dml_locks & dba_ddl_locks
• dml_locks

Backup & recovery concepts & configuration
• about backup & recovery structures
• managing redo data
• managing archival data
• automatic crash recovery
• creating a basic backup strategy