ORACLE

COURSE ID ORAC011
DELIVERY METHOD Classroom Instructor-led training (CILT)
Online Instructor-led training ( OILT)
DURATION 39 hrs
PREREQUISITES

The Oracle Database 11g Administrator Certification (OCP 11g) from QuickCert ensures that database professionals have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 11g.

QuickCert's 11g OCP training package covers includes the following exam courses needed for certification:

  • 1Z0-047: Oracle Database SQL Expert
  • 1Z0-052: Oracle Database 11g: Administration I
  • 1Z0-053: Oracle Database 11g: Administration II

QuickCert's training course will teach students how to install and maintain an Oracle database, how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Students will also learn skills required for working with SQL, including how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. After completing
QuickCert's Oracle OCP 11g course, students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.

Oracle DBA's manage the industry's most advanced information systems and command some of the highest salaries. By earning your Oracle Certification from QuickCert, you will be one step closer to gaining access to better career opportunities. QuickCert is so certain this OCP11g training course meets and exceeds the exam objectives, we guarantee you will pass your exam!

Not sure what course is right for you?
Contact one of our Career Advisors at (416) 623-9493 for assistance.

Oracle 11g Certification: OCP

Explore the Lifecycle Development Phases

• Define a database

• Discuss the theoretical, conceptual and physical aspects of a relational database

• Describe the Oracle implementation of the RDBMS and the ORDBMS

• Describe PL/SQL

Write and Execute a Basic SQL Statement

• Describe the SQL SELECT capabilities

• Differentiate between SQL and SQL*Plus commands

• Limit and sort the rows retrieved by a query

• Customize the SQL*Plus environment

• Save customizations

Examine Single Row Functions

• Use a variety of character, number, and date functions in SELECT statements

• Describe different types of join

• Group functions and their uses

• Insert and update rows in a table

• Delete rows from a table

• Define subqueries

• Write single-row, multi-row, and multi-column subqueries

• Control transactions

Create Tables and Views

• Describe the the main database objects

• Create tables

• Alter table definitions

• Drop, rename and truncate tables

• Including Constraints

• Retrieve data via a view

• Insert, update and delete data through views

• Drop views

• Alter the definition of a view

• Create and maintain sequences and indexes

Control User Access

• Understand the concepts of users, roles, and privileges

• GRANT and REVOKE object privileges

• Using Roles to Manage Database Access

Oracle Workshop I and II

Install Oracle Grid Infrastructure

Configure Oracle Net services Monitor

Administer undo data Manage the database storage structures

Create and administer user accounts

Perform basic backup and recovery of a database

Manage data concurrency Monitor performance

Describe Oracle Database Architecture

Installing your Oracle Software

Tasks of an Oracle Database Administrator

Tools Used to Administer an Oracle Database

Installation:System Requirements

Oracle Universal Installer (OUI)

Installing Oracle Grid Infrastructure

Installing Oracle Database Software

Silent Install

Creating an Oracle Database

Planning the Database

Using the DBCA to Create a Database

Password Management

Creating a Database Design Template

Using the DBCA to Delete a Database

Managing the Oracle Database Instance

Start and stop the Oracle database and components

Use Oracle Enterprise Manager

Access a database with SQLPlus

Modify database installation parameters

Describe the stages of database startup

Describe database shutdown options

View the alert log

Access dynamic performance views

Manage the ASM Instance

Set up initialization parameter files for ASM instance

Start up and shut down ASM instances

Administer ASM disk groups

Configuring the Oracle Network Environment

Use Enterprise Manager to create and configure the Listener

Enable Oracle Restart to monitor the listener

Use tnsping to test Oracle Net connectivity

Identify when to use shared servers and when to use dedicated servers

Managing Database Storage Structures

Storage Structures

How Table Data Is Stored

Anatomy of a Database Block

Space Management in Tablespaces

Tablespaces in the Preconfigured Database

Actions with Tablespaces

Oracle Managed Files (OMF)

Administering User Security

Database User Accounts

Predefined Administrative Accounts

Benefits of Roles

Predefined Roles Implementing Profiles

Managing Data Concurrency

Data Concurrency

Enqueue Mechanism

Resolving Lock Conflicts

Deadlocks

Managing Undo Data

Data Manipulation

Transactions and Undo Data

Undo Data Versus Redo Data

Configuring Undo Retention

Implementing Oracle Database Auditing

Describe DBA responsibilities for security

Enable standard database auditing

Specify audit options

Review audit information

Maintain the audit trail

Database Maintenance

Manage optimizer statistics

Manage the Automatic Workload Repository (AWR)

Use the Automatic Database Diagnostic Monitor (ADDM)

Describe and use the advisory framework

Set alert thresholds

Use server-generated alerts

Use automated tasks

Backup and Recovery Concepts

Part of Your Job

Statement Failure

User Error

Understanding Instance Recovery

Phases of Instance Recovery

Using the MTTR Advisor

Media Failure

Archive Log Files

Performing Database Backups

Backup Solutions: Overview

Oracle Secure Backup

User-Managed Backup

Terminology

Recovery Manager (RMAN)

Configuring Backup Settings

Backing Up the Control File to a Trace File

Monitoring the Flash Recovery Area

Performing Database Recovery

Opening a Database

Data Recovery Advisor

Loss of a Control File

Loss of a Redo Log File

Data Recovery Advisor

Data Failures

Listing Data Failures

Data Recovery Advisor Views

Moving Data

Describe ways to move data

Create and use directory objects

Use SQL*Loader to move data

Use external tables to move data

General architecture of Oracle Data Pump

Use Data Pump export and import to move data

Recent comments

Mahmood

"I have joined Oracle course In Globalerp solutions.. The faculties is Very Good Explaining way of Teaching,"

Alex

"Woked with the Global ERP Solutions team they have serviced as outstanding job. I recommend to Global ERP Solutions as a technology driven complete solution for current market driven companies. "

poojan

"Hi, very Delighted to learn Oracle course Here, our trainer is very Good Explaining way of Teaching..."