Home | Career Tracks | Boot Camps | Course Search | Student Log In | Request Info | 1-800-482-3172 | Contact Us

About Us
Corporate IT Training
Vocational IT Training
CareerSource Solutions
Government/VA Solutions
Financing Options
Other Training Information
Student Resources
Entrance Exam TEST
Career Services
Promotions
Press Releases
Course Catalog
Course Search
Forms
Real Estate Classes
Store
Connect With Us

Oracle Database 11g: New Features for Administrators (Ed 2) Boot Camp

 

 

Click Here to View Schedules & Pricing and to Enroll Online

 

 

Duration: 5 Days

  

 

Description:

 

This five-day classroom course gives you the opportunity to learn about and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Topics covered include the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas of particular interest to database administrators. In addition, hands-on practice sessions help reinforce understanding of the new capabilities.Learn To: Implement manageability features to simplify database management. Use change management features to master database changes Use database advisers to provide proactive database monitoring. Increase data availability by using ASM, RMAN, and Flashback feature enhancements

 

 

 

Prerequisites:

 

Working knowledge of Oracle Database 10g

 

 

 

What's Included:

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers  & Onsite Certification Testing
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

 

 

Course Outline:

 

* Oracle Grid Infrastructure
o Installing Oracle Grid Infrastructure for a Standalone Server
o Creating an ASM Disk Group
o ASM Cluster File System
o ASM Dynamic Volume Manager
o ASM File System Snapshot
* Installation and Upgrade Enhancements
o Installing Oracle Database 11g Release 2
o Oracle Database Upgrade Enhancements
o Online Patching
o Upgrading Your Time Zone File and Timestamp with Time Zone Data
* Oracle Restart
o Controlling Oracle Restart
o Using the srvctl Utility
o Manually Adding Components to the Oracle Restart Configuration
* ASM Enhancements
o Seting up ASM fast mirror resync
o Using ASM Scalability and Performance Enhancements
o ASM Disk Group Compatibility
o Using ASMCMD Extensions
o ASM File Access Control
o ASM Optimal Disk Placement
* Storage Enhancements
o Using 4 KB-Sector Disks
o Using Table Compression
o Hybrid Columnar Compression
o SQL Access Advisor
o Segment Creation on Demand
* Data Warehouse and Partitioning Enhancements
o Pre-processing Data for ORACLE_LOADER Access Driver in External Tables
o Degree of Parallelism Enhancements
o In-Memory Parallel Query
o Partitioning Enhancements
o System-Managed Indexes for List Partitioning
* Oracle SecureFiles
o Enabling SecureFiles Storage
o Creating SecureFiles
o Using SecureFile Compression
o Accessing SecureFiles Metadata
o Migrating to SecureFiles
* Security and Networking Enhancements
o Secure Password Support
o Automatic Secure Configuration
o Managing Default Audits
o Setting Database Administrator Authentication
o Transparent Data Encryption
o Hardware Security Module
o Tablespace Master Key Re-Key
o Supporting IPv6 Address Notification
* SQL Performance Analyzer
o SQL Performance Analyzer: Overview
o Using SQL Performance Analyzer
o Using Enterprise Manager to Access SQL Performance Analyzer
o SQL Performance Analyzer: PL/SQL Example
o SQL Performance Analyzer: Data Dictionary Views
* SQL Plan Management
o SQL Plan Management: Overview
o Loading SQL Plan Baselines
o Using the MIGRATE_STORED_OUTLINE Functions
o Viewing Important Baseline SQL Plan Attributes
o Loading a SQL Plan Baseline Automatically
o Purging SQL Management Base Policy
* Database Replay
o Using Database Replay
o Database Replay System Architecture
o Supported Workloads
o Database Replay Workflow in Enterprise Manager
o Database Replay PL/SQL Procedures
o Database Replay Data Dictionary Views
* Automatic SQL Tuning
o Automatic SQL Tuning in Oracle Database 11g
o Selecting Potential SQL Statements for Tuning
o Controlling the Automatic SQL Tuning Task
o Configuring Automatic SQL Tuning
o Using the PL/SQL Interface to Generate Reports
* Intelligent Infrastructure Enhancements
o Using New Automatic Workload Repository Views
o Creating AWR Baselines
o Defining Alert Thresholds Using Static Baseline
o Controlling Automatic Maintenance Tasks
o Fixed Policy CPU Resource Management
o Instance Caging
o Scheduler Enhancements
* Diagnosability Enhancements
o Seting Up Automatic Diagnostic Repository
o ADRCI: The ADR Command-Line Tool
o Incident Packaging Service (IPS)
o Using the Enterprise Manager Support Workbench
o Invoking IPS Using ADRCI
o Running Health Checks Manually
o Using the SQL Repair Advisor
* SQL Monitoring
o SQL Monitoring in Oracle Database 11g Release 2
o Viewing Session Details
o Viewing the SQL Monitoring Report
* Performance Enhancements
o Using the DBMS_ADDM Package
o New and Modified Views
o Enabling Automatic Memory Management
o Using New Statistic Preferences Features
o Locking Enhancements
o Adaptive Cursor Sharing
o Using Table Annotation to Control Result Caching
* Application Maintenance and Upgrade Enhancements
o Online Redefinition Enhancements
o Creating and Using Invisible Indexes
* Backup and Recovery Enhancements
o Using New SET NEWNAME Clauses
o Optimized Backups
o Using New Settings for Binary Compression
o Enhancements to Database Duplication
o Creating Archival Backups
o TSPITR Enhancements and Modifications
o Creating and Using Virtual Private Catalogs
o Introduction to Oracle Secure Backup Cloud Module
* Flashback Technology, LogMiner, and Data Pump
o Oracle Total Recall
o Flashback Transaction Backout
o Enterprise Manager LogMiner Interface
o Data Pump Legacy Mode
* Data Recovery Advisor
o Assessing Data Failures
o Data Recovery Advisor RMAN Command-Line Interface
o Data Recovery Advisor Views
o Setting Parameters to Detect Corruption

 

 

Academy Code of Honor:  
The Academy guarantees that students shall pass all vendor examinations during the training program or may re-attend within one year of the program completion date. Students will only be responsible for accommodations and vendor exam fees.  

Student Login | Request Info | Course Search | Contact Us