T-SQL Training: T-SQL for SQL Server 2005 for Developers

Course Number: SQL-115
Duration: 3 days
view class outline

Looking for T-SQL for SQL Server 2008 for Developers?

T-SQL Training Overview

Accelebrate's T-SQL for SQL Server 2005 Developers teaches developers all the Transact-SQL skills they need to develop queries, views, functions, stored procedures, and triggers in SQL Server, as well as embed .NET code.

Note: All audiences may also wish to consider our SSRS Training: Introduction to SQL Server 2005 Reporting Services class.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=categorygroup&page=database.

T-SQL Training Prerequisites

This course can be adapted to any level of prior SQL Server and relational database experience.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.

T-SQL Training Objectives

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

T-SQL Training Materials

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
Comprehensive courseware covering all topics taught in the class

Software Needed on Each Student PC

Windows XP Pro, Vista Business/Ultimate or 7, Server 2003, or Server 2008 with the latest service packs installed
SQL Server 2005 with the latest service packs
Visual Studio 2005 or 2008 with the latest service packs
SQL Server Management Studio
Related sample databases Accelebrate would provide
Note: If you have purchased this course, please contact us for a detailed setup sheet.

Important Note: If you have purchased this class, please contact us for detailed setup instructions.

T-SQL Training 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

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.