Oracle 9i DBA Boot Camp

Oracle 9i DBA Program

• Intensive Hands-on Training by Oracle Certified Instructors
• Comprehensive study materials and pre-class mentoring, courseware, comprehensive lab, and Testing software
• Roundtrip airfare
• Hotel accommodation for (14) days
• Lab and Instructor access day and evening
• Examination Vouchers and on-site Certification testing
• Breakfast, lunch, snacks, and freshly-brewed coffee
• Transportation to/from designated local airports
• Transportation to/from hotel from/to training site
• All certification exams plus free re-take
  

Oracle 9i DBA Certification Program Information
The Oracle Database Administration certification program was developed by Oracle Corporation to recognize technical professionals who demonstrate the knowledge and hands-on skills required to support Oracle's core products according to a standard established by Oracle Corporation.

Oracle 9i DBA Certification Track

Days	Recommended training	Exam
1-3	Introduction to Oracle 9i SQL	1Z0-007
4-7	Oracle 9i Database: Fundamentals I	1Z0-031
8-11	Oracle9i Database: Fundamentals II	1Z0-032
12-14	Oracle9i Database Performance Tuning	1Z0-033

Introduction to Oracle9i SQL

Course Objectives

• Describe relational and object relational database concepts
• Retrieve, insert, update, and delete data
• Use the Single row and Group functions
• Retrieve data using additional advanced techniques like using ROLLUP, CUBE, set operators, correlated subqueries and hierarchical queries
• Solve problems by using multicolumn subqueries, subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
• Use the iSQL*Plus environment
• Write scripts to generate script files
• Generate reports using iSQL*Plus
• Create and maintain database objects
• Control transactions
• Control data/user access
• Use the Oracle9i Single row functions
• Use GROUPING SETS and the WITH clause
• Use the Oracle9i extensions to DML and DDL statements
• Apply techniques in real life simulation

Oracle9i Database Administration Fundamentals I

Course Objectives

• Manage tablespaces, segments, extents, and blocks
• Manage users, privileges, and resources
• Create an operational database
• Start up and shut down an Oracle instance and database
• Manage Oracle database files
• Use Globalization Support features

Oracle9i Database Administration Fundamentals II

Course Objectives

• Define networking requirements and the solutions provided by Oracle to implement these requirements
• Perform database and datafile backups with and without Recovery Manager (RMAN)
• Configure the network environment for an Oracle client-server system
• List the different Oracle backup methods and recovery operations that can be used to resolve database failure
• Describe the database utilities (Export and Import) and the situations where they can be used
• Develop network configuration and recovery techniques through various workshop scenarios
• List the Oracle architecture components related to backup and recovery operations

Oracle9i Database Performance Tuning

Course Objectives

• Configure Resource Manager to control resource usage
• Configure an Oracle Database with an emphasis on good performance.
• Detect and resolve latch and lock contention problems within the Oracle database environment
• Diagnose and resolve performance issues associated with Shared Server
• Use Oracle tools to diagnose performance problems
• Utilize Enterprise Manager to perform Tuning tasks
• Perform day-to-day monitoring on an operational database using STATSPACK
• Identify and resolve I/O, data storage, and database configuration problems
• Configure memory and disk resources to optimize sort operations
• Reconfigure file structures for performance and other considerations
• List the important steps for outlining a tuning methodolog

Investment
$8,495.00