SQL Server

W04 SQL for Application Developers - Attendees Choose


9:30am - 10:45am

Level: Introductory to Intermediate

Kevin Goff

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

In this session, Kevin will show 25 possible topics and attendees vote on which topics to cover.

That's right, attendees 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 that you'll walk away with 25 code samples, even though we'll only cover a portion of them in the presentation.

You will learn:
  • The new language enhancements in SQL 2012
  • Where sub-queries are necessary
  • Gain some appreciation of performance optimization