Oracle Certification Training

Oracle 9i certification training internet based course

The self-paced oracle certification training is exceptional. Our oracle certification training course meet or exceed exam objectives, teaching precisely what you need to know.

Microsoft SQL
Server 2000

Oracle 9i certification training that's Easy, Convenient and Affordable! High-quality, online oracle certification, self-paced training designed to help you achieve your training goals. Affordable annual subscription plans give you unlimited access to an entire suite of certification training topics at prices that you just won't find anywhere else.

This certification training course is for anyone preparing for the Oracle 1Z1-031: Oracle 9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals.

Architecture and Tools introduces users to the major components of an server.
Managing Instances and Creating Databases introduces users to managing an instance, creating a database, and using globalization parameters.
Managing the Database Structure introduces users to data dictionaries, control files, and redo log files.
Managing Tablespaces and Datafiles introduces users to creating and managing tablespaces.
Managing Storage Structures and Undo Data introduces users to the underlying storage structure of a database and to using undo segments.
Managing Tables introduces users to creating and managing table structures.
Managing Indexes and Data Integrity introduces users to indexes and data integrity constraints.
Managing Users and Profiles introduces users to creating and managing users and to control resources using profiles.
Managing Privileges and Roles introduces users to system and object priviledges and user roles.
Oracle9i Database Fundamentals 1Z1-031 Exam Preparation covers all of the objectives for the certification exam and allows users to practice answering questions in order to prepare for taking the exam.

After completing our courses, the user should be able to:

Server Architecture
The Server Process
Connecting to Servers
Processing Queries
Processing DML Statements
Processing Commit Statements
Common Database Administration Tools
Universal Installer
Installing Database
Optimal Flexible Architecture
Authentication
Using Operating System Authentication
Using Password File Authentication
Enterprise Manager Components
Creating an Initialization Parameter File
Configuring Managed Files
Starting an Instance using SQL*Plus
Startup Methods and Options
Shutting Down an Instance
Using Diagnostic Files
Planning for Database Creation
Preparing the Parameter File
Using the Database Configuration Assistant
Creating a Database Manually
Choosing a Character Set
Specifying Language-Dependent Behavior
Viewing Globalization Support Information
Constructing Data Dctionary Vews
Tables and Views
Data Dictionary Contents
Querying the Data Dictionary
Using Control Files
Control File Contents
Using Managed Files
Viewing Control File Information
Multiplexing Control Files
Redo Log Files
Controlling Log Switches and Checkpoints
Maintaining Redo Log Files
Using OMF to Manage Redo Log Files
Logical Structure
Understanding Tablespaces
Creating Tablespaces
Changing Tablespace Size
Using Temporary Segments
Managing Uniform Extent Sizing
Changing Tablespace Status
Changing Tablespace Storage Settings
Using OMF with Tablespaces
Types of segments
Acquiring and managing segments and extents
Controlling block space usage
Obtaining information about storage structures
Using undo data
Implementing automatic undo Management
Creating, configuring, and maintaining undo Segments manually
Storing Data
Distinguishing Datatypes
Extended and Restricted ROWIDs
Row Structure
Creating Permanent and Temporary Tables
Managing Storage Structures
Managing Tables
Dropping Columns
Index Types
Function-Based and Descending Indexes
Creating B-Tree and Bitmap Indexes
Reorganizing Indexes
Dropping Indexes and Getting Index Information
Monitoring Use of Indexes
Implementing Data Integrity Constraints
Using Deferred Constraints
Maintaining Integrity Constraints
Obtaining Constraint Information
Creating New Users
User Account Guidelines
Altering and Droping Existing Users
Monitoring User Information
Controlling Resource Use with Profiles
Administering Profiles
Administering Passwords Using Profiles
Obtaining Profile Information
System Privileges
Special and Object Privileges
Granting and Revoking Privileges
Granting Administrative Abilities
Identifying Audit Capablitities
Using the Audit Command
Managing Auditing
Creating and Modifying Roles
Controlling Availability of Roles
Using Predefined Roles
Displaying Role Information

Our courses have special design features listed below:

Certificates of Completion
Instructional steps -- walk through a procedure
Exercises -- try it out
Notes - See additional information related to the topic in the text
Tips - See a different, faster, or easier way of doing something
Quick References - See a quick reference guide to the features introduced in a chapter
Details - Display more detailed information related to the current topic
Hotwords - See related information
Navigation Bar - Maneuver easily through the courses
Course Topics and Index -- with searching feature and hyper-links
Printable Exercises - PDF downloadable files
Sample Application Files - PDF downloadable files
Course Glossary
Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and course grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which course topics you want to focus on and to go directly into that unit.