Microsoft SQL Server 7.0: Implementing a Database - Part 5

Rating:
Summary: Microsoft SQL Server 7.0: Implementing a Database - Part 5
Review: 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.

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.

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 Stored Procedures 2 - 3 hours

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

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 2 hours

Select the purposes for establishing linked servers.
Perform the steps to connect to a remote SQL server.
Match common OLE DB provider names with their data sources.
Identify facts to consider when establishing linked server security.
Match system stored procedures with the information they return about linked servers.
Select the allowed Transact-SQL statements.
Select the statement that executes a stored procedure on a linked server.
Select the functions of the MS DTC tool.
Identify the functions of SQL Server Replication.
Identify the characteristics of designing and building a data warehouse.
Select the functions of Import and Export wizards.