Level: Introductory to Intermediate

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

That's right—you choose! I'll show 25 possible topics on the screen, and the attendees vote on which topics we will cover. Everything from isolation levels to ranking, table-valued functions, querying temporal data, instances where sub-queries are necessary, update triggers, reading execution plans, and even the new analytic functions in SQL 2012 along with common gotchas in T-SQL programming when aggregating multiple child tables. The good news is you'll walk away with 25 code samples, even though we'll only cover a portion of them in the presentation.

You will learn:

• New language enhancements in SQL 2012
• Where sub-queries are necessary
• Gain some appreciation of performance optimization