Oracle tutorial training online course
oracle tutorial

Oracle Database Certification Tutorial
Info and Order

Oracle Database Tutorial



The self-paced Oracle tutorial is exceptional. Our online oracle tutorial 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

70-210 Courses

70-215 Courses

70-216 Courses

70-217 Courses

70-218 Courses

70-219 Courses

70-220 Courses

70-221 Courses

70-224 Courses

70-229 Courses

70-270 Courses

Microsoft Office
Training Courses

Office XP

Access 2000

Excel 2000

Word 2000

Power Point

Project

Outlook 2000

Works

Internet Explorer

FrontPage

Exchange Server

Novell

PhotoShop

Crystal Reports

Lotus Notes

LINUX

UNIX

X.M.L.


Oracle 9i tutorial 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 tutorial 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