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!

IEPML: Immersion Event on Practical Machine Learning

Just as these two shrimp are hidden within this anemone, critical information can be hidden within your data. The IEPML 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:

LIVE ONLINE IECS: Immersion Event on Columnstore Indexes

Taught by Jonathan Kehayias
LIVE ONLINE: March 26-28, 2019 (NEW)
- Click HERE for registration, pricing, and logistical details

IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1

Taught by Paul S. Randal, Kimberly L. Tripp
Chicago, IL: April 29-May 3, 2019
- Click HERE for logistics, cost, and registration details

IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2

Taught by Paul S. Randal, Kimberly L. Tripp, Jonathan Kehayias, Erin Stellato
Chicago, IL: May 6-10, 2019
- Click HERE for logistics, cost, and registration details

IECAG: Immersion Event on Clustering and Availability Groups

Taught by Jonathan Kehayias
Chicago, IL: April 29-30, 2019
- Click HERE for logistics, cost, and registration details

IEPowerBI: Immersion Event on Power BI, Power BI Report Server, and SSRS

Taught by Tim Radney
Chicago, IL: April 29-30, 2019 (NEW)
- Click HERE for logistics, cost, and registration details

IEAzure: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance

Taught by Tim Radney
Chicago, IL: May 6-9, 2019 ** SOLD OUT **
- Click HERE for logistics details

IE0: Immersion Event for the Junior/Accidental DBA

Taught by Jonathan Kehayias, Erin Stellato
Chicago, IL: May 1-3, 2019
- Click HERE for logistics, cost, and registration details

IEUpgrade: Immersion Event on Upgrading and New Features

Taught by Glenn Berry and Tim Radney
Chicago, IL: May 1-3, 2019
- Click HERE for logistics, cost, and registration details

IEPML: Immersion Event on Practical Machine Learning

Full title: Practical Machine Learning, AI & Data Science on SQL Server 2017, Microsoft ML Server, R, and Azure ML
Taught by Rafal Lukawiecki
This course has two parts, a 2-day introduction-level and a 3-day intermediate-level, that can be taken separately or back-to-back
Chicago, IL: May 6-10, 2019
- Click HERE for logistics, cost, and registration details

LIVE ONLINE IEQS: Immersion Event on Solving Common Performance Problems with Query Store

Taught by Erin Stellato
The next delivery of this class will be in Fall 2019

LIVE ONLINE IEPUM2017: Immersion Event on Planning and Implementing an Upgrade/Migration to SQL Server 2017

Taught by Glenn Berry
The next delivery of this class will be in Fall 2019

LIVE ONLINE IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems

Taught by Erin Stellato, Jonathan Kehayias, Kimberly L. Tripp
The next delivery of this class will be in Fall 2019

LIVE ONLINE IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning

Taught by Kimberly L. Tripp
The next delivery of this class will be in Fall 2019

LIVE ONLINE IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning

Taught by Kimberly L. Tripp
The next delivery of this class will be in Fall 2019

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.