Oracle 11g DBA - OCP

Oracle Database 12c: Introduction to SQL Ed 1.1


  • Data Warehouse Administrator
  • Developer
  • Application Developers
  • PL/SQL Developer
  • Forms Developer
  • System Analysts
  • Business Analysts

Required Prerequisites
Familiarity with data processing concepts and techniques, Data processing

Course Topics:

  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using the SET Operators
  • Managing Tables using DML statements
  • Introduction to Data Definition Language
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data
  • Managing Data in Different Time Zones

Oracle Database 11g: Administration Workshop I Release 2


  • Database Administrators
  • Technical Administrator
  • Support Engineer
  • Technical Consultant
  • Java Developers

Course Topics:

  • Exploring the Oracle Database Architecture
  • Installing your Oracle Software
  • Creating an Oracle Database
  • Managing the Oracle Database Instance
  • Manage the ASM Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Auditing
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Working with Support

Oracle Database 11g: Administration Workshop II Release 2


  • Database Administrators
  • Technical Administrator
  • Support Engineer
  • Technical Consultant

Course Topic:

  • 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
  • Using Flashback Technology II
  • 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
Quick Inquiry

Contact us for help, additional info or assistance and we'll be with you in no time!

Enter your name
Enter your email
Enter your mobile no
Enter your City
Nearest Center
Your message