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.

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information