Training Classes | Learning and Development Resources | Training Directory | New Training Programs | New Training Providers | Site Map | Promote Training | Training Keywords | Training Programs | Training Providers | Regions | Training Search | Advertise Training Programs | Login
Provided by: Serebra Learning Corporation

Advanced SQL Programming

Click here for more information or to take this course
Serebra Learning Corporation


  home  : Computer  : Databases and SQL  : SQL

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

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.

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:3 hours
Training Presented in:English

Related Keywords:  sql   student   server   advanced   sql   programming 

Training Program Details


Course Outline - IP0260 - Advanced SQL Programming

Advanced SQL Programming

Course Code IP0260

Contents

  1. Contents
  2. Description
  3. Audience
  4. Prerequisites
  5. Objectives
  6. Topics Include
  7. Duration
  8. Minimum Requirements
  9. Media

Screenshot


click to enlarge

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

Serebra Learning Corporation, 600 - 1188 West Georgia, Vancouver, BC    V6E 4A2 Canada
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com

About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...

More Training from Serebra Learning Corporation

Click here for more information or to take this course

Training Directory | New Training Programs | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Sql training provider?
You could be on this page today - for FREE!