1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Oracle Database 10g Administration: Hands-On

 
Course: 594   Type: Hands-On Training   Duration: 5 Days
 
 

You Will Learn How To

  • Create, configure and maintain Oracle 10g databases
  • Optimize space and performance for effective storage management
  • Maximize database efficiency using the Oracle Enterprise Manager
  • Ensure database security by managing user privileges and roles
  • Implement Oracle partitions to manage large tables and indexes
  • Deploy appropriate backup, recovery and flashback procedures

Course Benefits

Databases represent the core of an organization's informational infrastructure. To effectively maintain those databases, it is imperative for administrators to be well trained. In this hands-on course, you gain the knowledge and skills to create and configure Oracle 10g databases, manage memory and storage effectively, and deploy essential procedures to maintain your organization's database and ensure its availability.

Who Should Attend

Administrators and others involved in the management of Oracle 10g databases. Course 593, "Oracle Database 10g Comprehensive Introduction," or equivalent experience is assumed.

Hands-On Training

Exercises provide the practical skills to administer Oracle databases, including:
  • Building, starting up and shutting down the database
  • Creating and maintaining tablespaces
  • Configuring UNDO tablespaces and retention periods
  • Administering partitioned objects
  • Safeguarding using backup and restore techniques
  • Retrieving lost data from hardware and software failure
  • Managing user resources and privileges
  • Redefining, reorganizing and shrinking tables online
  • Recovering from user error with flashback operations

Related Courses

 
Oracle is a registered trademark of Oracle Corporation. 		 

Upcoming Dates

Oct 27 - 31, 2008
 Toronto
Nov 10 - 14, 2008
 Ottawa
Nov 17 - 21, 2008
 Washington, DC (Rockville, MD)
Dec 1 - 5, 2008
 Los Angeles
Dec 8 - 12, 2008
 Chicago (Downtown)
Dec 15 - 19, 2008
 Baltimore
Dec 15 - 19, 2008
 New York
Jan 5 - 9, 2009
 Washington, DC (Reston, VA)
Jan 12 - 16, 2009
 Dallas
Jan 26 - 30, 2009
 Irvine, CA
Feb 2 - 6, 2009
 Annapolis, MD
Feb 9 - 13, 2009
 Atlanta
Feb 23 - 27, 2009
 Toronto
Feb 23 - 27, 2009
 Washington, DC (Rockville, MD)
Mar 2 - 6, 2009
 Washington, DC (Alexandria, VA)

For complete schedule, please visit www.learningtree.com
 
http://www.learningtree.com/courses/594pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Oracle Database 10g Administration: Hands-On

 
Course: 594   Type: Hands-On Training   Duration: 5 Days
 
 
Course 594 Content
 

Overview of Oracle 10g Administration

Your responsibilities as an Oracle DBA

  • Configuring Oracle 10g databases
  • Controlling user access and operations
  • Monitoring system usage
  • Ensuring database availability

The Oracle 10g architecture

  • Instances vs. databases
  • Oracle processes and memory usage
  • Determining database file structure
  • Processing transactions with Oracle 10g

Constructing an Oracle 10g Database

Creating and dropping the database

  • Setting the initialization parameters
  • Dynamic and static parameters
  • Creating control files and log files
  • Reducing administration with Oracle managed files

Defining tablespace structure

  • Supporting applications that require multiple block sizes
  • Creating UNDO and SYSAUX tablespaces

Starting and stopping the database

  • Mounting and opening the database
  • Text-based and server parameter files
  • Connecting with SYSDBA privilege

Performing Space Management

Logical and physical storage structures

  • Improving sort performance
  • Bigfile and locally managed tablespaces

Controlling storage for database objects

  • Managing space with PCTFREE/PCTUSED
  • Moving and redefining tables online
  • Shrinking tables online to regain space
  • Resuming operations after failures
  • Managing LOB storage with chunks

Automating Database Management with Oracle Enterprise Manager (OEM) 10g Database Control

The OEM architecture

  • Strengths and weaknesses of OEM
  • Navigating the graphical interface

Administering with Database Control

  • Setting thresholds and generating alerts
  • Verifying changes in the data dictionary

Managing Users and Resources

Creating user accounts

  • Implementing password controls
  • Allocating space quotas on tablespaces
  • Limiting resource usage with profiles

Maintaining security

  • System and object privileges
  • Setting up and working with roles
  • Transparently encrypting data

Enhancing Availability and Administration with Partitions

Building table partitions and subpartitions

  • Partitioning types: range, hash and list
  • Tailoring storage for individual partitions
  • Splitting and merging partitions

Configuring index partitions

  • Deploying local, global, prefixed and non-prefixed indexes
  • Rebuilding unusable indexes

Backing Up and Recovering the Database

Safeguarding the database

  • Role of the redo log and control file
  • Ensuring recovery using archiving
  • Protecting and tracing the control file

Selecting a backup strategy

  • Implementing hot and cold backups
  • Partial online and offline backups
  • Restoring tables with Data Pump

Performing recovery of the database

  • Recovering corrupted tablespaces
  • Tracking row history with flashback
  • Restoring dropped tables from the recycle bin

Fundamental Tuning Concepts

  • Sizing the buffer cache and shared pool
  • Balancing disk I/O and memory allocation
  • Index storage considerations
 
http://www.learningtree.com/courses/594pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Oracle Database 10g Administration: Hands-On Tuition

 
Course: 594   Type: Hands-On Training   Duration: 5 Days
 
 

Course Tuition
$ 3,090 Standard Tuition
Tuition with a Savings Plan
$ 2,250 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,785 Alumni Gold Discount
$ 2,744 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 40%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,700 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.com/courses/594pf.htm