Home » Course Catalog » Online Training Course Objectives and Outline
Oracle9i Database Fundamentals 1Z0-031 Series: Managing Indexes and Data Integrity
Product Code: or3107 Time: 3.0 hour(s) CEUs: Available

Summary:

This course introduces users to indexes and data integrity constraints.

Objectives:

  • 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


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

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.



Return To Top

Training Courses | e-Learning Edge | Training Course Certifications | Training Course Sign-up
Student Center | Learning Resources | Free Courses | Privacy Policy | Contact e-Learning Center

Hot Topics
IT Courses
MS Certs
Web Design
MS Office
Programming
Business
Networking
VS .NET
Personal
Full Catalog

Christian Website

Combo Packs... »

Save even more when you sign up for a combination package. Our BEST values EVER!

Read More

Monthly Specials - Big, Big Savings!! »

We always offer several special offers with savings from $50-$100 & more! Check out this month's special offers...

Read More

© 1999-2009 SK Max. All rights reserved.

General IT Web Design Microsoft Certs


Desktop Computing Business Skills Personal Skills


Combo Packages Business Videos

Articles

Features

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

Student Feedback

Certification Info

Other Resources

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