Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160








Oracle9i Database Fundamentals 1Z0 031
Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works

This online course includes: Time Needed
Oracle Architecture and Tools 3 hours
Managing Instances and Creating Databases 3 hours
Managing the Database Structure 3 hours
Managing Tablespaces and Datafiles 2 hours
Managing Storage Structures and Undo Data 4 hours
Managing Tables 3 hours
Managing Indexes and Data Integrity 3 hours
Managing Users and Profiles 2 hours
Managing Privileges and Roles 3 hours
Exam Preparation 3 hours
Estimated time needed to complete entire course 29 hours


Receive your login ID to take the training courses online, as many times as you wish, for 1 year.  Click here for group orders.

Buy this entire online training course with one easy payment of $67

OR

Buy the Technical Pack, and receive this course plus many more, for only $197



Benefits

  • Unlimited access for 1 year
  • Learn anytime, anywhere
  • You control the pace
  • Start & stop wherever you want
  • No books to read
  • No software needed
  • Value Packs include Free online tech support
  • Double guarantee
  • 100% Money back guarantee
  • One time payment No monthly fee
  • Use the course index for review anytime
  • Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
  • Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. 
Prices shown are per user.




What You will Learn

This online training course is designed to help you who have experience with relational databases, SQL, and networking prepare for the Oracle 9i 1Z0 031 exam. Users will be introduced to the major components of an Oracle server and the database structure, and will learn how to create and manage such components as databases, instances, tablespaces, tables, datafiles, storage units, undo data, tables, indexes, data integrity, users, profiles, privileges, and roles.



Oracle Architecture and Tools

  • Explain the Oracle server architecture
  • Identify how users connect to the Oracle server
  • List tools used by DBAs to administer Oracle
  • Describe the benefits of Optimal Flexible Architecture
  • Install Oracle using Oracle Universal Installer



Managing Instances and Creating Databases

  • Create and manage an initialization parameter file 
  • Create a database with the create database command
  • Define a character set for your database
  • Configure language dependent behavior for the your database
  • Retrieve NLS information from the your database
  • Configure Oracle managed files
  • Use the startup command
  • List the different options available for starting Oracle
  • Shut down an Oracle instance
  • Describe the two types of diagnostic files used in Oracle 
  • List the prerequisites necessary for database creation
  • List values that must be set in the parameter file 
  • Use the Database Configuration Assistant



Managing the Database Structure

  • Use data dictionary views
  • Query the data dictionary
  • Use control files 
  • Work with redo logs



Managing Tablespaces and Datafiles

  • Describe the logical structure of Oracle databases
  • Create tablespaces
  • Manage temporary segments
  • Take tablespaces online and offline
  • Change tablespace storage settings
  • Use Oracle Managed Files (OMF) with tablespaces



Managing Storage Structures and Undo Data

  • Identify storage needs for different segment types
  • Size OLTP and batch undo segments
  • Maintain undo segments manually 
  • Control the size allocation of extents and segments
  • Acquire extents in dictionary managed tablespaces
  • Create and configure undo segments
  • List the keywords that control block space usage
  • Obtain information about storage from the data dictionary
  • Describe the purpose of undo data 
  • Implement automatic undo management
  • Use multiple extents when using parallel processors



Managing Tables

  • Explain how tables can store data 
  • Create permanent and temporary tables
  • Manage storage structures
  • Relocate tables
  • Drop unused columns



Managing Indexes and Data Integrity

  • Describe the different types of indexes and their uses
  • Create various types of indexes
  • Reorganize and drop indexes
  • Monitor index usage
  • Implement data integrity constraints
  • Maintain integrity constraints
  • Obtain index and constraint information from the data dictionary 



Managing Users and Profiles

  • Create new database users
  • Manage existing users
  • Monitor information about existing users
  • Control resource use with profiles 
  • Administer profiles
  • Manage passwords using profiles 
  • Obtain profile information from the data dictionary 



Managing Privileges and Roles

  • Identify system and object privileges
  • Grant and revoke privileges
  • Identify auditing capabilities
  • Create and modify roles
  • Control availability of roles
  • Remove roles
  • Use predefined roles
  • Display role information from the data dictionary



Exam Preparation

  • After completing this course, the user should be familiar with all the exam objectives for the Oracle 1Z1 031: Oracle9i DBA Fundamentals I exam
  •  



 

 

 

Copyright © 2007 TrainingCenter.com