Oracle9i Database Fundamentals 1Z1-031: Managing Indexes and Data Integrity

Products

Resources

Specials

Summary:

This training course introduces users to indexes and data integrity constraints.

Objectives:

After completing this training course , students will be able to:

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

Outline:

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

Features:

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

Applicability:

This training 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.

Prerequisites:

Experience working with relational database systemstraining course s on SQL or equivalent experienceGeneral knowledge of networkingOracle9i Database Fundamentals 1Z1-031: Oracle Architecture and ToolsOracle9i Database Fundamentals 1Z1-031:Managing Instances and Creating DatabasesOracle9i Database Fundamentals 1Z1-031: Managing the Database StructureOracle9i Database Fundamentals 1Z1-031: Managing Tablespaces and DatafilesOracle9i Database Fundamentals 1Z1-031: Managing Storage Structures and Undo DataOracle9i Database Fundamentals 1Z1-031: Managing Tables

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. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Oracle® and Oracle9i™ are trademarks of Oracle Corporation.

Terms of Use:

None