Oracle OCP 11g Certification
Starting dates and places
Description
Class room based practical training with free books included and unlimited number of practice hours and mock exams even after you have finished your course.
Oracle OCP 11g Certification
It is an undisputed fact that Oracle is one of the leading database management systems on offer out there. Through the Oracle 11g OCP course that we offer, you can be rest assured of success in your career in the fields of database administration and development. This highly advanced training program delves deep into every facet of the system in a way that other courses can't match up to; thus, giving you the advantage to stay ahead of the curve. In addition to the strategic curriculum, our instructors bring to the table the proficiency and commitment that we believe every student deserves. To put it simply, when it comes to OCP courses, this is the place to be!
…Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Class room based practical training with free books included and unlimited number of practice hours and mock exams even after you have finished your course.
Oracle OCP 11g Certification
It is an undisputed fact that Oracle is one of the leading database management systems on offer out there. Through the Oracle 11g OCP course that we offer, you can be rest assured of success in your career in the fields of database administration and development. This highly advanced training program delves deep into every facet of the system in a way that other courses can't match up to; thus, giving you the advantage to stay ahead of the curve. In addition to the strategic curriculum, our instructors bring to the table the proficiency and commitment that we believe every student deserves. To put it simply, when it comes to OCP courses, this is the place to be!
Oracle OCP Certification Course Content
Exam #1Z0-051 Oracle Database 11g: SQL Fundamentals I
Introduction to Oracle 11g Database
Architecture
Describe course objectives
Explore the Oracle 11g database architecture
SQL Select Statements
SELECT statement
List the capabilities of SQL SELECT statements
Differentiate between SQL statements and iSQL*Plus commands
Restricting and Sorting Data
Limit the rows retrieved by a query
Sort the rows retrieved by a query
Use ampersand substitution to restrict and sort output at
runtime
Single-Row Functions to Customize
Output
Functions available in SQL
Use character, number, conversion functions, and date functions in
SELECT statements
Using Conversion Functions and Conditional
Expressions
Various types of conversion functions that are available in
SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion
functions
Apply conditional expressions in a SELECT statement
Data from Multiple Tables
Write SELECT statements to access data from more than one table
using equality and nonequality 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
Group functions
GROUP BY clause
Include or exclude grouped rows by using the HAVING clause,
Subqueries
Describe the types of problems that subqueries can solve
Define subqueries
List the types of subqueries
Write single-row and multiple-row subqueries
Set Operators
Describe set operators
Use a set operator to combine multiple queries into a single
query
Control the order of rows returned
Producing Readable Output with
iSQL*Plus
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, Delete, Merge rows in a table
Control transactions
Creating and Managing Tables
Database objects, Create tables
Datatypes that can be used when specifying column
definition
Alter table definitions
Drop, rename and truncate tables
Constraints
Introduction to constraints
Create and maintain constraints
Creating Views
Introduction to view
Create, alter the definition, and drop a view
Retrieve data through a view
Insert, update and delete data through a view
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
Exam #1Z0-052 Oracle Database 11g: Administration I
Oracle Database Architecture
Memory Structures
Process Structures
Storage Structures
Oracle Database Environment
Oracle Database Administration, Planning and installation
Oracle Universal Installer (OUI), Oracle Database Installation
Oracle Database
Create, Configure and Manage Oracle Database
Database Configuration Assistant (DBCA)
Oracle Instance
Manage Oracle Database Instance
Database Initialization parameters
Stages of database startup and shutdown
View and manage Alert log and trace files
Data dictionary and dynamic performance views
Oracle Network Environment
Manage, Configure the Oracle Network
Oracle Shared Server architecture
Database Storage Structures
Manage Database Structures, Tablespace and datafiles
Create and manage tablespaces
Space management in tablespaces
Administering User Security in Oracle
Database
Create, Maintain and manage database user accounts
Grant and revoke privileges
Create and manage roles and profiles
Managing Schema Objects
Create and Modify tables
Manage Constraints
Create indexes
Create and use temporary tables
Data and Concurrency
Maintain and 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
Securing Oracle Database and Audit
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
Database 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 Oracle 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 file,
Redo log file and Data file)
Moving Data Method
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
Exam #1Z0-053 Oracle Database 11g: Administration II
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 Catalog
Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts
Back up the recovery catalog
Create virtual private catalog
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 multisection, 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 Tablespace 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 tablespaces 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 Setup
Customize language-dependent behavior for the database and
individual sessions
Working with database and NLS character sets
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.