Certification Exam Prep Seminar: Upgrade Oracle Certified Professional (OCP) to Oracle Database 11g

Total time

Certification Exam Prep Seminar: Upgrade Oracle Certified Professional (OCP) to Oracle Database 11g

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

This video seminar – Certification Exam Prep Seminar: Upgrade Oracle Certified Professional (OCP) to Oracle Database 11g - will help you significantly in your preparation to take either of the following Oracle Database 11g certification exams:

  • Oracle Database 11g: New Features for Administrators (1Z0-050)
  • Oracle Database 11g: New Features for 9i OCPs (1Z0-055)

Become ready to take and pass the upgrade exam for the "Oracle Database 11g Administrator Oracle Certified Professional (OCP)" certification with this comprehensive Exam Preparation Seminar. Led by one of our Oracle Database expert instructors, this fast-paced seminar will help increase your confidence by providing you with ex…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 11G, Oracle 10G, Oracle, CompTIA A+ / Network+ / Security+, and IT Security.

This video seminar – Certification Exam Prep Seminar: Upgrade Oracle Certified Professional (OCP) to Oracle Database 11g - will help you significantly in your preparation to take either of the following Oracle Database 11g certification exams:

  • Oracle Database 11g: New Features for Administrators (1Z0-050)
  • Oracle Database 11g: New Features for 9i OCPs (1Z0-055)

Become ready to take and pass the upgrade exam for the "Oracle Database 11g Administrator Oracle Certified Professional (OCP)" certification with this comprehensive Exam Preparation Seminar. Led by one of our Oracle Database expert instructors, this fast-paced seminar will help increase your confidence by providing you with exclusive tips and strategies for preparing and taking the exam.

This Exam Preparation Seminar is intended to help those with a solid foundation in Oracle Database 10g and/or 11g database administration. It provides a thorough review of the exam objectives and helps each student understand the topics and breadth required to become certified on Oracle Database 11g.

The seminar may be accessed for repeated review as needed during subscription term. Completion of this seminar does not guarantee exam performance. Exam Prep Seminars do not include: an Oracle University eKit, expert video, labs, student environment, simulations, student Q&A. Please note that this seminar is for exam review purposes only and does not meet the Hands-on Course training requirement (if applicable to your certification track).

Learn To:
  • Perform a skills & knowledge gap analysis that will help guide the balance of your study (included in the bonus materials)
  • Establish strategies that will help you be successful on the exam
  • Create a customized study plan (included in bonus materials) 

Audience
  • Database Designers
  • Project Manager
  • Sales Consultants
  • Support Engineer
  • Technical Administrator
  • Data Warehouse Administrator
  • Technical Consultant
  • Database Administrators

Course Topics Installation and Upgrade Enhancements
  • Install Oracle Database 11g
  • Upgrade your database to Oracle Database 11g
  • Oracle Direct NFS
  • Use online patching     
Storage Enhancements
  • Create and maintain bigfile tablespaces
  • Rename tablespaces
  • Create a default permanent tablespace
  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Execute SQL commands with ASM file names
  • Start up and shut down ASM instances
  • Administer ASM disk groups
Storage Enhancements - Continued
  • Setup ASM fast mirror resynch
  • Understand scalability and performance enhancements
  • Setup ASM disk group attributes
  • Use various new manageability options
  • Use ASMCMD Command-Line Interface
  • Use the md_backup, md_restore, and ASMCMD extensions
Space Management and Partitioning
  • Reduce space related error conditions through proactively managing tablespace usage
  • Reclaim wasted space from tables and indexes using the segment shrink functionality
  • Use the Segment Advisor
  • Automatic Undo Management
  • Use Automatic Undo Retention Tuning
  • Implement the new partitioning methods
  • Employ Data Compression
Miscellaneous New Features
  • Enhanced finer grained dependency management
  • Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes
  • Use Query Result Cache and PL/SQL Result Cache
  • Create temporary tablespace groups
  • Assign temporary tablespace groups to users
  • Temporary Tablespace Enhancements
  • Adaptive Cursor Sharing
Oracle SecureFiles
  • Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
  • Use SQL and PL/SQL APIs to access Secure File LOBs
Intelligent Infrastructure Enhancements
  • Monitor and maintain the AWR
  • Creating and using AWR baselines
  • Setting AWR Baseline Metric Thresholds
  • Control Automated Maintenance Tasks
  • Using Database Resource Manager New Features
  • Simplify management tasks by using the Scheduler
  • Create a job, program, schedule and window
  • Using new scheduler features
Intelligent Infrastructure Enhancements – Continued
  • View information about job executions and job instances
  • Monitor and manage server-generated alerts
Performance Enhancements
  • Use Automatic Database Diagnostic Monitor (ADDM)
  • ADDM Enhancments in 11g
  • Use Automatic Shared Memory Management
  • Setup Automatic Memory Management
  • Enhancements in statistics collection
SQL Tuning
  • Use the SQL Tuning Advisor
  • Setup and modify Automatic SQL Tuning
  • Interpret reports generated by Automatic SQL Tuning
  • SQL Access Advisor Overview
  • Create SQL Access Advisor analysis session using PL/SQL
SQL Performance Analyzer
  • Using SQL Performance Analyzer
SQL Plan Management
  • SQL Plan Baseline Architecture
  • Set up SQL Plan Baseline
  • Using SQL Plan Baseline
Database Replay
  • Overview of Workload Capture and Replay
  • Using Workload capture and replay
Load and Unload Data
  • Explain Data Pump architecture
  • Use Data Pump export and import
  • Monitor a Data Pump job
  • Create external tables for data population
  • Transport tablespaces across different platforms
Simplify file management for all recovery-related file
  • Speed backup times by creating faster incremental backups
  • Reduce restore time by applying incremental backups to data file image copies
  • Simplify recovery after opening the database with the RESETLOGS option
  • Minimize load requirements by specifying limits in backup time windows
  • Save storage space through writing compressed backup sets
  • Managing Archive logs
  • Back up large files in multiple sections
  • Perform Archival Backups
Simplify file management for all recovery-related file - Continued
  • Duplicating a Database
  • Manage Recovery Catalogs
  • Create a virtual private catalog for RMAN
Using Flashback and Logminer
  • Configure and use Flashback Database
  • Recover dropped tables with the Flashback Drop feature
  • Retrieve row history information with the Flashback Versions Query feature
  • Audit or recover FROM transactions with the Flashback Transaction Query feature
  • Recover tables to a point in time with the Flashback Table feature
  • Back-out transactions using Flashback Transaction
  • Overview of Flashback Data Archive
  • Manage Flashback Data Archive
Using Flashback and Logminer - Continued
  • Back-out transactions using Flashback Transaction
  • Working with Logminer
Diagnosability Enhancements
  • Setup Automatic Diagnostic Repository
  • Use Support Workbench
  • Use SQL Repair Advisor
Using the Data Recovery Advisor
  • Overview of Data Recovery Advisor
  • Repairing data failures using Data Recovery Advisor
  • Perform proactive health check of the database
Security: New Features
  • Configure the password file to use case sensitive passwords
  • Encrypt a tablespace
  • Configure fined grained access to network services

Course Objectives
  • Learn from one of Oracle University's top instructors
  • Review key technologies and certification concepts tested in the
  • Prepare for your Oracle certification exam
  • Get information that will help you complete your preparation and study
  • Receive tips and information that will help you on the test
  • Understand the depth and breadth of the

There are no reviews yet.

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.