Data Education SQL Training
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.
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.
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.
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.
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.
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.
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.
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.