Data Education SQL Training
Forget Mission Impossible–This is Mission Critical: High Availability for SQL Server 2008 and 2012
Instructor: Allan HirtWhether your business hours are 9 to 5 or 24x7x365, your systems need to be up when you need them. How you get to the availability you need is a combination of people, process, and technology. At the end of the course, you will have real-world knowledge based on actual implementations, not just theory, that you can go back and use immediately.
Advanced T-SQL Querying, Programming, and Tuning for SQL Server 2005, 2008, and 2012
Instructor: Itzik Ben-GanIsn’t it about time you mastered the ins and outs of T-SQL? Learn how to efficiently and effectively implement T-SQL in SQL Server 2005, SQL Server 2008, and the soon-to-be-released SQL Server 2012 in this five-day, intensive course with SQL Server MVP, author, and co-founder of SolidQ, Itzik Ben-Gan.
Advanced T-SQL Querying and Reporting: Building Effectiveness
Instructor: Rob FarleyThis 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.
Entity Framework Boot Camp
Instructor: Julie LermanSpend five days drilling into the Entity Framework with the leading independent authority on the topic: Julie Lerman. Come with some working knowledge of Entity Framework and leave with an expertise in Entity Framework 4.1 Code First and advanced techniques for harnessing Entity Framework for your enterprise application.
SQL Server 2005, 2008, 2012 Internals and Query Tuning
Instructor: Kalen DelaneyUnderstanding SQL Server means knowing the product inside and out. In this world-renowned five-day course with longtime internals expert and Microsoft MVP Kalen Delaney, students will learn how to take a long, hard look at the SQL Server relational engine. After better understanding what’s happening internally, students will get the opportunity to investigate how internals can affect how you set up your databases for maximum performance and reliability.
Extreme Query Performance
Instructor: Adam MachanicThis two-day course is designed to teach you to leverage SQL Server’s built-in parallelism features in conjunction with the SQLCLR framework in order to achieve massive improvements in query performance. These techniques have been used on numerous projects to quickly bring large query run times from hours to seconds.
From Zero to SSIS! Learning SQL Server Integration Services
Instructor: Andy LeonardFrom Zero to SSIS! is designed to train technology professionals in the fine art of using SQL Server Integration Services (SSIS) to build data integration and Extract-Transform-Load (ETL) solutions. The three-day course is focused around labs and emphasizes a hands-on approach.








