Courses - Advanced-T-SQL-Querying,-Programming-and-Tuning-for-SQL-Server-2005-and-2008

Home

Development

Infrastructure

Training

Infrastructure Courses

SharePoint Courses

CRM Courses

Custom Training Solutions

Frequently Asked Questions

Hotels

Map to Alto

Cloud Accelerate
Partner

Advanced T SQL Querying Programming and Tuning for SQL Server 2005 and 2008

Course Number:	SQM-TASQLPrg08
Length:	5 Day
Price:	$3,950.00
	Or Register by Phone 1-888-600-ALTO (2586)

Upcoming Classes

Start Date

End Date

Location

04/16/2012

04/20/2012

Alto Partner Site

Description

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

Course Outlines

Audience

This course is intended for T-SQL Programmers, DBAs, Architects and Analysts. Those that need to write or review T-SQL code in SQL Sever 2005 and 2008.

Prerequisites

At least one year of T-SQL querying and programming experience in SQL Server

Module 01: Logical Query Processing

Logical Query Processing Order
Logical Query Processing Example
Phase Details
Set Operations

Module 02: Query Tuning

Internals and Index Tuning
Temporary Tables
Sets vs. Cursors
Query Tuning with Query Revisions

Module 03: Subqueries, Ranking Functions, Joins and Set Operations

Subqueries
Analytical Ranking Functions
Joins
Set Operations
Lab

Module 04: Aggregating and Pivoting Data

The OVER Clause
Tie Breakers
Running Aggregations
Pivoting and Unpivoting Data
Custom Aggregations
Histograms
Grouping Sets
Lab

Module 05: TOP and APPLY

TOP
APPLY
Lab

Module 06: Data Modification

Inserting Data
Deleting Data
Updating Data
Merging Data
The OUTPUT Clause
Lab

Module 07: Datatype Related Problems

Date and Time Manipulation
Datatype Enhancements
Lab

Module 08: Programmable Objects

Dynamic SQL
Views
User Defined Functions
Stored Procedures
Triggers
Transactions and Concurrency
Exception Handling
Lab

Module 09: Graphs, Trees and Hierarchies

Graphs, Described
Common Requests against Graphs
Enumerated Paths Model
Nested Sets Model
Recursive Queries
The HIERARCHYID Datatype
Lab

Or Register by Phone 1-888-600-ALTO (2586)