Provided by: 123-CBT Computer Based Training

SQL Server 7 0 - Implementing a Database - Part 4

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 fourth 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:

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.

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 three courses in this series.

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Summarizing Data

Duration: 2 - 3 Hour(s)

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

Duration: 2 - 3 Hour(s)

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

Duration: 2 Hour(s)

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.

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!