Data Education SQL Training
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.
$3995.00
Instructor: Itzik Ben-Gan
Dates: May 13-17, 2013
Location: Atlanta, GA
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.
TBD
Instructor: Allan Hirt
Dates: TBD
Location: Your City?
SQL Saturday #203 Pre-Seminar: No More Guessing! with Adam Machanic
Instructor: Adam MachanicFiguring out performance problems can sometimes feel like fumbling your way through a dark room. Maybe you’ll get lucky and find the right solution―or maybe you’ll stub your toe. Either way, it’s a slow, potentially painful process. In this full day seminar, a proven methodology will be illustrated through complete demonstrations that will teach you how to drill from high-level problem detection all the way to a specific spot in a query plan or deeper―pinpointing the exact problem and helping you to quickly solve it. Attend this seminar to take full control of your databases—and never again stumble blindly through the dimly lit world of performance troubleshooting.
TBD
Instructor: Adam Machanic
Dates: TBD
Location: Your City?
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.
Coming Soon!
Instructor: Rob Farley
Dates: TBD
Location: Your City?
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.
Coming Soon!
Instructor: Kalen Delaney
Dates: TBD
Location: Your City?
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.
Coming Soon!
Instructor: Adam Machanic
Dates: TBD
Location: Your City?
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.
TBD
Instructor: Julie Lerman
Dates: TBD
Location: Your City?
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.
TBD
Instructor: Andy Leonard
Dates: TBD
Location: Your City?
