Looks like this event has already ended.
Check out upcoming events by this organizer, or organize your very own event.
Advanced T-SQL Querying and Reporting: Building Effectiveness
Monday, May 14, 2012 at 9:00 AM - Wednesday, May 16, 2012 at 5:00 PM (EDT)
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
- SARGability and residuals
- Data modification
Module 2: Advanced T-SQL Features
- Distinct vs. GROUP BY
- Combining sets
- JOIN methods - logical and physical
- PIVOT and UNPIVOT
- OVER clause
- Ranking functions
- Analytic Functions
- OUTPUT clause
- Paging techniques
Module 3: Performance Considerations
- Indexes 2
- Data types
- Client-based solutions
- Memory management
- Dynamic SQL
When & Where
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.