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

Server Architecture
The Server Process
Connecting to Servers
Processing Queries
Processing DML Statements
Processing Commit Statements
Common Administration Tools
Universal Installer
Installing Oracle9i
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 Creation
Preparing the Parameter File
Using the 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

This course has the following features:

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.

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.