Oracle 10g Training

Oracle 10g Training Course
Hosted by George J. Trujillo Jr.
Oracle training on 6 CD-ROMs

This Oracle 10g training teaches the fundamental skills for managing an Oracle database environment. Students will learn how to install Oracle software, setup a new database, manage users, manage storage, manage security, add software patches and the management of data. The emphasis is on teaching someone new to an Oracle environment how to successfully manage an Oracle database. The Oracle Installer and Oracle Enterprise Manager (OEM) wizards and graphical user interfaces will be used during the introduction of this course to familiarize students with the Oracle environment. By the end of this Oracle training course, students will have gone through the main tasks required to manage an Oracle database environment.

Join thousands of corporate repeat customers in receiving the highest quality training products on the market.

**Please call 1-888-797-4040 for price on multi-user license.

Oracle 10g Training Series

Multimedia CD-ROM Based Training:
With CD-ROM based training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics.

System Requirements: x86/400 mhz (minimum), CD-ROM Drive,
64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, XP, Vista, or Apple Mac.

Oracle 10g Trainer: George J. Trujillo Jr.
George has specialized in Oracle technologies such as RAC, Data Guard, Streams, JDeveloper, Oracle Application Server, RMAN, Forms and Reports for many years. George has written advanced Oracle and Java certification tests and is a major presenter at numerous International Oracle and Java Users Group conferences. In addition to his 20+ years of technical experience, George has delivered internationally over 250 technical training courses and seminars. George is the President and CEO of Trubix Inc., a company specializing in delivering leading edge technical training, consulting and courseware in Oracle10g, Linux, Internet strategies, Application Servers, XML, Java, .Net and Web services.

Course Outline - Oracle 10g Training:

Oracle 10g Level 1

Installing an Oracle Database

The Oracle Universal Installer
Oracle10g Standard Edition
Following Best Practices
Optimal Flexible Architecture (OFA)
Installation Options
Steps for Creating an Oracle Database
The Database Creation Assistant (DBCA)
Defining Installation Options
The Installation Process
Creating the Oracle Database
Validating the Installation

Oracle 10g Level 2

Understanding the Oracle Environment

Introduction to Oracle Enterprise Manager (OEM)
Using OEM to Manage Your Oracle Environment
Features of OEM
Main Components of OEM
The OEM Central Console
The Main Components of an Oracle Instance
Managing Oracle Memory
Oracle Database Files
Different Database Files
Oracle Storage Options
Understanding How Oracle Works
Oracle Concepts & Terminology
Oracle Networking Software
Overview of Oracle Products & Tools
SQL *Plus
SQL Worksheet
SQL Scratchpad
The OEM Web Site

Oracle 10g Level 3

Using OEM for Database Management

Starting Up an Oracle Instance & Database
Shutting Down an Oracle Instance & Database
Creating Database User Accounts
Managing Database User Accounts
Managing Default User Accounts
Implementing Password Management
Understanding Oracle Security
System and Object Privileges
Granting & Revoking Privileges
Working With Roles
Creating a Simple Backup

Oracle 10g Level 4

Managing Memory & the Oracle Instance

Using OEM to Manage Oracle Memory
Initialization Files
Using an SPFILE
Using an init.ora File
SPFILE or init.ora File
Oracle Network Services
Changing Oracle Memory & Configurations
Using an Oracle Dedicated Server
Using an Oracle Shared Server
Performing Normal Maintenance on an Oracle Instance
Oracle Network Services
Setting up Oracle Networking
Using Oracle Net Manager to Manage Listeners
Testing Oracle Networks
Customizing the Library

Oracle 10g Level 5

Managing & Configuring the Oracle Database

Understanding an Oracle Database
Database Configuration Options
Setting Up Data Files
Setting Up Control Files
Creating Redo Log Groups
Managing Redo Log Groups
Creating Redo Log Members
Managing Redo Log Members
Mirroring Redo Log Members
Setting Up Control Files
Mirroring Control Files
Adding Data Files
Modifying Data Files
Moving Database Files
Removing Control Files
Removing Redo Log Groups
Removing Redo Log Files

Oracle 10g Level 6

Managing Storage & Schemas

Data Fuiles Versus Tablespaces
Setting Up Storage for Applications
The System Tablespace
Data Tablespaces
Index Tablespaces
Undo Tablespaces
Temporary Tablespaces
Additional Tablespaces
Adding Database Storage
Modifying Database Storage
Adding Data Files
Modifying Data Files
Adding/Removing Control Files
Adding/Removing Redo Log Groups
Adding/Removing Redo Log Files
Working With Tables
Table Maintenance
Working With Indexes
Index Maintenance
Managing Schema Objects