You are here: Home >> Oracle Database 11g OCP Certification >>
Oracle Database 11g OCP Certification
Certification
Number of exam(s)
|
Course Length
Locations
|
Delivery
Includes
|
Oracle 11g OCP Certification - Exams
- Oracle OCP Exam #1Z0-051 - Oracle Database 11g: SQL Fundamentals I
- Oracle OCP Exam #1Z0-052 - Oracle Database 11g: Administration I
- Oracle OCP Exam #1Z0-053 - Oracle Database 11g: Administration II
- Oracle Official Requirement:
Hands-on course with Oracle Certified Centers (Fulfilled requirement by doing training with us)
- SQL Fundamentals, Select Statement, Restricting and Sort Data
- Row limit, Single Row Function, TO_CHAR, TO_NUMBER, and TO_DATE conversion functions, Group Function, Clause
- Multiple Tables, Join and outer joins, Cartesian
- All rows from two or more, Subqueries
- Set Operators, Single query, DML, Insert, Update, Delete rows into table, DDL
- Create and Manage Tables, database objects
- Table structure, data types, schema objects
- Views, indexes, private and public synonyms
- Oracle Database Architecture, Memory structures, Process Structures, Storage Structures
- Database Environment, Tools for Administering Oracle Database
- Oracle Database Installation, Oracle Software, Oracle Universal Installer
- Create Oracle Database, Database configuration assistant DBCA
- Oracle Instance, Database initialization parameters, database startup and shutdown
- Alert log and trace files, data dictory and dynamic performance views
- Oracle Network Environment, Oracle Shared Server architecture.
- Oracle Network Environment
- Oracle Shared Server architecture
- Manage Database Storage Structures, tablespace and datafiles
- Administering User Security
- Managing Data and Concurrency
- Managing Undo Data, Implementing Oracle Database Security.
- Standard Database Auditing, Database Maintenance
- Automatic Workload Repository AWR, Manage Alerts and Thresholds
- Performance Management, Memory, Managing Patches
- Backup and Recovery Concepts
- Database failure, Database Backup and Recovery,
- Checkpoints, redo log files, archived log files,
- Performance Management, Instance recovery, flash recovery area, ARCHIVELOG mode,
- Performing Database Backups, shutting it down
- Create incremental backups, automate database backups, Flash recovery area.
- Database Recovery, Advisor, control file, Redo log file and Data file, Moving Data, SQL loader, External Tables
- Oracle Data Pump, Export and Import, move data between Oracle databases.
- Automatic Storage Management (ASM), ASM disk groups,
- Initialization parameter files for ASM
- Configure Recoverability, Flash recovery area
- Flash Recovery Area, Flash Recovery Area
- RMAN Recovery Catalog, Recovery catalog, RMAN Stored scripts
- Back up the recovery catalog, Virtual Private catalog
- Configuring Backup Specifications, backup settings
- Virtual Private catalog, Backup Specifications, Backup settings, Backup Optimization
- RMAN, create image file backups, whole database backup, incremental backup, duplex backup and back up backup sets, archival backup
- multisection, compressed and encrypted backup
- Recover from a lost TEMP file, Lost redo log group, loss of password file,
- Complete database recovery, incomplete database recovery
- User managed and server managed backups.
- RMAN recovery, critical or noncritical data file
- Perform Disaster recovery, RMAN to Duplicate a Database
- Perform Tablespace point-in-time recovery, TSPITR
- Configure RMAN for Asynchronous I/O
- Flashback Technology, Restore dropped tables from the recycle bin
- Monitor Flashback Database, Flashback Data Archive
- Diagnosing the Database, Automatic Diagnostic Repository
- Support Workbench, Perform Block Media Recovery.
- Managing Memory, Automatic Memory Management, SGA Parameters, PGA Memory Management
- SQL Tuning Advisor, SQL Access, Database Replay
- Space management, indexes using the segment shrink functionality
- Database resource manager, Automating Task with Scheduler
- Time-based or event-based schedule for executing scheduler jobs, prioritize jobs.
Price Includes: £1890
- Hands-on tutor led training
- Unlimited practice lab access
- Books, cds and Manuals
- VAT
- Refreshments
- Completion Certificate
Course Description
Gain a strong foundation in the industry's most advanced DBMS - Oracle. Get the Oracle Database 11g Administration certification - become a Certified Associate, Certified Professional or Certified Master. There are multiple examinations at each level, and you need both professional guidance and training to get you there.
The OCP 11g Courses offer various schedules depending on the chosen Certification and your electives. Learn Oracle SQL, Database fundamentals and concepts, and Oracle 11g Administration. The OCP certification paths also require you to attend a fixed number of sessions of approved instructor-led or online classes. Strong foundation and hands-on learning experience will give you the required edge to get the certification
100% Verified Reviews
Career Package
Specialised Package
Professional Package
Previous Training Participants
