SQL Server Training Schedule

IE0: Immersion Event for the Accidental/Junior DBA

Just like this grouper is hiding inside a giant barrel sponge, as a new DBA you might be feeling scared of your new responsibilities around SQL Server. There's a lot to learn, but where do you start? What's important and what's not? This course will help you learn how to keep the lights on so that SQL Server meets the business requirements for availability and performance.

IEPTO1: Performance Tuning and Optimization – Part 1

Just as zooxanthellae help to build a reef, IEPTO1 builds a data professional’s SQL Server PTO foundation. In this 3/400-level course we cover performance tuning of data files, log files and logging, tempdb, table and index structures and then we show how to create and tune using a comprehensive indexing and statistics strategy. This deep course is the core of a strong SQL Server professional – whether developer, administrator, or architect.

IEPTO2: Performance Tuning and Optimization – Part 2

Just as a dolphin effortlessly glides through the water, after attending IEPTO1 and IEPTO2 you will be able to dive deep into your SQL Server problems. This course builds on our IEPTO1 course and includes deep troubleshooting and workload analysis. The primary focus is on monitoring resource usage, properly using wait statistics and Extended Events, analyzing query plans and the plan cache, tuning CPU and memory-specific problems, and much, much more!

IEHADR: High Availability and Disaster Recovery

There are many things to evaluate to reduce SQL Server downtime and data loss when disaster strikes - some are simple, some complex. High availability and limited data loss do not just happen. IEHADR helps you understand and troubleshoot the myriad HA/DR features in SQL Server so you can architect the RIGHT solution for your business needs and service level agreements. Don't let your ship sink!

IEPDS: Immersion Event on Practical Data Science

Just as these two shrimp are hidden within this anemone, critical information can be hidden within your data. The IEPDS course shows you how to access that information and turn it into a valuable business asset. During the week we cover R, Azure Machine Learning, and SQL Data Mining, giving you the foundations required to organize, process, and present information, whatever your requirements are.

SQLskills Immersion Event Schedule

Our current SQL Server training schedule is listed here. If you need help justifying training to your organization, we can help you:

IE0: Immersion Event for the Junior/Accidental DBA

Taught by Jonathan Kehayias, Erin Stellato
Chicago, IL: November 7-9, 2016
- Click HERE for registration and logistical details
Chicago, IL: April 24-26, 2017 NEW! US$120 discount for registering in 2016!
- Click HERE for registration and logistical details

IEPTO1 (formerly IE1): Immersion Event on Performance Tuning and Optimization – Part 1

If you’ve taken IE1, you don’t need to take this class: IEPTO2 is the next class we recommend.
Taught by Paul S. Randal, Kimberly L. Tripp
Dublin, Ireland: October 3-7, 2016 Note: no Europe classes in 2017!
- Click HERE for registration and logistical details on our partner Prodata’s website
Chicago, IL: November 7-11, 2016
- Click HERE for registration and logistical details
Chicago, IL: April 24-28, 2017 NEW! US$200 discount for registering in 2016!
- Click HERE for registration and logistical details

IEPTO2 (formerly IE2): Immersion Event on Performance Tuning and Optimization – Part 2

If you’ve taken IE2, you don’t need to take this class. If you haven’t taken IE1/IEPTO1 then IEPTO1 is the next class we recommend.
Taught by Paul S. Randal, Kimberly L. Tripp, Jonathan Kehayias, Erin Stellato
Chicago, IL: May 1-5, 2017 NEW! US$200 discount for registering in 2016!
- Click HERE for registration and logistical details

IEHADR (formerly IE3): Immersion Event on High Availability and Disaster Recovery

If you’ve taken IE3, you don’t need to take this class. We recommend taking IEPTO1 before this class, although it is not required.
Note: we will be retiring this class after 2017!!
Taught by Paul S. Randal, Kimberly L. Tripp, Jonathan Kehayias, Glenn Berry
Chicago, IL: May 8-12, 2017 NEW! US$200 discount for registering in 2016!
- Click HERE for registration and logistical details

IEPDS: Immersion Event on Practical Data Science

Full title: Immersion Event on Practical Data Science with Cortana Analytics: Azure Machine Learning, SQL Data Mining and R.
Taught by Rafal Lukawiecki
Chicago, IL: November 7-11, 2016
- Click HERE for registration and logistical details
Chicago, IL: May 8-12, 2017 NEW! US$200 discount for registering in 2016!
- Click HERE for registration and logistical details

IEBI: Immersion Event on Business Intelligence

Taught by Stacia Varga
Chicago, IL: May 1-5, 2017 NEW! US$200 discount for registering in 2016!
- Click HERE for registration and logistical details

IESSIS1: Immersion Event on Learning SQL Server Integration Services

Taught by Andy Leonard
Chicago, IL: April 24-28, 2017 NEW! US$200 discount for registering in 2016!
- Click HERE for registration and logistical details

IESSIS2: Immersion Event on Advanced SQL Server Integration Services

Taught by Andy Leonard and Tim Mitchell
Chicago, IL: May 1-5, 2017 NEW! US$200 discount for registering in 2016!
- Click HERE for registration and logistical details

IEPS: Immersion Event on PowerShell for SQL Server DBAs

Taught by Ben Miller
Chicago, IL: May 8-10, 2017 NEW! US$120 discount for registering in 2016!
- Click HERE for registration and logistical details

Immersion Event Details

For details on all classes including curricula, costs, and testimonials see here.

Questions?

If you have any questions, please check the comprehensive F.A.Q. page.