|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Implementation - Level 3 |
 |
Training
Provided by 123-CBT Computer Based Training
1.1 Date functions
1.2 Mathematical functions
1.3 String functions
1.4 System functions
1.5 Cast & Convert functions
1.6 System Variables
2.0 Stored Procedures (30 min)
2.1 Overview
2.2 Creating & Executing stored procedures
2.3 Using parameters with stored procedures
2.4 Returning information from stored procedures
2.5 Business rules in stored procedures
2.6 Using Cursors
3.0 Triggers and Views (21 min)
3.1 Creating triggers
3.2 Creating views
4.0 Locking Issues (22 min)
4.1 Optimistic and Pessimistic locking
4.2 Isolation levels
4.3 Types of Resource Locks
4.4 Lock Modes
4.5 Displaying locking information
4.6 Locking hints
5.0 Transactions (14 min)
5.1 What is a transaction
5.2 BEGIN, COMMIT, and ROLLBACK TRANS
5.3 Nesting transactions
5.4 Applying a ROLLBACK TRANS within a Trigger
5.5 Transactions and Locking
5.6 Killing Processes
5.7 Avoiding DeadLocks
Implementing SQL 7 Level 3 (1 Hour 57 Minutes)
1.0 System Functions & Variables (29 min)1.1 Date functions
1.2 Mathematical functions
1.3 String functions
1.4 System functions
1.5 Cast & Convert functions
1.6 System Variables
2.0 Stored Procedures (30 min)
2.1 Overview
2.2 Creating & Executing stored procedures
2.3 Using parameters with stored procedures
2.4 Returning information from stored procedures
2.5 Business rules in stored procedures
2.6 Using Cursors
3.0 Triggers and Views (21 min)
3.1 Creating triggers
3.2 Creating views
4.0 Locking Issues (22 min)
4.1 Optimistic and Pessimistic locking
4.2 Isolation levels
4.3 Types of Resource Locks
4.4 Lock Modes
4.5 Displaying locking information
4.6 Locking hints
5.0 Transactions (14 min)
5.1 What is a transaction
5.2 BEGIN, COMMIT, and ROLLBACK TRANS
5.3 Nesting transactions
5.4 Applying a ROLLBACK TRANS within a Trigger
5.5 Transactions and Locking
5.6 Killing Processes
5.7 Avoiding DeadLocks
|
|
SQL Server 7 0 Implementation - Level 3
--
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
-...
