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

Oracle Database 11g Administration: Hands-On

 
Course: 927   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Create, maintain and support Oracle 11g databases and instances
  • Automate database administration tasks with Oracle Enterprise Manager 11g Database Control
  • Provide transaction support and flashback capability with UNDO tablespaces
  • Control user access and ensure database security through privileges and roles
  • Employ effective storage management to maximize space usage
  • Partition large tables and indexes to ease administration and improve performance

Course Benefits

Oracle 11g is designed to handle the ever-increasing data needs of modern organizations. Effective management of Oracle 11g capabilities can help organizations ensure the integrity and security of data. In this hands-on course, you maximize the features of Oracle 11g to build and maintain databases, configure memory and storage for optimal performance, and manage large amounts of data.

Who Should Attend

Database administrators, developers with data management responsibilities and others involved in the management or deployment of Oracle 11g databases. Course 926, "Oracle Database 11g Comprehensive Introduction," or equivalent experience is assumed.

Hands-On Training

Extensive hands-on exercises using both GUI tools and SQL*Plus provide you with the practical skills to administer an Oracle 11g database. Exercises include:
  • Building an Oracle database
  • Troubleshooting with automated alerts
  • Managing tablespaces with different block sizes
  • Maintaining UNDO tablespaces and retention periods to enable and perform flashback operations
  • Securing data by controlling user access with privileges and roles
  • Monitoring and optimizing space usage
  • Setting up and maintaining partitioned objects

Related Courses

 
Oracle is a registered trademark of Oracle Corporation. 		 

Upcoming Dates

Oct 21 - 24, 2008
 Washington, DC (Rockville, MD)
Nov 18 - 21, 2008
 Toronto
Nov 18 - 21, 2008
 Washington, DC (Reston, VA)
Dec 2 - 5, 2008
 New York
Dec 9 - 12, 2008
 Washington, DC (Alexandria, VA)
Jan 6 - 9, 2009
 Chicago (Schaumburg)
Jan 20 - 23, 2009
 Los Angeles
Jan 27 - 30, 2009
 Washington, DC (Rockville, MD)
Feb 3 - 6, 2009
 Ottawa
Feb 24 - 27, 2009
 Washington, DC (Reston, VA)
Mar 3 - 6, 2009
 Toronto
Mar 10 - 13, 2009
 New York
Mar 24 - 27, 2009
 Washington, DC (Alexandria, VA)
Apr 14 - 17, 2009
 Chicago (Schaumburg)
May 5 - 8, 2009
 Ottawa

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

Oracle Database 11g Administration: Hands-On

 
Course: 927   Type: Hands-On Training   Duration: 4 Days
 
 
Course 927 Content
 

Introduction to Oracle Database 11g Administration

Your responsibilities as an Oracle 11g DBA

  • Configuring the instance and database
  • Maintaining security
  • Balancing user requirements and resources
  • Ensuring database availability

The Oracle 11g architecture

  • Processing transactions with the server
  • Identifying types of Oracle 11g processes and memory structures
  • Determining database file structure
  • Archiving redo log information
  • Sizing the Result Cache for optimizing repeated queries

Building an Oracle 11g Database

Creating the database

  • Setting the initialization parameters
  • Simplifying memory allocation with memory targets
  • Establishing network connectivity
  • Converting from text-based to server parameter files
  • Configuring control files and redo log files

Starting and stopping the database

  • Mounting and opening the database with SQL*Plus
  • Authenticating connections having SYSDBA privilege
  • Closing the database and shutting down the instance

Automating Database Management

The Oracle Enterprise Manager architecture

  • Navigating the graphical interface
  • Comparing command-line and graphical techniques

Administering with Database Control

  • Equipping Database Control to manage additional databases
  • Setting thresholds and generating alerts
  • Verifying changes in the data dictionary
  • Performing privilege management

Performing Flashback Operations

Managing space for rollback and read consistency

  • Configuring UNDO tablespaces
  • Monitoring expansion of rollback segments
  • Swapping to an alternative UNDO tablespace

Resetting data to recent points in time with flashback

  • Tracking changes to data values with row history
  • Obtaining transaction history with Flashback Transaction
  • Performing efficient recovery of data with Flashback Table
  • Retrieving dropped tables and dependent objects from the recycle bin

Securing the Database

Establishing user accounts

  • Authenticating users with sophisticated password checking
  • Allocating space quotas for user schemas
  • Limiting resource usage through profiles

Enforcing security

  • Granting and revoking system and object privileges
  • Simplifying privilege management with roles
  • Preventing changes to read-only tables

Controlling Database Storage

Defining logical and physical structures

  • Creating, altering, and dropping tablespaces
  • Handling sort data efficiently with temporary tablespaces
  • Comparing traditionally managed and Oracle-managed files

Configuring storage patterns for database objects

  • Structuring data and index segments
  • Sizing database objects by defining extents and block occupancy
  • Eliminating row migration with PCTFREE and Data Pump
  • Compressing table data to conserve storage
  • Shrinking tables and indexes online to regain space

Partitioning to Support Administration and Availability

Creating table partitions and subpartitions

  • Selecting partitioning methods: range, list, hash, interval
  • Partitioning tables based on virtual columns
  • Setting up automatic partition allocation
  • Referencing the partitioning method in child tables
  • Administering partitions with merge, split, add and drop

Maintaining index partitions

  • Maximizing performance with local and global indexes
  • Monitoring index partition usage
  • Rebuilding unusable indexes
 
http://www.learningtree.com/courses/927pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Oracle Database 11g Administration: Hands-On Tuition

 
Course: 927   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,650 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,385 Alumni Gold Discount
$ 2,360 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,665 per course
  • Savings as much as 40%
  • Only $4,990
Flex Pass
  • 3 courses in 24 months
  • As little as $1,830 per course
  • Save as much as 35%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $1,070 per course
  • Only $3,950
Training Vouchers
  • Save as much as $960 per course
  • Fully transferable
  • As low as $2,095 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 $295 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/927pf.htm