Courses - Microsoft SQL Server(TSQL)



(Course PDF)

SQL Server 2005 Overview

  Version History
  Feature Overview
  Development Tools

Programming with TSQL- the Basics

  Using Variables
  Control of Flow Statements
  Error Handling
  Using Cursors

Programming Views

  Creating Views
  Updating Through Views
  Indexed Views

Programming Stored Procedures

  Creating Procedures
  Passing Parameters

Programming User Defined Functions

  Scalar, Inline Table and Multi-Statement
  Data Manipulation in UDFs
  Profiling UDFs

Programming Triggers

  Trigger Syntax
  Trigger Events
  Enabling/Disabling Triggers
  Nested Triggers

TSQL Enhancements

  Ranking Functions
  Recursive Queries
  Relational Operators