Skip Navigation Links
Home
Development
Infrastructure
Training
CRM
SharePoint
 
Skip navigation links
Class Registration
Classes Offered
Developer Courses
Infrastructure Courses
SharePoint Courses
CRM Courses
Custom Training Solutions
Testimonials
Brochures
Room Rental
Custom Training
More Information
Training Facilities
Frequently Asked Questions
Hotels
Map to Alto
Contact Us

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 DateEnd DateLocation
04/16/201204/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)
 
Sign In


Alto Consulting & Training | 7210 Metro Blvd Minneapolis, MN 55439 | phone 952.831.6604 fax 952.893.8080
Copyright © 1996-2009, and Hosted by Alto Consulting and Training