IT CourseOracle 11g DBA OCA OCP Certification Coruse


1Z0-051 (Introduction to Modified SQL)

  • Oracle Infrastructural components and certification track
  • Oracle 11G SQL Statement (Select Statement using Multiple columns and Arithmetic Operators)
  • Restricting and Sorting Data (Conditions using Where Clause)
  • Single Row Functions (Table independent and table Dependent Functions, Conversion Functions)
  • Joins that displays Data from Multiple Tables (Joins, Cross, Natural, Self, Outer etc)
  • Aggregating Data by Using Group Functions (Group Functions and Group By Clause)
  • Writing Subqueries (Multiple queries in single statement)
  • Generating and Producing Readable Output with iSQL*Plus (Data retrieval using Variables)
  • Data Manipulating Language- Manipulating Data , setting default values (Insert , Update, Delete, Merge etc.)
  • Data Definition Language- Creating and Managing Tables (Create table, alter table, adding and dropping Columns, Renaming Data Object)
  • Including Constraints (Primary Key, Foreign Key, Check, Not Null, Unique etc)
  • Creating Views (Read Only Views, TOP N Analysis, ROW NUM)
  • Other Database Objects (Synonym, Sequences, Indexes etc)
  • Data Control Language- Controlling User Access (Commit, Rollback, Savepoint)
  • Using Set Operators (Union, Union All, Intersect, Minus)
  • Oracle 11G Datetime Functions (Timestamp, Timezone, YMInterval etc)
  • Enhancements to the GROUP BY Clause (RollUP and CUBE)
  • Oracle11G Extensions to DML and DDL Statements (Insertion in Multiple table at once)

1Z0-052 (Work Shop-1: Database Fundamentals-1)

  • Understanding the Logical structure of 11G Database
  • Understanding the Physical Location of files in 11G Database
  • Administering Users (Creating Users, Assigning Privileges, Roles Etc)
  • Installing Oracle Database 11g Software on Microsoft OS
  • Creating an Oracle 11G Database using DBCA
  • Creating an Oracle 11G Database Manually
  • Working with Database Interfaces
  • Controlling the Database (Shut down, Startup, DBconsole, Lsnrctl)
  • Creating tablespaces using enterprise manager
  • Creating tablespaces manually.
  • Managing Data (Creating Tables and insert, update, delete using Worksheet in EM)
  • PL/SQL (Manual Creation of Block, Cursor, Function, Procedure, Trigger)
  • Oracle Database Security (User Profile, Password Verification Function)
  • Oracle Net Services (Accessing Database on a Client using Command Prompt)
  • Working with Enterprise Manager and Worksheet to run queries.
  • UNDO management (Configuring Undo TS using EM)
  • Introduction to Grid concept of Undo Tablespace

1Z0-053 (Work Shop-2: Database Fundamentals-2)

  • Creating a client-server environment with Windows and Linux
  • Creating a user and making it accessible over the network.
  • Database Auditing (General Auditing and Fine Grained Auditing)
  • Recovery manager (Command line use of RMAN Backup)
  • Taking Cold Backup
  • Restoring And recovering from Media Failure using Cold Backup Files
  • Controlling Access to the Oracle Listener (Stop, Start, Status)
  • Configuring the recovering Manager (Configuration Options)
  • Taking and Scheduling Backup using EM
  • Taking and Scheduling Backup using NTBACKUP utility.
  • Taking Database in Archived log Mode.
  • Preparing database for HOT Backup
  • Taking Hot Backup
  • Restoring and Recovering using HOT Backup & Restore
  • Viewing the Back date data using “AS OF Timestamp”
  • Inserting back the deleted data using “AS OF Timestamp”
  • Using Flashback to recover the deleted Tables manually / using EM
  • Purging Tables and recycle bin manually
  • Automatic Performance Management (SQL Tuning Advisor, Segment Advisor)
  • Viewing the Data Dictionary (Tables and Dynamic Performance Views)
  • Manipulating Logfiles (Checkpoint, Log Switch, Creating new Log files etc)
  • Manual Segment Shrinking
  • Dealing with MEMORY (Resumable Session)
  • A quick Note on RAC (Real Application Cluster)
  • An Introduction to ASM and Dataguard
  • Attaining the OCA and OCP credit