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 Administration Training: Oracle 11g Administration I
Print This Outline
E-mail This Outline
Get A Quote
Course Number: 574
Duration: 5 days
view class outline

Oracle 11g Administration Training Overview

This Oracle 11g administration training course teaches attendees the skills necessary for day-to-day administration 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 Administration Training Prerequisites

No prior experience is presumed.

Hands-on/Lecture Ratio

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

Oracle 11g Administration 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 Administration Training Objectives

All attendees will learn how to:

  • Install software and create new databases
  • Explore the database architecture, including memory, process and data structures, and the management of those structures
  • Manage of database files
  • Explore specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components
  • Manage security policies and procedures, including administration of user accounts, roles, privileges and profiles
  • Use advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, Database Advisors and other components of the Management Framework
  • Performance monitoring, problem troubleshooting, and resolving lock and conflict issues
  • Use the Oracle Enterprise Manager and SQL interfaces for administration tasks
  • Control database support services, including the Database Control, Oracle Net and others
  • Learn backup and recovery structures and strategies
  • Investigate operating system-specific considerations for various platforms, especially Linux and MS Windows Server

Oracle 11g Administration Training Outline

  • Enterprise Edition Installation
    • Identify System Requirements
    • The Optimal Flexible Architecture (OFA)
    • Oracle_Base
    • Oracle_Home
    • Configure the Installation Environment
    • Enterprise Edition Installation
    • DBCA
  • The Administrator Interface
    • Enterprise Manager Tour
    • Using EM SQL Worksheet
    • Duties of A Database Administrator
    • Exploring the Oracle Database Architecture: General
  • The Oracle Enterprise Architecture
  • Exploring the Oracle Database Architecture: Instance Memory
    • What Is an Oracle Database Instance?
    • More about the System Global Area (SGA)
    • About the PGA
    • Managing Memory
  • Exploring the Oracle Database Architecture: Instance Processes
    • Instance Background Processes
    • SQL Execution Processes
  • Creating an Oracle Database
    • Create A New Database
    • Configure an Existing Database
    • Drop A Database
    • Manage DBCA Templates
    • Manually Create A Database
  • Managing the Database Instance
    • Configuring A Linux Environment
    • Starting & Stopping Database Control
    • Starting & Stopping the Database Listener
    • Starting & Stopping the Database Instance
    • More about the Database Files
  • Manage Database Storage Structures: Tablespaces
    • about Tablespaces
    • Tablespace Management
    • Drop Tablespace
    • Alter Tablespace
  • Manage Database Storage Structures: Advanced Tablespaces
    • More about Temporary Tablespaces
    • about Temporary Tablespace Groups
    • More about Permanent Tablespaces
    • More about Bigfile Tablespaces
    • More about the Sysaux Tablespace
  • Manage Database Storage Structures
    • Data Files & Temp Files
    • Managing Data Files
    • Managing Temp Files
    • Enable Oracle-Managed Files (OMF)
  • Managing Undo Data
    • about Undo Space Management
    • Configure Automatic Undo Management
    • Undo_Management
    • Undo_Tablespace
    • Undo_Retention
    • Guarantee Undo Retention
    • Monitor Undo Space
    • Use the Undo Advisor
  • Network Environment: Oracle Shared Servers
    • Shared Servers Architecture
    • Configure Shared Servers
    • Monitor Shared Servers
    • V$Shared_Server
    • V$Shared_Server_Monitor
    • V$Session
    • V$Circuit
    • V$Dispatcher & V$Dispatcher_Config
    • V$Queue
  • Security: Implementing Database Security
    • Database System Privileges
    • Database Object Privileges
    • Administrator Auditing Of Database Activity
    • Enhanced Default Security Settings
  • Security: Administering User Security
    • Create & Manage Database Accounts
    • Grant & Revoke Database Privileges
    • Resource Limits Via Profiles
    • Alter Profile
    • Drop Profile
    • Password Management Via Profiles
    • about Role-Based Security
    • With Admin Option
    • Alter User...Default Role
    • Set Role
    • Enhanced Default Security Settings
  • Moving Data: SQL Loader
    • Loader Concepts
    • Control File Options
    • Load Methods
    • Using the EM Interface
  • Moving Data: Export & Import
    • Manage Directory Objects
    • about the Data Pump Architecture
    • Data Pump Export
    • Data Pump Import
    • Data Pump Data Dictionary Views
    • Using the EM Interface
  • Database Maintenance & Performance Management
    • the Management & Advisory Framework
    • Manage the Automatic Workload Repository
    • Automatic Database Diagnostic Monitor
    • Use Metrics & Alert Thresholds
    • Automatic Maintenance Tasks
  • Managing Concurrency & Locks
    • about Latches & Locks
    • Manage & Monitor Latches
    • Manage & Monitor Locks
    • V$Lock
    • V$Locked_Object
    • V$Session
    • V$Session_Wait
    • Dba_Blockers & Dba_Waiters
    • Dba_DML_Locks & Dba_DDL_Locks
    • DML_Locks
  • Backup & Recovery Concepts & Configuration
    • About Database Backup & Recovery Structures
    • Managing Redo Data
    • Managing Archival Data
    • Automatic Crash Recovery
    • Creating A Basic Backup Strategy
  • 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