Microsoft Advanced T-SQL Querying & Programming Tuning For SQl Server
2005 & 2008

Product Description

The course focuses on writing & tuning queries & programming with T-SQL in SQL Server 2005 & 2008. In this course you will learn the details & capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning; Subqueries, Ranking Functions, Joins & Set Operations; Aggregating & Pivoting Data; TOP & APPLY; Data Modification; Data Type Related Problems; Programmable Objects (Dynamic SQL, Views, User Defined Functions, Stored Procedures, Triggers, Transactions & Concurrency, Exception Handling); Graphs, Trees & Hierarchies.

Along the course you will learn how to use T-SQL to solve practical problems such as: Relational Division, Ranking, Missing & Existing Values (Islands & Gaps), Separating Elements, Tie Breakers, Running Aggregations, Pivoting & Unpivoting, Custom Aggregations, Histograms, Dynamic Analysis of Grouping Sets, TOP Problems, Paging, Median, Handling Sequences, & more.

You will learn how to tune your queries, how to develop efficient routines including user defined functions, stored procedures & triggers, work in multi-user environments with transactions & isolation levels, & use dynamic SQL securely & efficiently.

You will also learn how to maintain & query hierarchical data. You will learn what graphs, trees & hierarchies are, what the common requests against graphs are, & how to write T-SQL code to handle those requests. Several different solutions will be presented including: Enumerated Paths, Nested Sets, Nested Iterations using Recursive Queries, & using the HIERARCHYID datatype.

The course provides a dedicated module focusing on query tuning. The module covers internals & index tuning, index access methods, temporary tables, set vs. cursors, & query tuning using query revisions. Moreover, query tuning is in the heart of this course & is incorporated in the different modules throughout the course.

With each querying/programming problem the discussions will revolve around logical aspects, set-based vs. procedural programming & optimization of the solutions.

This course was developed by Itzik Ben-Gan, a mentor & one of the founders of Solid Quality Mentors, author of several books about T-SQL, a columnist in SQL Server Magazine, & a regular speaker in SQL Server related events.

This training may be available onsite; please contact us if you are interested.