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

Rating:
Summary: Microsoft SQL Server 7.0: Implementing a Database- Part 4 CB
Review: Course Overview
This is the fourth 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

Generate summary value and summary data as well as generate control break reports using aggregate functions.
Define transactions and set transaction isolation levels.
Identify the purpose and benefits of using views.

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 three courses 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: Summarizing Data 2 - 3 hours

Match each aggregate function with its description.
Select the ways aggregate functions handle null values.
Select statements to use with the GROUP BY clause on columns.
Select statements to use with the GROUP BY clause on expressions.
Select when to use the HAVING clause.
Perform the steps to summarize group values.
Perform the steps to summarize combinations of groups.
Select the characteristics of the GROUPING function.
Select guidelines for using the COMPUTE clause.
Select guidelines for using the COMPUTE BY clause.
Select recommended practices for summarizing data.

Unit 2: Transactions and Locks Management 2 - 3 hours

Select the characteristics of a transaction.
Select the guidelines for setting implicit transactions.
Select restrictions on user-defined transactions.
Sequence the steps that SQL Server applies in its transaction processing.
Sequence the steps that SQL Server uses to recover data with the checkpoint process.
Select the guidelines to be followed when writing a transaction.
Indicate the problems encountered when locks are not used.
Match lock types with their definitions.
Match each lockable resource with its description.
Match locks with their compatible counterparts.
Match session level locking options with their descriptions.
Match table level locking options with their descriptions.
Select the steps to reduce the risk of deadlocks.
Select how to display locking information.

Unit 3: Implementing Views 2 hours

Select the characteristics of a view.
Identify the advantages of using views.
Perform the steps to create views.
Perform the steps to alter views.
Perform the steps to drop views.
Select the characteristics of a broken ownership chain.
Match the information schema view with it display information text.
Select the procedures for hiding view definitions.
Identify the restrictions on data modification when using views.
Select performance considerations for views created by joining several tables