New Learning | Premium Moodle Theme

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

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

During this Course you will learn to: 

  • Implement manageability features to simplify database management
  • Use change management features to master database changes
  • Use database advisors to provide proactive database monitoring
  • Increase data availability by using ASM, Rman and Flashback feature enhancements

 

This course in is suggested for:

  • Database Administrators
  • Sales Consultants
  • Support Engineer
  • Data Warehouse Adminstrator
  • Technical Consultant

 

Objectives of this course:

  • Install Oracle Grid Infrastructure
  • Install Oracle Database 11g Release2
  • Use Oracle Restart to manage components
  • Use Automatic Storage Management (ASM) enhancements 
  • Implement table compression and hybrid columnar compression
  • Implement data warehousing and partitioning enhancements
  • Use the SQL Performance Analyzer
  • Use SQL Plan Management and load SQL plan baselines 
  • Use Database Replay to record and replay workloads
  • Set and manage Automatic SQL Tuning 
  • Use Resource Manager enhancements 
  • Use Enterprise Manager to monitor SQL commands 
  • Use the new and enhanced RMAN features 
  • Use Total Recall to create, protect, and use history data 
  • Use Data Pump in legacy mode
  • Use Data Recovery Advisor

 

Prerequisites

Required:

  • Working Knowledge of Oracle Database 10g

Suggested: 

  • Oracle Database 10g: Administration Workshop I Release 2
  • Oracle Database 10g: Administration Workshop II Release 2

Curriculum

Oracle Grid Infrastructure 

  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Creating an ASM Disk Group
  • ASM Cluster File System
  • ASM Dynamic Volume Manager
  • ASM File System Snapshot 

 

Installation and Update Enhancements

  • Installing Oracle Database 11g Release 2
  • Oracle Database Upgrade Enhancements
  • Online Patching 
  • Upgrading Your Time Zone File and Timestamp with Time Zone Data

 

Oracle Restart

  • Controlling Oracle Restart
  • Using the srvctl Utility
  • Manually Adding Components to the Oracle Restart Configuration

 

ASM Enhancements

  • Setting up ASM fast Mirror resync 
  • Using ASM Scalability and Performance Enhancements
  • ASM Disk Group Compatibility
  • Using ASMCMD Extensions
  • ASM File Access Control
  • ASM Optimal Disk Placement 

 

Storage Enhancements

  • Using 4 KB-Sector Disks
  • Using Table Compression
  • Hybrid Columnar Compression
  • SQL Access Advisor 
  • Segment Creation on Demand

 

Data Warehouse and Partitioning Enhancements

  • Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
  • Degree of Parallelism Enhancements
  • In-Memory Parallel Query
  • Partitioning Enhancements
  • In-Memory Parallel Query
  • Partitioning Enhancements
  • System-Managed Indexes for List Partitioning

 

Oracle SecureFiles

  • Enabling SecureFiles Storage
  • Creating SecureFiles 
  • Using SecureFile Compression
  • Accessing SecureFiles Metadata
  • Migrating to SecureFiles

 

Security and Networking Enhancements

  • Secure Password Support
  • Automatic Secure Configuration
  • Managing Default Audits
  • Setting Database Administrator Authentication
  • Transparent Data Encryption
  • Hardware Security Module
  • Tablespace Master Key Re-Key
  • Supporting IPv6 Address Notification

 

SQL Performance Analyzer

  • SQL Preformance Analyzer: Overview 
  • Using SQL Performance Analyzer
  • Using Enterprise Manager to Access SQL Performance Analyzer
  • SQL Performance Analyzer: PL/SQL Example
  • SQL Performance Analyzer: Data Dictionary Views 

 

SQL Plan Management 

  • SQL Plan Management: Overview 
  • Loading SQL Plan Baselines
  • Using the MIGRATE_STORED_OUTLINE Functions
  • Viewing Important Baseline SQL Plan Attributes
  • Loading a SQL Plan Baseline Automatically
  • Purging SQL Management Base Policy 

 

Database Replay

  • Using Database Replay
  • Database Replay System Architecture
  • Supported Workloads
  • Database Replay Workflow in Enterprise Manager 
  • Database Replay PL/SQL Procedures 
  • Database Replay Data Dictionary Views

 

Automatic SQL Tuning 

  • Automatic SQL Tuning in Oracle Database 11g
  • Selecting Potential SQL Statements for Tuning
  • Controlling the Automatic SQL Tuning Task
  • Configuring Automatic SQL Tuning 
  • Using the PL/SQL Interface to Generate Reports 

 

Intelligent Infrastructure Enhancements

  • Using New Automatic Workload Repository Views
  • Creating AWR Baselines 
  • Defining Alert Thresholds Using Static Baseline 
  • Controlling Automatic Maintenance Tasks
  • Fixed Policy CPU Resource Management
  • Instance Caging 
  • Scheduler Enhancements

 

Diagnosability Enhancements 

  • Setting up Automatic Dignostic Repository
  • ADRCI: The ADR Command-Line Tool
  • Incident Packaging Service (IPS)
  • Using the Enterprise Manager Support Workbench
  • Invoking IPS Using ADRCI
  • Running Health checks Manually 
  • Using the SQL Repair Advisor 

 

SQL Monitoring

  • SQL Monitoring in Oracle Database 11g Release 2
  • Viewing Session Details 
  • Viewing the SQL Monitoring Report

 

Performance Enhancements

  • Using the DBMS_ADDM Package
  • New and Modified Views 
  • Enabiling Automatic Memory Management
  • Using New Statistic Preferences Features
  • Locking Enhancements
  • Adaptive Cursor Sharing 
  • Using Table Annotation to Control Result Caching

 

Application Maintenance and Upgrade Enhancements

  • Online Redeftinition Enhancements
  • Creating and Using Invisible Indexes

 

Backup and Recovery Enhancements

  • Using New SET NEWNAME Clauses
  • Optimized Backups
  • Using New Settings for Binary Compression
  • Enhancements to Database Duplication
  • Creating Archival Backups
  • TSPITR Enhancements and Modifications
  • Creating and Using Virtual Private Catalogs
  • Introduction to Oracle Secure Backup Cloud Module

 

Flashback Technology, LogMiner, and Data Pump

  • Oracle Total Recall
  • Flashback Transaction Backout 
  • Enterprise Manager LogMiner Interface
  • Data Pump Legacy Mode

 

Data Recovery Advisor

  • Assessing Data Failures
  • Data Recovery Advisor RMAN Command-Line Interface
  • Data Recovery Advisor Views 
  • Setting Parameters to Detect Corruption 

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- (excluding 1-day Adobe, 1-day MS Office and PMP Boot Camps) 
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

Training Formats

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

Instructor Led (the best training format we offer)
Live Online Classroom – Online Instructor Led
Self-Paced Video

Speak to an Admissions Representative for complete details

By far the most competitve price we found, which included exam vouchers, hands on labs, practice test and a true Master of Cyber Security concepts as our Instructor. Franklin Mesa was the best trainer I have ever had and i walked out certified on the last day of my CompTIA Security+ certification bootcamp. 

Marc Alfonso - CompTIA Security + Student

 

The Academy is one of the best educational values for today's job market.  I studied hard and got certified (A+ and N+).  Even though I had no prior IT experience, I now have a good job replacing obsolete computers in hospitals throughout the country.  At my job interview, I just slid my test scores and certification across the table to the interviewer, who is now my boss.  I was hired the next day.  

Not bad for a 65 year old.

John Arnett- Student 

"I congratulate The Academy for a great facility and good lab computers. The Academy is great and I will definitely be taking more courses and utilizing the services available. Omer Palo is an excellent instructor that truly knows his material. I never felt bored in his class which is a first for me. Thank You."

IT Director, Burger King Corporation

"The instructor Frank Martinez is excellent – he covered so much material in 2 weeks that was unbelievable! He definitely knows what he does and it shows in the way that he conducts each lecture. He is the greatest!"
"Thanks Academy for allowing me to experience the MCSA / MCSE + Security Boot camp."

IT Professional, Florida International University

 

Schedules

Contact Us


THE ACADEMY

1.800.482.3172

FTL: 954.351.7040

MIA: 305.648.2000


Request More Information

 

Current Promotions!

 

  _____________________________________

 

 

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!

          

 

Students - Orbund Log-In