LOGO For Immediate Assistance Call 855-211-9361

Enterprise

 Transact SQL (T-SQL) for SQL Server 2005 for Developers

Price: $1,755.00

Call for availability 855-211-9361

In this course, you'll learn how to build queries using Transact-SQL and how to build views, stored procedures, triggers, and user-defined functions. You'll learn about enhancements to the T-SQL programming language including error handling and hierarchical queries, and you will learn how you can use .NET languages like C# and VB.NET to build database objects.

Course Overview

By the end of the class students will be able to:

  • Write and tune sophisticated T-SQL queries
  • Work with SQL Server Management Studio
  • Use T-SQL’s programming features such as functions and control flow
  • Implement transactions and error-handling
  • Build stored procedures and triggers
  • Embed .NET code in their databases using SQLCLR
  • Use advanced query techniques such as recursive queries, pivot queries, and full text search

Prerequisites

800 PB Tech Capstone: Fundamentals of Relational Databases, or equivalent industry experience working with databases. Experience with the .NET framework a plus.

Course Outline

  • A Tour of SQL Server 2005

    • SQL Server 2005 Editions, Components, and Tools
    • Using SQL Server Management Studio (SSMS)
    • Working with Tables and Queries
    • New Transact-SQL Features
    • Business Intelligence Services
  • Designing and Creating a Database

    • Relational Database Design Principles
    • Implementing the Design
  • Data Selection Queries

    • Understanding Transact-SQL
    • The SELECT Statement
    • The WHERE Clause
    • Using ORDER BY to Sort Data
    • The GROUP BY Clause
    • Joining Tables
  • Modifying Data

    • Modifying Data
    • Inserting Data
    • Updating Data
    • Deleting Data
    • Understanding Transaction Isolation
  • Working with SQL Server Management Studio

    • Getting Started with SSMS
    • Exploring the Object Explorer
    • Working with the Query Editor
    • Using SQL Server Books Online
  • Transact-SQL Programming

    • Overview of Transact-SQL
    • Using Built-In Functions
    • Controlling Flow
    • Ranking Results
  • Transactions and Error Handling

    • Transaction Concepts
    • Applications and Transactions
    • Creating Explicit Transactions
    • Using TRY/CATCH Error Handling
  • Creating Views

    • What Is a View?
    • Creating Views
    • Updating Data Using a View
    • Using Computed Columns
    • Indexed Views
    • Partitioned Views
  • Creating Stored Procedures and Triggers

    • Creating Stored Procedures
    • Creating Triggers
  • Creating User-Defined Functions

    • User-Defined Function Overview
    • Scalar Functions
    • Inline Table-Valued Functions
    • Multi-Statement Table-Valued Functions
    • Using Functions, Views, and Stored Procedures
  • Using .NET Code in SQL Server 2005

    • Writing SQLCLR Code
    • SQLCLR Code Modules
    • Managing Code Modules
    • SQLCLR Security
    • T-SQL vs. .NET Code
  • Advanced Query Techniques

    • Full-Text Search
    • Generating XML with FOR XML
    • Using APPLY
    • Creating Recursive Queries
    • Creating Pivot Queries
    • Executing Dynamic SQL