Oracle 11G R-2 DBA Certification Course

Oracle Database Administration course is designed by Oracle Corporation (Oracle Education Wing) to prepare a trainee for handing complex database operations including SQL Queries, Administration, Backup-Recovery and Performance Tuning. Oracle 11G is the most popular release of Oracle Database these days (Oracle 12C has started spreading its wings the market). Oracle 11G DBA track includes 03 International Exams/Modules. The first one is 1Z0-051, which gives in depth knowledge of Database Analysis using SQL queries, Second Module is 1Z0-052, which gives an hands-on knowledge of managing, creating, altering the database and managing users, schemas, tablespaces, profiles etc. The Third Module 1Z0-053 makes one able to handle the Backup and recovery of the database using RMAN, DATAPUMP and FLASHBACK. The performance tuning is also a part of this Module. To attain OCA (Oracle Certified Associate) Certificate, one has to clear 1Z0-051 and 1Z0-052 exams. After OCA (1Z0-051+1Z0-052)  if one clears 1Z0-053, will get OCP (Oracle Certified Professional).

After Oracle DBA course, The Database Professionals can move towards RAC, ASM, Data Guard, and Golden Gate technologies also.

Benefit of learning Oracle 11G DBA International Certification Course   From Selecom Technology


Course Content

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

Enroll Now