|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 - Implementing a Database - Part 4 |
 |
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.
|
|
||||||||||
SQL Server 7 0 - Implementing a Database - Part 4
--
About The Training Provider: 123-CBT Computer Based Training
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
-...
