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 10g SQL Programming Training
* Oracle 10g Advanced SQL Programming Training
* Introduction to Oracle 10g PL/SQL Programming Training
* Oracle 10g Advanced PL/SQL Programming Training
* Oracle 10g Database Administration Training
* Oracle 10g Real Application Clusters for Administrators Training



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 10g Database Administration
Print This Outline
E-mail This Outline
Get A Quote
Course Number: 590
Duration: 5 days
view class outline

Oracle 10g Database Training Overview

In Accelebrate's Oracle 10g Database Administration training, students develop the key fundamental skills necessary to be an Oracle DBA. They design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student creates a toolkit of administration scripts for database management and tuning by the end of this class. This class will also address issues for DBAs having to support Oracle 8i and Oracle 9i databases.

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 10g Database Training Prerequisites

Accelebrate's Introduction to Oracle 10g SQL Programming course, or at least six months working in an Oracle technical environment. An understanding of relational database concepts, SQL, and PL/SQL programming skills are required. A solid understanding of Oracle schema is recommended.

Hands-on/Lecture Ratio

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

Oracle 10g Database Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

  • A complete installation of Oracle 10g

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

Oracle 10g Database Training Objectives

All attendees will learn how to:

  • Start and shutdown Oracle
  • Use the Oracle data dictionary
  • Manage database users and schemas
  • Set system privileges
  • Control parameter files
  • Work with datafiles and tablespaces
  • Use control files
  • Work with redo logs
  • Work with Undo segments
  • Manage segment space
  • Create and manipulate tables
  • Create and manipulate indexes
  • Apply constraints
  • Build views
  • Set object privileges
  • Use synonyms
  • Use the Optimizer
  • Use SQL*Loader
  • Backup databases
  • Recover databases
  • Use the Oracle Enterprise Manager

Oracle 10g Database Training Outline

  • Overview of Oracle Database
    • ORACLE_HOME and ORACLE_SID
    • The Oracle Database vs. The Oracle Instance
    • Instance Memory Structures
    • Background Processes
    • Server Processes
    • Datafiles
    • Blocks, Extents, and Segments
    • Control Files
    • Redo Logs
    • The Oracle Architecture
    • SYS and SYSTEM Users
  • Starting and Shutting Down an Oracle Database
    • SYSDBA and SYSOPER System Privileges
    • Oracle Database Startup
    • Oracle Database Shutdown
    • Altering Database Availability
    • Suspending and Resuming a Database
    • Quiescing a Database
    • Tracking Database Activity - The Alert Log
    • Data Dictionary Views for Startup and Shutdown
  • Using The Oracle Data Dictionary
    • Introducing the Data Dictionary
    • DBA, ALL, and USER Data Dictionary Views
    • V$ Dynamic Performance Views
    • Using Oracle Documentation to Locate Data Dictionary Views
    • Combining Data Dictionary Views
  • Oracle Database Users and Schemas
    • Users and Schemas
    • Oracle Default Database Users
    • Oracle Sample Schemas
    • Creating Users
    • Altering and Dropping Users
    • Data Dictionary Views For Users
  • Oracle System Privileges
    • Overview of System Privileges
    • Granting and Revoking System Privileges
    • Data Dictionary Views for System Privileges
    • Roles
    • Creating and Removing Roles
    • Data Dictionary Views for Roles
    • Pre-defined Roles
    • User Group PUBLIC
  • Parameter Files
    • Oracle Database Parameters
    • The Parameter File (PFILE) and the Server Parameter File (SPFILE)
    • Dynamic vs. Static Parameters
    • Determining Current Parameter Settings
    • Benefits of SPFILEs over PFILEs
    • Creating an SPFILE from a PFILE and Back Again
    • Understanding Scope
    • Session-Level Parameters
    • Data Dictionary Views for Parameters
  • Datafiles and Tablespaces
    • Datafiles Overview
    • Tablespaces Overview
    • SYSTEM and SYSAUX Tablespaces
    • Creating Tablespaces
    • Dictionary- and Locally-Managed Tablespaces
    • Locally-Managed Tablespace Extent Allocation
    • Temporary Tablespaces
    • Temporary Tablespace Groups
    • Default Tablespaces
    • Tablespace Quotas
    • Dropping and Altering a Tablespace
    • Renaming a Tablespace
    • Renaming or Relocating Datafiles
    • Bigfile Tablespaces
    • Data Dictionary Views for Datafiles and Tablespaces
  • Control Files
    • Control Files Overview
    • Database Parameters for Control Files
    • Backing Up Control Files
    • Restoring Control Files from Multiplexed Copies
    • Restoring Control Files from Backups
    • Moving Control Files
    • Data Dictionary Views for Control Files
  • Oracle Physical Structures — Online Redo Logs
    • Redo
    • Redo Log Files
    • Database Parameters for Redo
    • Sizing the Redo Log Files
    • How Many Redo Log Groups?
    • Creating Redo Logs
    • Removing Redo Logs
    • Renaming Redo Log Files
    • Forcing Log Switches
    • Archiving Redo Logs
    • Configuring Archive Log Mode
    • Database Parameters for Archiving
    • Data Dictionary Views for Redo Logs
  • Oracle Physical Structures — Undo Segments
    • Undo Overview
    • Database Parameters for Undo
    • Creating Undo Tablespaces
    • Altering and Dropping Undo Tablespaces
    • Switching Undo Tablespaces
    • Undo Advisor
    • Data Dictionary Views for Undo
  • Segment Space Management
    • Blocks, Extents and Segments
    • Fragmentation
    • Coalescing Fragmented Space
    • Manual Segment Space Usage
    • Automatic Segment Space Management
    • Data Dictionary Views for Physical Objects
  • Tables
    • Tables Overview
    • Physical Properties of Tables
    • Row Chaining and Row Migration
    • Creating Tables
    • Table Storage and Logging
    • Altering Tables
    • Dropping Tables
    • The Recycle Bin
    • The TRUNCATE COMMAND
    • Temporary Tables
    • Clustered Tables
    • Indexed-Organized Tables
    • Creating an IOT
    • Data Dictionary Views for Tables
  • Indexes
    • Indexes
    • B-tree Indexes
    • NULL Values and Indexes
    • NULL Values and Unique Indexes
    • Creating Indexes
    • Monitoring Index Usage
    • Dropping Indexes
    • Rebuilding and Moving Indexes
    • Coalescing Indexes
    • Bitmap Indexes
    • Special Index Types
    • Index Key Compression
    • Data Dictionary Views for Indexes
  • Constraints
    • Integrity Constraints
    • Constraint Names and Syntax
    • Constraint Checking
    • Managing Primary Key Constraints
    • Managing NOT NULL Constraints
    • Managing Check Constraints
    • Managing Foreign Key Constraints
    • Data Dictionary Views for Constraints
  • Views
    • Views
    • Creating and Replacing Views
    • Data Dictionary Views for Views
    • Security Through Views
    • Altering and Dropping Views
    • Dependencies and Views
    • Updating Data Through Views
  • Object Privileges
    • Object Privileges
    • Granting and Revoking Object Privileges
    • Using WITH GRANT OPTION
    • Revoking and the GRANT OPTION
    • Data Dictionary Views for Object Privileges
  • Synonyms
    • Synonyms
    • Private and Public Synonyms
    • Creating and Dropping Synonyms
    • Security through Synonyms
    • Object Precedence
  • The Optimizer and Statistics
    • Optimizer Overview
    • Optimizer Statistics
    • Data Dictionary Views and Statistics
    • Collecting Statistics
    • Removing Statistics
    • Automated Statistics Collection
  • Oracle Net Services
    • Oracle Networking Explained
    • The Net Configuration Assistant
    • Configuring the Listener — GUI
    • Configuring the Listener — Manually
    • Configuring the Client — GUI
    • Configuring the Client — Manually
  • Data Pump
    • Oracle Data Pump Architecture
    • Configuring for Data Pump
    • Command-Line Utilities
    • Exporting With expdp
    • Importing With impdp
    • Interactive Mode
    • Attaching to a Running Job
    • Parallel Data Pump
    • Data Dictionary Views for Data Pump
  • SQL*Loader and External Tables
    • SQL*Loader
    • SQL*Loader Control File
    • Loading Data with SQL*Loader
    • Conventional vs. Direct Path Loads
    • External Tables Overview
    • Creating an External Table
    • Creating a Writable External Table
  • Backup Your Database
    • Physical Backups vs. Logical Backups
    • Offline Backup Basics
    • Oracle Offline Backup Steps
    • Other Backup Considerations
    • Advanced Backup Concepts
    • RMAN
  • Recover Your Database
    • Offline Recovery Basics
    • Restoration Using Offline Backups for a NOARCHIVE Database
    • Restoring Other Files
    • Other Recovery Considerations
  • Oracle Enterprise Manager
    • Introducing Oracle Enterprise Manager
    • OEM Architecture and Physical Structure
    • Installing OEM When Using DBCA
    • Using EMCA to Install OEM
    • Managing OEM
    • Removing OEM
    • Troubleshooting OEM
    • Securing OEM
    • Starting OEM
    • Introducing the OEM Home Pages
    • Using OEM — Managing the Job Scheduler
    • Using OEM — Using Metrics, Alerts, and Thresholds
    • Automatic Workload Repository
    • The Automatic Database Diagnostic Monitor — ADDM
    • OEM and Advisors
    • The SQL Access Advisor
  • Conclusion
 
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