Microsoft SQL Server 7.0: Implementing a Database- Part 2 CBT Training CD

Rating:
Summary: Microsoft SQL Server 7.0: Implementing a Database- Part 2 CB
Review: Course Overview
This is the second course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0.

Learn To

Implement data integrity.
Create and maintain indexes.

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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
Japanese, US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Implementing Data Integrity 3 - 4 hours

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 3 - 4 hours

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.