|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 - Implementing a Database - Part 5 |
 |
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)- 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 link
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
SQL Server 7 0 - Implementing a Database - Part 5
--
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
-...
