Home | Career Tracks | Boot Camps | Course Search | Student Log In | Request Info | 1-800-482-3172 | Contact Us

About Us
Corporate IT Training
Vocational IT Training
CareerSource Solutions
Government/VA Solutions
Financing Options
Other Training Information
Student Resources
Entrance Exam TEST
Career Services
Promotions
Press Releases
Course Catalog
Course Search
Forms
Real Estate Classes
Store
Connect With Us

Oracle Database 10g: Administration I Boot Camp

 

 

Click Here to View Schedules & Pricing and to Enroll Online

 

 

Duration: 5 Days

  

 

Description:

 

This course is intended for Oracle Database 10g Administrators, Sales Consultants, Support Engineers, Oracle Software Developers, and Technical Consultants. Students should have some knowledge of Oracle database utilities, architecture, and terminology. Students will also have knowledge of SQL *Plus, iSQL *Plus, and PL/SQL.

 

 

What's Included:

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers  & Onsite Certification Testing
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

 

 

Course Outline:

 

Lesson 1: Installing Oracle Database 10g

Install Oracle Database 10g

Lesson 2: Exploring the Oracle Database 10g Architecture

Understand Database Architecture
Identify Database Object Types
Recognize the Oracle Instance
Understand the User Connection Process
Identify Resources for the DBA

Lesson 3: Creating a Database

Create, Configure, and Delete a Database Using the DBCA
Use Client and Administration Tools

Lesson 4: Configuring Oracle Net Services

Examine Oracle Net Services
Perform Basic Oracle Net Server-Side Configuration
Perform Basic Oracle Net Client-Side Configuration
Configure Oracle Shared Server
Configure Connect-Time Failover

Lesson 5: Using SQL and PL/SQL

Write Simple SQL SELECT Statements
Filter and Sort Data
Work with SQL Functions
Work with Multiple Tables
Modify Data
Control Database Transactions
Explore PL/SQL

Lesson 6: Managing the Database Instance

Obtain Instance Information
Manage the Database Instance
Organize Database Objects
Describe Database Objects and Their Storage

Lesson 7: Managing Tablespaces and Datafiles

Manage Tablespaces
Find Tablespace and Datafile Information
Resize and Drop Tablespaces
Configure Oracle Managed Files

Lesson 8: Managing Tables and Indexes

Create Tables
Gather and Analyze Table Information
Create Indexes
Implement Integrity Constraints
Maintain Integrity Constraints


Lesson 9: Creating Views and Sequences

Create Views
Create Sequences

Lesson 10: Managing Users and Security

Manage Users
Manage Privileges and Roles
Manage Passwords and Resource Limits
Audit Database Usage

Lesson 11: Monitoring Performance

Manage Locks
Gather and Use Tuning and Troubleshooting Information

Lesson 12: Loading and Unloading Data

Manage Data Using the Data Pump
Move Tablespaces
Load Data Using SQL*Loader
Create and Access External Tables

Lesson 13: Managing Undo Data

Configure Undo Segments and Tablespaces
Understand Automatic Undo Retention

Lesson 14: Administering and Performing Backups

Create Redo Log Groups and Members
Plan and Configure the Online Redo Log Group
Manage and Maintain Control Files
Back Up the Database
Examine Recovery Manager Concepts

Lesson 15: Administering and Performing Recovery Operations

Manage Recovery
Employ User-Managed and RMAN Recovery
Tune Database Recovery

 

Academy Code of Honor:  
The Academy guarantees that students shall pass all vendor examinations during the training program or may re-attend within one year of the program completion date. Students will only be responsible for accommodations and vendor exam fees.  

Student Login | Request Info | Course Search | Contact Us