SQL Training

Advanced T-SQL Querying and Reporting: Building Effectiveness

This three-day course is a journey through the more advanced side of T-SQL, designed to help you create queries that are simply more effective. Microsoft MVP and author Rob Farley, visiting Chicago from Australia for a limited time, takes his students on a road trip of unlearning bad habits of querying and reporting, and into a deeper understanding of what makes a query effective. Common student feedback for this course includes “You’ve made me want to go back and rework every query I’ve ever written” and “I didn’t realize how much I didn’t understand about even the fundamental parts of T-SQL.”

Now it’s your turn to find out what your T-SQL has been missing. Come away with the knowledge necessary for writing queries that get the work done, and fast, and for more powerful reporting. Register now to switch from doing what you know to knowing what you do.

(The T-SQL taught will be primarily for SQL Server 2012, but most of the principles taught will also apply equally to SQL Server 2005 and SQL Server 2008.)

Register

Coming Soon!

Instructor: Rob Farley

Dates: TBD

Location: Your City?

Course Detail PDF Download of: Advanced T-SQL Querying and Reporting: Building Effectiveness

Download the course details for yourself or your employer!

Module 1: Query Execution
  • SELECT statement components
  • Execution plans
  • Simplification of views and sub-queries
  • Indexes
  • SARGability and residuals
  • Data modification

Module 2: Advanced T-SQL Features
  • Distinct vs. GROUP BY
  • Combining sets
  • JOIN methods - logical and physical
  • APPLY
  • CTEs
  • PIVOT and UNPIVOT
  • OVER clause
  • Ranking functions
  • LAG/LEAD
  • Analytic Functions
  • OUTPUT clause
  • Paging techniques

Module 3: Performance Considerations
  • Indexes 2
  • Hints
  • Data types
  • Full-text
  • Cursors
  • TVPs
  • UDFs
  • Client-based solutions
  • Locking
  • TempDB
  • Memory management
  • Dynamic SQL

Intended Audience

This course is designed for SQL Server professionals who already feel familiar with T-SQL and desire to move to the next level. Whether a student has been writing queries for six months or six years, this course will give them a clearer, better idea of what is going on behind the scenes of their queries. The T-SQL taught will be primarily for SQL Server 2012, but most of the principles taught will also apply equally to SQL Server 2005 and SQL Server 2008.

Prerequisites

Students should feel comfortable reading and writing basic queries that use the fundamental clauses SELECT, FROM, ON, WHERE, GROUP BY, HAVING, UNION ALL and ORDER BY.

What You Will Learn

Rob starts the course by breaking down the basic SELECT statement, giving students a deeper knowledge of the relationship between the query and the execution plan and removing some of the preconceptions about the way that various constructs are used. From there, the class will involve discussion of:
  • More advanced T-SQL features
  • Tools for evaluating approaches using T-SQL
  • Performance considerations and dealbreakers
  • Resolution of reporting issues
  • More advanced T-SQL features

Instructor Bio:

Rob Farley

Rob Farley runs LobsterPot Solutions, a Gold Partner SQL Server and Business Intelligence consultancy in Adelaide, Australia. He presents regularly at PASS chapters and conferences such as TechEd Australia, SQL PASS, and SQLBits (UK), and heads up the Adelaide SQL Server User Group. He is an MCT and has been a SQL Server MVP since 2006.

Rob has helped create several of the MCP exams, wrote two chapters for the book SQL Server MVP Deep Dives (Manning, 2009) and one for SQL Server MVP Deep Dives 2, Volume 2 (Manning, 2011). He is currently a Director of SQLPASS.

People who have attended Rob's sessions at conferences such as the PASS Summit can attest to the fact that his insight into query execution is quite unique. He has an extremely personable approach to teaching—challenging your thinking and stretching your mind while keeping the room interested and on track.

Location: Your City?

Registration: Coming Soon! Click here to request this course

Visa, MasterCard, Discover, American Express, PayPal, eCheck, Check, Purchase Order

Data Educaiton accepts Visa, MasterCard, Discover, American Express, PayPal, eCheck, personal & business checks and purchase orders.

Course Dates: TBD (3 Days)
Course Time: 9:00 AM - 5:00 PM
Course Detail PDF Download of: Advanced T-SQL Querying and Reporting: Building Effectiveness Download the full course details in a convenient PDF

Using a Purchase Order or Check?

If a purchase order is required for invoice, please send us the P.O. number using our contact form. Be sure to indicate the course title and attendee name(s) in your message.

We accept personal and business checks for course registrations up to 15 business days before the start date of the desired course. If paying by check, remember that it can take up to 5 business days to arrive at our office through postal mail depending on your location. Please include a note telling us the course title and attendee name(s), and make your check payable to:

Data Education
15 Lincoln Street
Suite 226
Wakefield, MA 01880

Refund & Cancellation Policy

If Data Education cancels the course, you will receive a 100% refund. Registration is fully transferable to a course of the same or lesser value within one year’s time of the initial course. If you cancel your registration with more than 30 days notice, Data Education will refund the fee minus $250 for processing. If you cancel your registration with between 16 and 30 days notice, Data Education will refund 75% of the fee. If you cancel your registration with between 7 and 15 days notice, Data Education will refund 50% of the fee. Cancellations unfortunately will not be allowed as of 6 days before the beginning of the course.