Part One of this course gives students the opportunity to explore and complete hands-on exercises with the new change management features and other key enhancements in Oracle Database 11g RLSE 2. The course covers installing the Enterprise edition, the upgrade to 11g, database replay, the SQL performance analyzer post upgrade, and an indepth look at the new features.
Course Objectives:
As a result of this training, you will be able to:
•Simplify database management by implementing manageability features
•Provide proactive database monitoring by utilizing database advisors
•Use improved RMAN, Data Pump, and Flashback features to increase data
availability
•Master database changes by using change management features
•Use the new features of SQL and PL/SQL
Course Pre-Requisites:
Attendees should have experience with Oracle Database 10g and the courses Oracle 10g: DBA I and II
Presentations:
240 Module 00: Course Introduction240 Module 01: Installation of Oracle 11g Enterprise Edition240 Module 02: Upgrading to 11240 Module 03: Database Replay: Setup and Capture240 Module 04: Database Replay: Prepare, Replay and Evaluate240 Module 05: LAB – Database Replay240 Module 06: The SQL Performance Analyzer: Capture and Pre-Change Workload240 Module 07: The SQL Performance Analyzer: Post-Upgrade240 Module 08: LAB – SQL Performance Analyzer240 Module 09: PL/SQL New Features – PART 1240 Module 10: LAB - PL/SQL Enhancements240 Module 11: PL/SQL New Features – PART 2240 Module 12: LAB - Trigger Enhancements240 Module 13: PL/SQL Function Result Cache240 Module 14: LAB - PL/SQL Function Result Cache240 Module 15: SQL New Features – PART 1240 Module 16: LAB - SQL and SQL Plan Baselining240 Module 17: Course Summary & Evaluation
There are no comments yet.