Introduction to Microsoft T-SQL Training (3 days)

Introduction to Microsoft T-SQL Training Overview

In this SQL Server course, you'll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers can now use .NET languages like C# and Visual Basic to build database objects.

Introduction to Microsoft T-SQL Training Course Goals

• Learn to build queries in Transact-SQL to insert, update, delete, and retrieve data.
• Learn to create stored procedures to promote enhanced security and performance.
• Learn to work with stored procedures, triggers and user-defined functions.
• Learn to use SQL Server transactions for insure data integrity.
• Learn to use .NET programming with SQLCLR.
• Create highly optimized queries using advanced techniques.

Introduction to Microsoft T-SQL Training Course Outline

1. A Tour of SQL Server 2005
   1. SQL Server 2005 Editions, Components, and Tools
   2. Using SQL Server Management Studio (SSMS)
   3. Working with Tables and Queries
   4. New Transact-SQL Features
   5. Business Intelligence Services
2. Designing and Creating a Database
   1. Relational Database Design Principles
   2. Implementing the Design
3. Data Selection Queries
   1. Understanding Transact-SQL
   2. The SELECT Statement
   3. The WHERE Clause
   4. Using ORDER BY to Sort Data
   5. The GROUP BY Clause
   6. Joining Tables
4. Modifying Data
   1. Modifying Data
   2. Inserting Data
   3. Updating Data
   4. Deleting Data
   5. Understanding Transaction Isolation
5. Working with SQL Server Management Studio
   1. Getting Started with SSMS
   2. Exploring the Object Explorer
   3. Working with the Query Editor
   4. Using SQL Server Books Online
6. Transact-SQL Programming
   1. Overview of Transact-SQL
   2. Using Built-In Functions
   3. Controlling Flow
   4. Ranking Results
7. Transactions and Error Handling
   1. Transaction Concepts
   2. Applications and Transactions
   3. Creating Explicit Transactions
   4. Using TRY/CATCH Error Handling
8. Creating Views
   1. What Is a View?
   2. Creating Views
   3. Updating Data Using a View
   4. Using Computed Columns
   5. Indexed Views
   6. Partitioned Views
9. Creating Stored Procedures and Triggers
   1. Creating Stored Procedures
   2. Creating Triggers
10. Creating User-Defined Functions
    1. User-Defined Function Overview
    2. Scalar Functions
    3. Inline Table-Valued Functions
    4. Multi-Statement Table-Valued Functions
    5. Using Functions, Views, and Stored Procedures
11. Using .NET Code in SQL Server 2005
    1. Writing SQLCLR Code
    2. SQLCLR Code Modules
    3. Managing Code Modules
    4. SQLCLR Security
    5. T-SQL vs. .NET Code
12. Advanced Query Techniques
    1. Full-Text Search
    2. Generating XML with FOR XML
    3. Using APPLY
    4. Creating Recursive Queries
    5. Creating Pivot Queries
    6. Executing Dynamic SQL

Introduction to Microsoft T-SQL Training Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Introduction to Microsoft T-SQL Training Technical Requirements

1. Microsoft SQL Server 2005
   • Download - Express Edition will work fine.
2. SQL Server Management Studio
   • Download - - Express Edition
   • System Requirements

Class Files for Introduction to Microsoft T-SQL Training

The class files for this course are included on a DVD that is shipped with the manual.