Oracle DBA

About Course - Oracle DBA

This course provides an exhaustive coverage of SQL, Database Administration and Database Backup & Recovery. Oracle DBA Certification course is valuable for Database Administrators, database designers, data warehouse administrators and support engineers.

Curriculum

  • New Features in 11g
  • New manageability features
  • Use of Database Replay and Recovery Advisor
  • RMAN Enhancements
  • Use of Flashback and LogMiner
  • Database Replay and Recovery Advisor
  • Oracle SecureFiles
  • SQL Performance Analyzer
  • SQL Plan Management
  • Automatic SQL Tuning
  • Retrieval of Data using SQL Select Statement
  • Restricting, Manipulating and Sorting Data
  • Use of Single-Row Functions to Customize Output
  • Conversion functions and Conditional Expressions
  • DDL Statements to create and manage tables
  • Creation of Schema Objects
  • Aggregated Data using Group Functions
  • Multiple Tables
  • Exploring Oracle Database Architecture
  • Preparing the Database Environment
  • Creation of Oracle Database
  • Management of Oracle Instance, Performance Management and Database Storage Structures
  • Configuration of Oracle Network Environment
  • Managing Data and Concurrency
  • Administering User Security
  • Database Maintenance
  • Performance Management
  • Database Backups and Recovery
  • Intelligent Infrastructure Enhancements
  • Moving Data
  • Database Architecture and ASM
  • Configuration for Recoverability and Backup Specifications
  • Use of RMAN to Create Backups
  • User-Managed Backup and Recovery
  • RMAN to Perform Recovery
  • Flashback Technology and Operations
  • Management of Resources and Database Performance
  • Space Management
  • Automation of Tasks with the Scheduler