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.)
Coming Soon!
Instructor: Rob Farley
Dates: TBD
Location: Your City?
Download the course details for yourself or your employer!
- 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
Data Educaiton accepts Visa, MasterCard, Discover, American Express, PayPal, eCheck, personal & business checks and purchase orders.
Course Time: 9:00 AM - 5:00 PM
Download the full course details in a convenient PDFUsing 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
