Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: 123-CBT Computer Based Training

SQL Server 7 0 - Implementing a Database - Part 5

Click here for more information or to take this course
123-CBT Computer Based Training


Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by 123-CBT Computer Based Training

Course Overview

This is the final 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:

  • Access data by using the Stored Procedure model.
  • Access data using triggers.
  • Set up a distributed environment to access, modify and manage remote data.

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

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Implementing Stored Procedures

Duration: 2 - 3 Hour(s)
  • Match the type of stored procedure with its definition.
  • Sequence the steps of the initial processing of stored procedures.
  • Select the characteristics of subsequent stored procedure processing.
  • Select the advantages of stored procedures.
  • Perform the steps for creating stored procedures.
  • Select the characteristics of nested stored procedures.
  • Match the system stored procedure with the information it produces.
  • Select the guidelines for creating stored procedures.
  • Perform the action to execute a stored procedure.
  • Perform the steps to alter a stored procedure.
  • Perform the action to drop a stored procedure.
  • Select the guidelines for input parameters used in stored procedures.
  • Perform the steps to pass parameters into a stored procedure.
  • Perform the steps to return a value.
  • Match the method for recompiling stored procedures with the corresponding function.
  • Select the uses of extended stored procedures.
  • Match each commonly used extended stored procedure name with its function.
  • Match the error message types with its use.
  • Select the functions of the RAISERROR statement.
  • Perform the action to customize error messages.
  • Select the statements used in transactional error-handling.
  • Select the counters that can be monitored by SQL Server Performance Monitor.
  • Perform the steps to view the event generated by the stored procedure.
  • Select the recommended practices for effective stored procedures.

Unit 2: Implementing Triggers

Duration: 2 - 3 Hour(s)
  • Select the characteristics of triggers.
  • Select the advantages of trigger usage.
  • Select the guidelines for using triggers.
  • Select the statements which are prohibited within a trigger creation.
  • Select the characteristics of the ALTER TIRGGER statement.
  • Perform the action to drop a trigger.
  • Perform the steps to create and execute an INSERT trigger.
  • Perform the steps to create and execute a DELETE trigger.
  • Perform the steps to create and execute an UPDATE trigger.
  • Select the characteristics of nested triggers.
  • Select where triggers to enforce data integrity were used.
  • Select where triggers to enforce business rules were used.
  • Select the performance considerations for triggers.
  • Select the recommended effective practices for triggers.

Unit 3: Distributed Data

Duration: 2 Hour(s)
Custom Search

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


Connecting people who want to learn with people who love to teach
 Are you a Microsoft training provider?
You could be on this page today - for FREE!