Provided by: 123-CBT Computer Based Training

SQL Server 7 0 - Implementing a Database - Part 2

Click here for more information or to take this course

Search for Training

Find Your Genius!

Training Provided by 123-CBT Computer Based Training

Course Overview

This is the second course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0.

Learn To:

Implement data integrity.
Create and maintain indexes.

Content Emphasis

Skills-Based

Audience

This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474) and the first course in this series.

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Implementing Data Integrity

Duration: 3 - 4 Hour(s)

Select the appropriate method of denormalization.
Match the type of data integrity with its correct definition.
Identify the methods of enforcing data integrity.
Match each type of data integrity with its constraint method.
Identify the characteristics of the constraints.
Select the considerations for using constraints.
Perform the steps to enforce domain integrity.
Perform the steps to enforce entity integrity.
Select the guidelines for disabling complaints.
Perform the steps to disable constraint checking.
Perform the steps to create and bind a default.
Perform the steps to enforce data integrity.
Match data integrity enforcement methods to its impact.

Unit 2: Planning and Creating Indexes

Duration: 3 - 4 Hour(s)

Identify how data is stored by SQL Server 7.0.
Select the methods SQL Server uses to access data.
Identify when it is useful to create an index.
Select the columns to index.
Select the characteristics of a clustered index.
Sequence the steps SQL Server goes through to access data.
Select the architectural features of nonclustered indexes.
Identify the key difference between accessing data with a clustered index and accessing data in a help using a nonclustered index.
Sequence the steps SQL Server takes when accessing data using a nonclustered index on a clustered index.
Sequence the steps SQL Server takes to retrieve a range of information contained in a heap.
Identify how SQL Server accesses a range of data using clustering keys.
Select the guidelines which apply when using the CREATE INDEX statement.
Perform the steps to create a unique index.
Perform the steps to create a composite index.
Identify the methods used to view existing indexes.
Perform the steps to drop indexes.
Perform the steps to allocate a percentage of free space on leaf level index pages.
Perform the steps to specify a percentage to fill non-leaf level pages.
Identify the functions of the Index Tuning wizard.
Select the methods of managing data fragmentation.
Perform the steps to display the base table size and fragmentation.
Select when to use the DBCC DBREINDEX statement.
Select the methods available to manually update the index statistics.
Identify the information the SHOWPLAN statements return when executed.
Select the uses of the STATISTICS IO statement.
Select the reasons to apply optimizer hints.

Training Avaliability and Delivery

This is primarily online training
	This is an online eLearning or CBT training program
	This program may be available on CD
	Contact 123-CBT Computer Based Training for more information

Training Presented in:

English

Related Keywords: microsoft sql server 7.0 implementing database part

Training Program Details

About 123-CBT Computer Based Training - Training Provider

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6.10 - Access 2003 - Acrobat 6.0 - ASP - ASP.NET - C - Captivate 1.0 - Crystal Reports 8.5 - Crystal Reports v10 - Dreamweaver MX -...

More Microsoft SQL Server 7 0 Training from 123-CBT Computer Based Training

Click here for more information or to take this course

Custom Search

Training Directory \| New Training Seminars \| New Training Providers \| Search \| Site Map \| Promote Training \| Login \| Links

	Training-Classes.com by Skillbox® 07/19/08 Copyright 1998-2008 skillbox, inc. All rights reserved

Are you a Microsoft training provider?

You could be on this page today - for FREE!