Oracle 11G R-2 DBA Certification Course

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