Data Education SQL Training

SQL Server Training Course

Advanced T-SQL Querying, Programming, and Tuning for SQL Server 2005, 2008, and 2012

Instructor: Itzik Ben-Gan

Isn’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.

Course Details

Register

TBD

Instructor: Itzik Ben-Gan

Dates: TBD

Location: Your City?

SQL Server Training Course

Forget Mission Impossible–This is Mission Critical: High Availability for SQL Server 2008 and 2012

Instructor: Allan Hirt

Whether 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.

Course Details

Register

TBD

Instructor: Allan Hirt

Dates: TBD

Location: Your City?

SQL Server Training Course

SQL Saturday #203 Pre-Seminar: No More Guessing! with Adam Machanic

Instructor: Adam Machanic

Figuring 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.

Course Details

Register

TBD

Instructor: Adam Machanic

Dates: TBD

Location: Your City?

SQL Server Training Course

Advanced T-SQL Querying and Reporting: Building Effectiveness

Instructor: Rob Farley

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.

Course Details

Register

Coming Soon!

Instructor: Rob Farley

Dates: TBD

Location: Your City?

SQL Server Training Course

SQL Server 2005, 2008, 2012 Internals and Query Tuning

Instructor: Kalen Delaney

Understanding 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.

Course Details

Register

Coming Soon!

Instructor: Kalen Delaney

Dates: TBD

Location: Your City?

SQL Server Training Course

Extreme Query Performance

Instructor: Adam Machanic

This 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.

Course Details

Register

Coming Soon!

Instructor: Adam Machanic

Dates: TBD

Location: Your City?

SQL Server Training Course

Entity Framework Boot Camp

Instructor: Julie Lerman

Spend 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.

Course Details

Register

TBD

Instructor: Julie Lerman

Dates: TBD

Location: Your City?

SQL Server Training Course

From Zero to SSIS! Learning SQL Server Integration Services

Instructor: Andy Leonard

From 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.

Course Details

Register

TBD

Instructor: Andy Leonard

Dates: TBD

Location: Your City?