Oracle DBA 11g Certification

About Us

LSA Training is an institution providing professional education to individuals pursuing career growth in an increasingly sophisticated and competitive world. We aim to promote excellence in education and training in both the academic and corporate world.

-      Duration: Accelerated Course – 3 weekends/1 Week

-       Fees:  £1300 (Exam Fees excluded)

Introduction:

LSA Training offers a 5 day Oracle course, widely regarded as the industry's most advanced database management system. The Oracle 11g OCP is an advanced training program that covers topics such as database interfaces and security in the initial stages, and advanced topics such as database management in the next level.

The OCP certification is an absolute must if you want to achieve any sort of success as a Database Administrator (DBA) or developer. The weight it adds to your resume and starting salary is unquestionable. With the experience that our faculty has on offer for our students, you can be rest assured of gaining valuable inputs throughout the course that you will be hard pressed to find anywhere else. We offer you unparalleled expertise that will help and guide you become an expert OCP.

Course Curriculum:

OCP Exam# 1Z0-051: 
Oracle Database 11g: SQL Fundamentals I

SQL Select Statements
SQL SELECT statements
execute a basic SELECT statement
List the capabilities of SQL 
Execute SELECT statement

Restricting and Sorting Data 
Limit the rows retrieved by a query 
Sort the rows retrieved by a query
Ampersand substitution to restrict and sort output at runtime

Single-Row Functions 
Describe various types of functions available in SQL 
Various types of functions available in SQL
Use character, number, and date functions in SELECT statements 
Use conversion functions
Character, number, and date functions in SELECT statements
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement

Displaying Data from Multiple Tables 
Write SELECT statements to access data from more than one table using equality and none quality joins 
View data that generally does not meet a join condition by using outer joins 
Join a table to itself using a self-join
Generate a Cartesian product of all rows from two or more tables

Aggregating Data using Group Functions 
Identify the available group functions 
Use group functions 
Group data using the GROUP BY clause 
Include or exclude grouped rows by using the HAVING clause

Sub queries 
Describe the types of problems that sub queries can solve 
Define sub queries 
List the types of sub queries 
Write single-row and multiple-row sub queries

Producing Readable Output 
Produce queries that require a substitution variable 
Produce more readable output 
Create and execute script files

Manipulating Data 
Describe each DML statement 
Insert rows into a table 
Update rows in a table 
Delete rows from a table 
Merge rows in a table 
Control transactions

Creating and Managing Tables 
Describe the main database objects 
Create tables 
Describe the data types that can be used when specifying column definition 
Alter table definitions 
Drop, rename and truncate tables

Including Constraints 
Describe constraints 
Create and maintain constraints

Using the Set Operators
Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned

Creating Views 
Describe a view 
Create, alter the definition, and drop a view 
Retrieve data through a view 
Insert, update and delete data through a view 
Create and use an inline view 
Perform Top 'N' Analysis

Creating Other Schema Objects
Create simple and complex views
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms

Creating Other Database Objects 
Create, maintain and use sequences 
Create and maintain indexes 
Create private and public synonyms

Using Sub queries to Solve Queries
Define sub queries
Describe the types of problems that the sub queries can solve
List the types of sub queries
write single-row and multiple-row sub queries

Controlling User Access 
Create users 
Create Roles to ease setup and maintenance of the security model 
Use the GRANT and REVOKE statements to grant and revoke object privileges

OCP Exam #1Z0-052
Oracle Database 11g: Administration I

Oracle Database Architecture 
Memory Structures 
Process Structures 
Storage Structures

Database Environment 
Oracle Database Administration
Oracle Database Planning and installation 
Oracle Universal Installer (OUI), Oracle Database Installation

Oracle Database
Create Oracle Database
Database Configuration Assistant (DBCA)

Oracle Instance
Manage Oracle Instance 
Initialization parameters 
Stages of database start-up and shutdown 
Alert log and trace files 
Data dictionary and dynamic performance views

Oracle Network Environment 
Configure and Manage the Oracle Network 
Oracle Shared Server architecture

Database Storage Structures
Manage Database Structures
Table space and data files 
Create and manage table spaces 
Space management in table spaces

Administering User Security in Oracle Database 
Create and manage database user accounts 
Grant and revoke privileges 
Create and manage roles 
Create and manage profiles 
Managing Schema Objects 
Create and Modify tables 
Manage Constraints 
Create indexes 
Create and use temporary tables

Data and Concurrency 
Manage data using DML 
Identify and administer PL/SQL objects 
Monitor and resolve locking conflicts

Undo Data 
Introduction to Undo data
Transactions and undo data 
Managing undo

Oracle Database Security
Manage Oracle Database security 
Principle of Least Privilege 
Standard Database Auditing

Oracle Database Maintenance 
optimizer statistics 
Automatic Workload Repository (AWR) 
Use advisory framework 
Alerts and Thresholds

Performance Management 
Automatic Memory Management 
Memory Advisors 
Troubleshoot invalid and unusable objects

Intelligent Infrastructure Enhancements 
Enterprise Manager Support Workbench 
Managing Patches

Oracle Database Backup and Recovery
Configure Oracle Database Backup and Recovery 
Identify the types of failure that can occur in an Oracle database 
Describe ways to tune instance recovery 
Identify the importance of checkpoints, redo log files, and archived log files 
Overview of flash recovery area 
Configure ARCHIVELOG mode

Performing Database Backups 
Create consistent database backups 
back up your database without shutting it down 
Create incremental backups 
Automate database backups 
Manage backups, view backup reports and monitor the flash recovery area

Performing Database Recovery 
Oracle Data Recovery Advisor 
Oracle Data Recovery Advisor to Perform recovery (Control files, Redo log file and Data file)

Moving Data 
use methods to move data (Directory objects, SQL*Loader, External Tables) 
Architecture of Oracle Data Pump 
Data Pump Export and Import to move data between Oracle databases

OCP Exam #1Z0-053 
Oracle Database 11g: Administration II

Using Globalization Support Objectives
Customize language-dependent behaviour for the database and individual sessions 
Specify different linguistic sorts for queries
Oracle Database Architecture and ASM 
Automatic Storage Management (ASM) 
Set up initialization parameter files for ASM and database instances 
Start up and shut down ASM instances 
Administer ASM disk groups

Configuring for Recoverability 
Configure multiple archive log file destinations to increase availability 
Define, apply and use a retention policy 
Configure the Flash Recovery Area 
Use Flash Recovery Area

Using the RMAN Recovery Catalogue
Identify situations that require RMAN recovery catalogue 
Create and configure a recovery catalogue 
Synchronize the recovery catalogue 
Create and Use RMAN stored scripts 
back up the recovery catalogue 
create virtual private catalogue

Configuring Backup Specifications 
Configure backup settings 
Allocate channels to use in backing up 
Configure backup optimization

Using RMAN to Create Backups 
Create image file backups 
Create a whole database backup 
Enable fast incremental backup 
Create duplex backup and back up backup sets 
Create an archival backup for long-term retention 
Create a multisession, compressed and encrypted backup 
Report on and maintain backups

User-Managed Oracle Database Backup and Recovery 
Recover from a lost TEMP file 
Recover from a lost redo log group 
Recover from the loss of password file 
Perform user-managed complete database recovery 
Perform user-managed incomplete database recovery 
Perform user-managed and server managed backups 
Identify the need of backup mode 
Back up and recover a control file

RMAN to Perform Recovery 
Perform complete recovery from a critical or noncritical data file loss using RMAN 
Perform incomplete recovery using RMAN 
Recover using incrementally updated backups 
Switch to image copies for fast recovery 
Restore a database onto a new host 
Recover using a backup control file 
Perform Disaster recovery

RMAN to Duplicate a Database 
Creating a duplicate database 
using a duplicate database

Performing Table space Point-in-Time Recovery 
Identify the situations that require TSPITR 
Perform automated TSPITR

Monitoring and Tuning RMAN 
Monitoring RMAN sessions and jobs 
Tuning RMAN 
Configure RMAN for Asynchronous I/O

Flashback Technology 
Restore dropped tables from the recycle bin 
Perform Flashback Query 
Flashback Transaction

Additional Flashback Operations 
Flashback Table operations 
Configure, Monitor Flashback Database
Perform Flashback Database operations 
Set up and use a Flashback Data Archive

Diagnosing the Database 
Set up Automatic Diagnostic Repository 
Using Support Workbench 
Perform Block Media Recovery

Managing Memory 
Automatic Memory Management 
Manually configure SGA parameters 
Configure automatic PGA memory management

Managing Database Performance 
SQL Tuning Advisor 
SQL Access Advisor to tune a workload 
Understand Database Replay

Space Management 
Manage resumable space allocation 
Describe the concepts of transportable table spaces and databases 
reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Resources 
database resource manager 
Create and use Database Resource Manager Components

Automating Tasks with the Scheduler 
Create a job, program, and schedule 
Use a time-based or event-based schedule for executing Scheduler jobs 
Create lightweight jobs 
Use job chains to perform a series of related tasks

Administering the Scheduler 
Create Windows and Job Classes 
Use advanced Scheduler concepts to prioritize jobs

Globalization 
Customize language-dependent behaviour for the database and individual sessions 
working with database and NLS character sets

Exam Track/Fees:

There are 20 centres all around the UK, to book your exam please visit

http://www.pearsonvue.com/oracle/schedule/index_en.asp

OR

http://www.prometric.com

Expected Salary/ Pay Package:

On an average, people who are certified on Oracle 11g, earn a lot more than their colleagues in the industry. Enrol yourself today in this interactive, hands-on class, taught by a certified professional.