This event has ended

Advanced T-SQL Querying and Reporting: Building Effectiveness

Data Education

Monday, May 14, 2012 at 9:00 AM - Wednesday, May 16, 2012 at 5:00 PM (EDT)

Chicago, IL

Advanced T-SQL Querying and Reporting: Building...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Attendee: Advanced T-SQL Querying and Reporting with Rob Farley Ended $1,600.00 $0.00

Share Advanced T-SQL Querying and Reporting: Building Effectiveness

Event Details

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. SQL Server MVP, author, and LobsterPot Solutions owner 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.)

 

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
Have questions about Advanced T-SQL Querying and Reporting: Building Effectiveness? Contact Data Education

When & Where


MicroTek Training Facility
230 West Monroe Street
Suite 550
Chicago, IL 60606

Monday, May 14, 2012 at 9:00 AM - Wednesday, May 16, 2012 at 5:00 PM (EDT)


  Add to my calendar

Organizer

Data Education

Data Education is a full-service training company, specializing in courses targeting DBAs, developers, and business intelligence professionals. Data Education brings the experts in the database field to its students, from bestselling SQL Server authors to the nation’s premier business intelligence consultants.

  Contact the Organizer
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.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.