Database and Reporting Training     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
Crystal Reports Training * MySQL Training * Oracle Training * SQL Server Training * Live Online Training


 * Introduction to Oracle 11g SQL training
 * Beginning and Advanced Oracle 11g PL/SQL training
 * Oracle 11g Administration I training
 * Oracle 11g Administration II training
 * Oracle Data Warehousing and Warehouse Builder training
 * Oracle 11g Backup & Recovery training
 * Oracle 11g Features for Administrators



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary Database & Reporting Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour database or reporting training seminar. For more details, please contact us today.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

 

Oracle 11g Administration training: New Oracle 11g Features for Administrators

Print This Outline
E-mail This Outline
Get A Quote
Course Number: 578
Duration: 5 days
view class outline

Oracle 11g Features Training Overview

Accelebrate’s Oracle 11g Administration Training: New Oracle 11g Features for Administrators course teaches current Oracle systems administrators how to manage the new features of Oracle 11g.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/database.htm.

Oracle 11g Features Training Prerequisites

Experience administering an earlier version of Oracle is mandatory. If the attendees have not previously administered Oracle, they should take Oracle 11g Administration I training and Oracle 11g Administration II training.

Hands-on/Lecture Ratio

This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.

Oracle 11g Features Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

  • A complete installation of Oracle 11g

Please contact us for detailed setup instructions if you have purchased this class.

Oracle 11g Features Training Objectives

All attendees will:

  • Install and initially configure, or upgrade the Oracle 11g database software
  • Work within the structure of the changed Enterprise Manager (EM) interface and the database control
  • Discuss changes, enhancements and new features within the database architecture, the database parameters and the utilities and facilities used by administrators
  • Implement comprehensive Oracle 11g automatic memory management
  • Explore the Fault Diagnosability Infrastructure now included within the database and the first-failure data capture capabilities which enhance problem troubleshooting, diagnosis and resolution
  • Apply security enhancements including encryption of data, database security attack countermeasures, enhanced default security settings, and the SecureFiles storage mechanism
  • Implement Backup and recovery enhancements provided through the RMAN framework
  • Duplicate and clone databases for the creation of test platforms, standby database installations, and application workload replay
  • Guide recovery of database failures and corruption using the Data Recovery Advisor
  • Explore Automatic Storage Management (ASM) enhancements
  • Take advantage of storage improvements including advanced compression techniques and algorithms
  • Consider both the challenge and the necessity of changes to the systems infrastructure and how these can disrupt production applications
  • Review the goals of change management, change assurance and how these are implemented with Real Application Testing technology available with the Oracle 11g database. An entire volume has been dedicated to Real Application Testing
  • Perform the capture of a production database workload while not interfering with the applications or users involved
  • Replay the production workload on a test database configuration, providing a real-world test of how an actual application will function in an envisioned database configuration
  • Configure clients that will simulate the network interaction of real-world users in a test configuration
  • Perform a detailed analysis of application execution within proposed database configurations to assess whether application performance will progress or regress as a result of the proposed change
  • Use the SQL Performance Analyzer tool to measure progression or regression of individual SQL statements under a proposed database configuration, providing a detailed level of change assurance before the change ever occurs

Oracle 11g Features Training Outline

  • Database Installation & Upgrade
    • Identify System Requirements
    • The Optimal Flexible Architecture (OFA)
    • Oracle_Base
    • Oracle_Home
    • Configure The Installation Environment
    • Enterprise Edition Installation
    • DBCA
    • Database Upgrade Process
    • DBUA
    • Patching Overview
  • Database Architecture Changes
    • Review The Oracle Enterprise Architecture
    • More About The Oracle 11g Database
    • Undo_Management
  • Automatic Memory Management
    • About Memory Management
    • Automatic Memory Management
    • Memory_Target
    • Memory_Max_Target
    • Using EM & The Memory Advisors
  • Diagnosing Database Problems
    • About The Fault Diagnosability Infrastructure
    • Using The Alert Log
    • About The Trace Files
    • Database Instance Health Snapshot
    • Using The Support Workbench
    • Enable Oracle Configuration Manager
  • Security Enhancements
    • Transparent Data Encryption
    • Column Encryption
    • Tablespace Encryption
    • Data Pump Encryption
    • Backup Set Encryption
    • Enhanced Default Security Settings
    • Enhanced Security Options
  • Oracle Securefiles
    • Lob Concepts & Terminology
    • Basicfiles Lob
    • Alter Table
    • Securefiles Lobs
    • Migrating Basicfiles To Securefiles
    • Monitoring Securefiles Performance
  • Miscellaneous New Features
    • Locking Enhancements
    • Automatic Maintenance Tasks
    • Compression
    • ASM Enhancements
    • ASM_Preferred_Read_Failure_Groups
    • Compatible.ASM And Compatible.Rdbms
    • Disk_Repair_Time
  • Oracle Flashback Technology
    • About Flashback Technology
    • Flashback Query
    • Select...As Of Timestamp
    • Select...As Of SCN
    • Flashback Table
    • Flashback Drop
    • Flashback Versions Query
    • Flashback Transaction Query
    • Flashback Transaction Backout
  • Flashback Database
    • About Flashback Database
    • Configuring The Flash Recovery Area
    • Performing Database Flashback
    • Monitoring Flashback Performance
    • Flashback Database Considerations
    • Configure Flashback Data Archive
  • RMAN Enhancements
    • Virtual Private Catalogs
    • Building Dynamic Scripts
    • Backup Optimization
    • Enhancing Parallelism With Section Sizes
    • Archival Backups
  • Database Duplication & Cloning
    • Why Perform Database Duplication?
    • RMAN Duplicate Database
    • RMAN Duplicate
    • Database Cloning
  • Recovery With Data Recovery Advisor
    • Detecting Corruption
    • Db_Block_Checking
    • Db_Block_Checksum
    • Db_Lost_Write_Protect
    • Db_Ultra_Safe
    • Recovery Using The Data Recovery Advisor
  • Change Management
    • Understanding The Application Architecture
    • Systems Infrastructure Changes
    • Change Management Lifecycle
  • Workload Capture
    • Preparing The Capture Database
    • Workload Capture Using The EM Wizard
    • Workload Capture Using The API
  • Configure The Replay Database
    • Requirements Of A Replay Database
    • RMAN Duplicate
  • Database Replay
    • Preprocess Captured Workload
    • Replay Prerequisites
    • Replay Workload
    • Monitor The Replay Operation
  • Replay Analysis
    • Launch Replay Analysis
    • Conduct Configuration Change Analysis
    • Use The PL/SQL API
  • SQL Performance Analyzer
    • About SQL Performance Analysis
    • Managing SQL Tuning Sets
    • SQL Performance Analyzer Tasks
    • SQL Performance Analysis
  • Conclusion

© 2008 Sideris Courseware Corporation

 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.

Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.

 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!



VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK

About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Database and Reporting Training