oracle certification training tutorial

oracle database certification training

Oracle Database Certification Training
Info and Order

Oracle Certification Training

fruta vida

Oracle Database Online Training Courses

Novell CNE

Novell 570

Novell Certification

Novell Training

Office

Office 2000

Office XP

Oracle

Oracle 8i

Oracle 9i

Oracle Certification

Oracle Training

Photo Shop Yutorial

Powerpoint Tutorial

Project Management

QuickBooks

QuickBooks Training

SAS

Software Training

SQL Server Training

SQL Server Tutorial

SQL Tutorial

Sybase

Technical Training

Time Management

UNIX

UNIX System

Visual Basic

Visual Basic Tutorial

Web Page Design

Web Site Design

Windows XP

Word

Word 2000

Word Tutorial

Works

XML Courses

Microsoft Office

Microsoft Office 2000

Microsoft Office
2000 Training

Microsoft Office
2000 Tutorial

Microsoft Office Training

Microsoft Powerpoint

Microsoft SQL Server

Microsoft Word

MOUS Certification

MOUS Training

Ms Excel Training


Wela Slimberry
Business Opportunity

Acai Berry
Diet Supplement

hit
counter

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.