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

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

This is self-paced, internet-based course -- there are no books to purchase and no scheduled classes to attend.

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 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:

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

Technical Requirements

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. Minimum Connection Speed: 28.8k. Authorware recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Learning comes to life with challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Engage in dynamic learning where multiple senses help reinforce learning concepts. Our proven methodology provides an unequalled experience with exceptional results Learning that's Easy, Convenient and Affordable! High-quality, online, self-paced courses designed to help you achieve your goals. Affordable annual subscription plans give you unlimited access to an entire suite of topics at prices that you just won't find anywhere else.

Our 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. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.

Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.