Administration Workshop II – Institute of Software Technologies

Administration Workshop II

Administration Workshop II

This Database 11g Administration training teaches you to perform backup and recovery, and diagnose and repair data failures. Manage major database components like memory, performance and resources using Oracle Database 11g.

This course covers the following;

• Core Concepts and Tools of the Oracle Database
• Configuring for Recoverability
• Using the RMAN Recovery Catalog
• Configuring Backup Settings
• Creating Backups with RMAN
• Restore and Recovery Task
• Using RMAN to Perform Recovery
• Monitoring and Tuning RMAN
• Diagnosing the Database
• Using Flashback Technology I
• Performing Flashback Database
• Managing Memory
• Managing Database Performance
• Managing Performance by SQL Tuning
• Managing Resources
• Automating Tasks with the Scheduler
• Managing Space in Blocks
• Managing Space in Segments
• Managing Space for the Database
• Duplicating a Database

Required prerequisites;

• Oracle Database 11g: Administration Workshop I
• Working knowledge of SQL and how to use PL/SQL packages

You will learn how to:
• Configure the Oracle Database for optimal recovery
• Configure the database instance such that resources are appropriately allocated among sessions and tasks
• Schedule jobs to run inside or outside of the database
• Use compression to optimize database storage and duplicate a database
• Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
• Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
• Use an appropriate and flexible memory configuration for your database
• Identify burdensome database sessions and poorly performing SQL

This course prepares you for the following certifications:
• Oracle Certified Profession (OCP) – (Database Admin)

How you will be assessed?



7th Feb 2020


7th march 2020


7th Sept 2020