Oracle Database Certification Training Online

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

FREE Online Courses

FREE Certification Exams

QuickBooks

HTML Tutorial

Flash MX

Cisco CCNA

Oracle
9i Training

Visual Basic

SQL Server

A+ Certification

Network+ Certification

Webmaster Certification

Java Certification
310-025

MCSE Training

MOUS Training

Windows 2000
Training Courses

Microsoft Office
Training Courses

Internet Explorer

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

Our oracle database certification courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.

This course is for anyone preparing for the Oracle9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals.

Oracle 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 Oracle Servers
Processing Queries
Processing DML Statements
Processing Commit Statements
Common Database Administration Tools
Oracle Universal Installer
Installing Database
Optimal Flexible Architecture
Authentication
Using Operating System Authentication
Using Password File Authentication
Oracle Enterprise Manager Components
Creating an Initialization Parameter File
Configuring Oracle-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 Oracle-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
Microsoft Approved Courseware Logo - to prepare you for a Microsoft certification
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.

Bass Computer Services
Independent Technology Consultant