Geeks With Blogs

News Brandy Favilla is currently the Community Engagement Manager at New Horizons of Minnesota ( In this position, she helps people define and build their careers through educational events. Brandy focuses on networking with members of the Information Technology community to form partnerships in education. She strives to maintain New Horizons’ reputation as a high-quality learning center throughout the Twin Cities and beyond. Some of her accomplishments include chairing the committee for both the TechFuse and MindSurf Conferences hosted by New Horizons, co-chairing Twin Cities Code Camp and Twin Cities SharePoint Camp, Co-host of the Twin Cities Developers Guild, VP of PR for TechMasters (, Communications Chair of PACT (, Programs chair for IAMCP, President of the Business Intelligence User Group ( and actively participating in the SharePoint User Group ( *the thoughts and opinions in this blog are my own and do not reflect the opinions of New Horizons of Minnesota
Twin Cities IT and Developer Events Postings by Brandy Favilla

Advanced Transact-SQL Querying, Programming and Tuning for SQL Server 2000 & 2005
When:  November 3-7, 2008
Where:  New Horizons of MN located in Edina MN (
Course Outline:

This course was developed by Itzik Ben-Gan, a mentor and one of the founders of Solid Quality Learning, and the author of Inside Microsoft SQL Server 2005: T-SQL Querying (MSPress, 2006) and Inside Microsoft SQL Server 2005: T-SQL Programming (MSPress, 2006).

For more information or to register, please contact Brandy Favilla at or 952-896-6834

More Details:
Advanced Transact-SQL Querying, Programming and Tuning for SQL Server 2000 & 2005 

Class Overview 
The course focuses on writing and tuning queries and programming in SQL Server 2000 and 2005. In this course you will learn the details and capabilities of T-SQL including: Logical Query Processing; Query Tuning; Subqueries, Ranking Functions, Joins and Set Operations; Aggregating and Pivoting Data (including CLR UDAs); TOP and APPLY; Data Modification; Data Type Related Problems (including XML and CLR UDTs); Programmable Objects (Transactions, Dynamic Execution, User Defined Functions, Stored Procedures, Triggers, CLR Routines); Exception Handling; Graphs, Trees and Hierarchies.

Along the course you will learn how to use T-SQL to solve practical problems such as: Relational Division, TOP Problems, Handling Sequences, Identifying Groups, Missing and Existing Numbers (Islands and Gaps), Trends, Ranking, Paging, Pivoting and Unpivoting, Separating Elements, Custom Aggregations, Running Totals, Median, Histograms, and more. You will learn how to develop efficient T-SQL and CLR routines, work with transactions and dynamic execution. You will also learn how to maintain and query hierarchical structures in SQL Server. Several different solutions will be presented including: Nested Iterations, Enumerated Paths and Nested Sets. You will also learn how to query hierarchies using the new Recursive Common Table Expressions.

The course provides a dedicated module focusing on query tuning; introducing a tuning methodology developed by Solid Quality Learning and practiced in production systems. The module also covers tools for query tuning, analyzing execution plans, internal structures, index access methods, index optimization scale, set-based vs. iterative solutions, and query tuning examples. Moreover, query tuning is in the heart of this course and 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 and optimization of the solutions.
Target Audience:  T-SQL Programmers, Architects, Analysts and DBAs.
Those that need to write or review T-SQL code in SQL Server 2000 and 2005.

Prerequisite:  The course assumes at least a year of programming experience in SQL Server, mainly in T-SQL querying and code writing

Posted on Friday, August 1, 2008 9:38 AM | Back to top

Comments on this post: Advanced Transact-SQL Querying, Programming and Tuning for SQL Server 2000 & 2005 by Itzik Ben-Gan

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © TwinCitiesITandDevEvents | Powered by: