Home Course Details Contact Us

Oracle 12c / 11g DBA Course Contents

  • Introduction to Databases & RDBMS
  • Introduction to Oracle & difference between Oracle versions. New Features in 12c
  • Oracle Physical Structures
  • Memory structures and Processes of Oracle
  • Dedicated Server and Multithreaded Server
  • Installation of Oracle10g, 11g, 12c under Linux, Solaris and Win.
  • Networking Clients
  • Creation of a database from scratch and using DBCA
  • Managing Tablespaces and Data files
  • Managing Log files and Control file
  • Introduction to Data Blocks, Extents and Segments
  • Locally Managed Tablespaces and Auto Segment Space mgmt.
  • Managing Undo Space and Flashback Features
  • Security Management, User Accounts and Privileges
  • Managing Profiles and Resource Manager
  • SQL*Loader, loading data from other data sources
  • Exporting and Importing data between Oracle Databases
  • Migrating databases
  • Auditing Database usage using Audit features, FGA, triggers.
  • Introduction to Oracle Database Control
  • Using Enterprise Manager through Web Browser
  • Creating Pluggable databases in 12c
  • Managing Pluggable databases in 12c

Tuning

  • Top mistakes people do with Oracle Databases
  • Tuning SQL Statements and Tuning Applications
  • Introduction to OLTP and Data warehouse
  • Tuning Indexes
  • Rule based & Cost based Optimizer Mode
  • Viewing and Understanding Execution Plans
  • AUTOTRACE, SQL Analyze Utilities
  • Tuning Memory Structures SGA, Buffer Cache, Log buffers
  • Tuning I/O Storage
  • Tuning conflicts and contention tuning
  • Tuning PGA, Sorts and miscellaneous objects
  • Automatic Storage Management (ASM) in 10g, 11g
  • Using SQL Advisor
  • Using Automatic Database Diagnostic Monitor
  • Using Undo Advisor

Backup and Recovery

  • Developing Backup and Recovery Strategies.
  • Understanding Offline (Cold) and Online (Hot) Backups
  • Taking Offline backups and understanding No archive log mode
  • Taking database in Archive log mode and taking Online backups
  • Performing Time based, Cancel based and Change based recovery
  • Introduction to RMAN
  • Taking backups and performing recovery using RMAN.
  • New features in RMAN in 10g and 11g versions
  • Maintaining Backup sets in RMAN
  • Block Media Recovery in RMAN.
  • Data Guard and Standby Database in 10g, 11g
  • Basic Replication and Advance Replication
  • Using DATA PUMP utility 
  • Oracle Golden Gate



Home Oracle DBA Interview Questions Locate Us Contact Us