

1 877 849 1850	0808 234 2132	1 800 550 311	0 800 022 6730	+1 678 648 3113

Apache Hadoop Training

Crystal Reports Training

Please contact us
for GSA pricing.

Contract #
GS-35F-0307T

Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

Huntsville, Alabama
Montgomery / Birmingham, Alabama
Anchorage, Alaska
Edmonton & Calgary, Alberta
Phoenix, Arizona
Tucson, Arizona
Fayetteville / Little Rock, Arkansas
Amsterdam, The Netherlands / Brussels, Belgium
Vancouver, British Columbia
Oakland / San Jose / San Francisco, California
Sacramento, California
San Diego, California
Orange County / Los Angeles, California
Boulder / Colorado Springs / Denver, Colorado
Washington, DC
Wilmington, Delaware
Manchester / London, England
Orlando, Florida
Fort Lauderdale / Miami, Florida
Jacksonville, Florida
Saint Petersburg / Tampa, Florida
Alpharetta & Atlanta, Georgia
Augusta & Savannah, Georgia
Boise, Idaho
Chicago, Illinois
Indianapolis, Indiana
Cedar Rapids / Des Moines, Iowa
Dublin, Ireland
Wichita, Kansas
Lexington / Louisville, Kentucky
Baton Rouge/New Orleans, Louisiana
Portland, Maine
Hagerstown & Frederick, Maryland
Annapolis / Baltimore, Maryland
Boston / Cambridge, Massachusetts
Hartford, Connecticut / Springfield, Massachusetts
Ann Arbor / Detroit, Michigan
Grand Rapids, Michigan
Saint Paul / Minneapolis, Minnesota
Jackson, Mississippi
St. Louis, Missouri
Kansas City, Missouri
Lincoln / Omaha, Nebraska
Reno and Las Vegas, Nevada
Fredericton / Moncton / Saint John, New Brunswick
Albuquerque, New Mexico
Princeton, New Jersey & Philadelphia, Pennsylvania
Albany, New York
Buffalo, New York
White Plains / New York City, New York
Charlotte, North Carolina
Durham / Raleigh, North Carolina
Canton / Akron, Ohio
Cincinnati, Ohio
Cleveland & Columbus, Ohio
Dayton, Ohio
Tulsa / Oklahoma City, Oklahoma
Toronto, Ontario
Portland, Oregon
Pittsburgh, Pennsylvania
San Juan, Puerto Rico
Providence, Rhode Island
Saskatoon / Regina, Saskatchewan
Edinburgh / Glasgow, Scotland
Columbia & Charleston, South Carolina
Spartanburg & Greenville, South Carolina
Knoxville, Tennessee
Memphis / Nashville, Tennessee
Houston, Texas
El Paso, Texas
San Antonio / Austin, Texas
Dallas, Texas
Salt Lake City, Utah
Fairfax / Dulles / McLean / Herndon / Reston, Virginia
Richmond / Alexandria / Arlington, Virginia
Virginia Beach / Norfolk, Virginia
Tacoma / Seattle, Washington
Charleston, West Virginia
Madison / Milwaukee, Wisconsin

Oracle Administration Training: Oracle 10g Database Administration

Course Number: ORC-108
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. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, 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/?action=category&page=oracle.

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

Java^® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.

Oracle^®is a registered trademark of the Oracle Corporation 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^®
Focuses on You!

Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

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

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

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

“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.