Online Training

Take a FREE Course
No-risk Guarantee
Student Feedback
Instant Mentoring
Course Features

SAVE 30-40%
CLICK HERE
FOR DETAILS



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:

Minimum 500MHz Processor; 128 MB RAM; Minimum display resolution 1024x768; Windows 2000, XP, Vista, 7 or Mac OS X v10.4+; Internet Explorer 7.0+ or Firefox 3.0+ or Chrome 3.0+ or Safari 4.0+. 56K minimum connection; Adobe Flash Player 9.0+ or Windows Media Player 9.0+ for IE users who do not have Adobe Flash Player; JavaScript, popup windows and 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

SAVE 30-40%
CLICK HERE
FOR DETAILS


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 signing up for a Combo Pack! Click below for more info.

Read More

Monthly Special - Our best values!! »

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

Read More

© 1999-2012 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

Student Feedback

Certification Info

Other Resources

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