1-800-THE-TREE (1-800-843-8733)
 

Oracle Database 10g Administration: Hands-On

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

Quick Enroll    

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

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

Related Courses
Oracle is a registered trademark of Oracle Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save an EXTRA $200 on a 10-Day Training Pass!

Oracle Database 10g Administration: Hands-On
Upcoming Dates
Aug 25 - 29, 2008
 Atlanta
Sep 8 - 12, 2008
 Washington, DC (Alexandria, VA)
Sep 22 - 26, 2008
 New York
Oct 6 - 10, 2008
 Washington, DC (Reston, VA)
Oct 20 - 24, 2008
 Annapolis, MD
Oct 27 - 31, 2008
 Toronto
Nov 3 - 7, 2008
 Philadelphia
Nov 10 - 14, 2008
 Ottawa
Nov 17 - 21, 2008
 Washington, DC (Rockville, MD)
Dec 1 - 5, 2008
 Los Angeles

Oracle Database 10g Administration: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,950 Standard Tuition
Tuition with a Savings Plan
$ 1,580 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,655 Alumni Gold Discount
$ 2,620 Government Discount
 

 

Oracle Database 10g Administration: Hands-On
Oracle Database 10g Administration: Hands-On
Course participants recovering data using the Oracle Database 10g flashback capability.
The most recent 100 evaluations scored this course at:

  (3.75/4.00)


Oracle Today


Certification Core Course CPE 29 Credits 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733