Education Online - Career Education --- e-learning for Everyone.

 

Synopsis
Oracle9i Database Fundamentals 1Z1-031: Managing Indexes and Data Integrity introduces users to indexes and data integrity constraints.

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

Time
3 hours

Product Code: OR3107
Oracle9i Database Fundamentals 1Z1-031: Managing Indexes and Data Integrity covers the following topics:

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

This course has the following features:

Exercises that allow users to practice in Oracle9i
A file containing the text of the exercises
Activities that allow users to apply course concepts in an interactive questioning environment
A glossary
A Skill Assessment

Familiarity with relational databases, SQL, and networking
Oracle9i Database Fundamentals 1Z1-031: Oracle Architecture and Tools (OR3101)
Oracle9i Database Fundamentals 1Z1-031: Managing Instances and Creating Databases (OR3102)
Oracle9i Database Fundamentals 1Z1-031: Managing the Database Structure (OR3103)
Oracle9i Database Fundamentals 1Z1-031: Managing Tablespaces and Datafiles (OR3104)
Oracle9i Database Fundamentals 1Z1-031: Managing Storage Structures and Undo Data (OR3105)
Oracle9i Database Fundamentals 1Z1-031: Managing Tables (OR3106)

Oracle9i Database Fundamentals 1Z1-031: Managing Users and Profiles (OR3108)
Oracle9i Database Fundamentals 1Z1-031: Managing Privileges and Roles (OR3109)
Oracle9i Database Fundamentals 1Z1-031: Exam Preparation (OR3110)

Oracle® and Oracle9i™ are trademarks of Oracle Corporation.
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.