|
Provided by: Serebra Learning Corporation Advanced SQL ProgrammingSQL |
![]() |
|
|
||||||||||
Advanced SQL ProgrammingCourse Code IP0260 |
|
Contents
|
Screenshotclick to enlarge |
DescriptionThis 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. AudienceThis course is intended for technical managers and application developers who implement a database solution with Microsoft SQL Server client/server database management system. PrerequisitesAn understanding of Windows NT 4.0 Server and Windows 95/98. ObjectiveUpon completion of this course, the student will be able to:
Topics Include
Advanced Programming Features
Manage Transactions using T SQL
Optimizing Execution Plans
Duration4 hrs Minimum RequirementsNetscape 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 |
|
|
Serebra Learning Corporation, 1660 - 999 West Hastings, Vancouver, BC V6C 2W2 Canada Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490 E-Mail: sales@serebra.com - Web Site: www.serebra.com |
|

