|
Provided by: 123-CBT Computer Based Training Designing a SQL Server 2005 Transaction Strategy |
 |
Training
Provided by 123-CBT Computer Based Training
recognize the different levels of isolation and granularity to manage concurrency and execute a transaction strategy in SQL Server 2005
|
|
||||||||
Designing a SQL Server 2005 Transaction Strategy
Overview:
recognize the different levels of isolation and granularity to manage concurrency and execute a transaction strategy in SQL Server 2005Pre-Requisites:
Three or more years database programming experience including expertise in troubleshooting triggers, queries, stored procedures, user-defined functions, and user-defined types writing Transact-SQL queries, performing database performance optimization, designing and troubleshooting the data access layer of the application, designing databases, implementing databases at the physical level, and gathering business requirementsTarget Audience:
Developers who use Microsoft Office SQL Server 2005 and consultants providing consulting services for SQL Server 2005. individuals looking to pass the 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 certification exam and those individuals targeting toward the Microsoft certification: Microsoft Certified IT Professional (MCITP): Database Developer certification pathModality:
WEBLesson:
SQL Server Data Transactions| - recognize how to perform data transactions in SQL Server 2005, by using the most appropriate method.|Isolation Levels in SQL Database Engine| - recognize different levels of isolation in SQL Server 2005.|Planning the Locking Granularity Level| - recognize the type of locking hints used at different levels of granularity in SQL Server 2005.|SQL Server Transaction Modes| - recognize the transaction modes and the role of MS DTC in the distributed transaction.|Creating Code that Uses Transactions| - recognize how to perform explicit transactions and distributed transactions in your applications.|Transaction Strategies in SQL 2005| - demonstrate the ability to perform data transactions in SQL Server 2005.|
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
-...
