This course provides follow on education for moderately experienced administration of the Oracle database. The course includes coverage of conceptual topics needed for more in-depth understanding of increasingly complex administrative tasks, extensive coverage of Oracle network interaction, specialized database structures, advanced administrative tools, and comprehensive backup and recovery strategies and methodologies.
Backup and recovery concepts are reviewed followed by in-depth coverage of user managed and RMAN backup and recovery techniques. Using Oracle Recovery Manger (RMAN) to perform backups (cold and hot) and database recoveries (complete and point in time ‘PITR’) are a primary focuses of the class.
The Oracle instance, background processes, the SGA and memory structures are explored. Various models of data concurrency and consistency and alternative isolation levels are explained along with their uses.
Oracle provides many, many network-centric features for configuring the database to make optimal use of a network and to provide custom quality of service. The high-end options, configuration, optimization and ruggedization of the Oracle network interaction is given broad coverage.
Specialized database objects that serve as alternatives to traditional relational tables are reviewed as are their appropriate uses.
The many optional styles of indexes provided by Oracle are covered, with emphasis on the correct situations in which they can be deployed to best advantage.
4 Days/Lecture & Lab
This course is designed for: • Oracle developers and moderately experienced DBAs