Description
This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.
Audience
This course is intended for technical managers and application developers who implement a database solution with Microsoft SQL Server client/server database management system.
Prerequisites
An understanding of Windows NT 4.0 Server and Windows 95/98.
Objective
Upon completion of this course, the student will be able to:
- describe the different types of stored procedures
- create stored procedures using T-SQL statements
- execute stored procedures
- query distributed data using remote stored procedures
- execute stored procedures on a linked server
describe the OPENROWSET function
- create different types of triggers
- modify and remove triggers
- use triggers to enforce data integrity and implement business rules
- describe the different programming components supported by SQL Server
- describe the different programming constructs supported by SQL Server
- implement error handling using return codes and the RAISERROR statement
- describe different types of transactions
- manage explicit transactions using T-SQL statements
- handle transaction errors
- manage distributed transactions
- define the different types of locks
- describe the different types of locking hints
- manage deadlocks
- describe SQL Server 7.0 query execution plans
- describe SQL Server Query Analyzer
- optimize the performance of execution plans
- configure session-level settings using SET statements
- describe SQL Server Profiler
- create traces using SQL Server Profiler
Topics Include
Advanced Programming Features
- Stored Procedures
- Distributed Data
- Triggers
Manage Transactions using T SQL
- Programming Components
- Transactions
- Locks
Optimizing Execution Plans
- Execution Plan
- SQL Server Profiler
Duration
4 hrs
Minimum Requirements
Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.
Media
Web Based Training
|
