SQLskills Immersion Events
Our current SQL Server Immersion Event offerings and schedule are listed on this page. If you need help justifying training to your organization, we can help you:
- Letter to your boss explaining why SQLskills training is worthwhile
- Community blog posts about our classes
- For details on all classes including curricula, costs, and testimonials see here
If you’re ready to purchase —>>>
Training Options
Live, in-person deliveries:
We are not planning ANY in-person events for 2023, and we will review options late in 2023 for 2024. Additionally, we have found that the shorter days and longer overall class times when delivering our courses live online are proving to be really beneficial for such deep-technical content. For our two main courses (IEPTO1 and IEPTO2), it’s unlikely that we will EVER go back to a 5-day, in-person delivery.
Live, online deliveries:
We are focused on delivering amazing online experiences! So far, we have delivered our intense, deep-technical courses as LIVE / online / interactive events with great success. We call them “Immersion Events” as they are intense, deep, real-world, PRACTICAL content that helps you THRIVE as a SQL Server data professional. Instead of requiring an entire week out of office with travel costs and time away from home, our online courses have been broken down into smaller, more digestible chunks. This highly effective format allows you to stay fresh and focused and even keep up with some of your daily duties! And, of course, you don’t have the hassle or expense of even having to get dressed up for class. Our daily course format is as follows:
- 90 minutes of lecture
- Up to 30 minutes of Q&A
- 30-minute break
- 90 minutes of lecture
- Up to 60 minutes of Q&A
Discounts Available
- FOR OUR BIG SALES, NO OTHER DISCOUNTS APPLY! However, alumni who want to attend the SAME course as one already attended, can RETAKE the same course for 50% OFF. Send us an email so we can generate a special discount code for you. For example. if you attended IEPTO1 on SQL Server 2014, you can RETAKE the LIVE delivery of IEPTO1 again for 50% OFF!
- ALUMNI: If you are a former attendee of a SQLskills Immersion Event (whether online or in-person), you are ALWAYS eligible for the “alumni” discount on individual courses. Please send us an email so that we can give you a special code to use in our shop!
- Updating your SQL skills to 2022: Alumni who want to attend the SAME course as one already attended, can RETAKE the same course for 50% OFF. Send us an email so we can generate a special discount code for you. For example. if you attended IEPTO1 on SQL Server 2014, you can RETAKE the LIVE delivery of IEPTO1 again for 50% OFF!
- BUY IN BULK: For those of you who want to attend multiple courses or a mix of courses for a group of folks at your company – we offer our “6 for 5” discount. If you purchase 6 seats for any combination of INDIVIDUAL courses, we’ll give you the price for only 5 (you get one free – which is roughly 17% OFF)! Please contact us for special pricing and options.
- LARGER GROUPS & SITE-LICENSING is available. Please contact us for special pricing and options.
Recorded Courses:
We always offer the latest recordings from our last delivery.
Individual Course Recordings: All of our courses are available individually
1 Year Access: This option gives you full access to the complete course for 1 year from date of activation (payment received). 1 Year Access courses are available for all of our immersion events and available at 50% OFF regular price!
NOTE: If you attend a LIVE, online delivery – not only do you have a dedicated training schedule, get the latest course updates, the ability to interact with your instructors and other students, and but you also receive access to that course’s recordings with no expiration!
- SQLskills Alumni – if you’ve attended a PAST Immersion Event (on any version other than the latest) and you want to Update Your SQL skills to the latest version, you can retake that same course LIVE for 50% OFF the LIVE course price! Send us an email so we can generate a special discount code for you.
Short Courses: These are shorter Immersion Events and more singularly focused on their topics. These courses are designed to enhance the content in one focused area (e.g. our Short Courses on Query Store (IEQS), Very Large Tables (IEVLT), and Columnstore (IECS)). Once purchased you have full access to the complete course for 1 year from date of activation (payment received).
Completed Online Deliveries: these are for students who attended the LIVE, online event. When you attend an online course your access to that’s delivery’s content does NOT expire.
Bundles!
Bundles are your BEST option for more comprehensive and targeted training with absolutely the lowest price! Bundles can consist of combinations of live and recorded courses. Scroll down past the list of individual courses to read about our budget-friendly bundles!
Courses Available
IE0: Immersion Event for the Accidental and Junior DBA
- Instructors: Jonathan Kehayias, Erin Stellato
- Recorded delivery from September 2020 (SQL Server 2019) is available
IEAzure: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance
- Instructor: Tim Radney
- Recorded delivery from Feb/March 2021 (SQL Server 2019) is available
IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1
- Instructors: Paul S. Randal, Kimberly L. Tripp
- Recorded delivery from March 2021 (SQL Server 2019) is available
IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2
- Instructors: Paul S. Randal, Kimberly L. Tripp, Jonathan Kehayias, Erin Stellato
- Recorded delivery from March 2021 (SQL Server 2019) is available
IECAG: Immersion Event on Clustering and Availability Groups
- Instructor: Jonathan Kehayias
- Recorded delivery from October 2020 (SQL Server 2019) is available
IEQuery: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems
- Instructors: Erin Stellato, Kimberly L. Tripp, Jonathan Kehayias
- Recorded delivery from February 2019 (SQL Server 2017) is available
IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning
- Instructor: Kimberly L. Tripp
- Recorded delivery from February 2019 (SQL Server 2017) is available
IEQS (2019): Immersion Event on Solving Common Performance Problems with Query Store
- Instructor: Erin Stellato
- Recorded delivery from May 2021 (SQL Server 2019) is available
IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning
- Instructor: Kimberly L. Tripp
- Recorded delivery from May 2021 (SQL Server 2019) is available
IECS: Immersion Event on Columnstore Indexes
- Instructor: Jonathan Kehayias
- Recorded delivery from November 2019 (SQL Server 2017) is available
If you’re ready to purchase —>>>
Targeted Training Paths and Bundles
One course just can’t possibly “cover it all” with a product both as complex and as flexible as Microsoft SQL Server. Our team has over 100 years of collective experience working with SQL Server and in that time, we’ve learned a lot of tips and tricks as well as the best way to work through different problems. From our experience, we created our Immersion Events. For your best experience, you will want to continue your training gradually – taking time to digest and understand the content – and ALWAYS keep learning! Our bundles offer you a lot of options to do exactly that.
THE Blackbelt Bundle
The SQLskills Blackbelt Bundle includes all SEVEN of our core courses. With our most recent recordings, this means over 158 hours of deep, technical content.
The curriculum for this bundle includes these courses:
- IEAzure: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance
- IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1
- IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2
- IECAG: Immersion Event on Clustering and Availability Groups
- IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning
- IECS: Immersion Event on Columnstore Indexes
- IEQS: Immersion Event on Solving Common Performance Problems with Query Store
You can achieve the SQL Server 2019 Blackbelt Badge ONLY if at least HALF (a minimum of 4, and must include IEPTO1 and IEPTO2) are attended on SQL Server 2019. If you have attended one of our Immersion Events (IEPTO1 and/or IEPTO2 ) on an earlier version of SQL Server and want to Update your SQL skills to SQL Server 2019 for half price, send us an email to receive a special discount code. If you also want to attend other courses, a bundle might save you even more!
Review the Complete Details on All SQLskills Bundles Here
Complete Short Course Bundle
The SQLskills Complete Short Course Bundle includes all five of our focused short courses. This bundle includes over 57.5 hours of deep, technical content focused on topics KEY to solid development best practices.
The curriculum for this bundle includes these courses:
- IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning (13:15:55)
- IEQuery: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems (11:15:02)
- IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning (13:51:39)
- IECS: Immersion Event on Columnstore Indexes (10:39:42)
- IEQS: Immersion Event on Solving Common Performance Problems with Query Store (9:47:43)
Each “short course” is regularly priced at $395 or $495 per recorded course; within this bundle the individual course price drops to $295 per course ($1,475.00 for all five together). See the SHOP for any CURRENT SALE PRICES.
SQL Server Jumpstart Bundle
Includes access for ONE YEAR to all of our currently recorded versions of IE0, IEQuery, IETLB.
The curriculum for this bundle includes these courses:
- IE0: Immersion Event for the Accidental and Junior DBA (32:18:59)
- IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning (13:15:55)
- IEQuery: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems (11:15:02)
The full price for all three of these already-discounted, recorded courses is $2,485. You can purchase the bundle for an additional 20% savings at $1,995! See the SHOP for any CURRENT SALE PRICES.
SQL Server Jumpstart+ Bundle
Adds the remaining short courses from our Complete Short Course Bundle to include one year of access to all of our currently recorded versions of IE0, IEQuery, IETLB plus IEVLT, IECS, and IEQS
The curriculum for this bundle includes these courses:
- IE0: Immersion Event for the Accidental and Junior DBA (32:18:59)
- IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning (13:15:55)
- IEQuery: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems (11:15:02)
- IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning (13:51:39)
- IECS: Immersion Event on Columnstore Indexes (10:39:42)
- IEQS: Immersion Event on Solving Common Performance Problems with Query Store (9:47:43)
The full price for all six of these already-discounted, recorded courses is $3,870.00. You can purchase the bundle for an additional 36% savings at $2,495! See the SHOP for any CURRENT SALE PRICES.
SQL Server 2019 Performance Tuning Bundle
Includes access for ONE YEAR to our two most popular performance tuning courses: IEPTO1 and IEPTO2.
The curriculum for this bundle includes these courses:
- IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 (43:17:40)
- IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2 (40:00:55)
The full price for these two already-discounted, recorded courses is $3,990.00. You can purchase the bundle for an additional 15% savings at $3,395! See the SHOP for any CURRENT SALE PRICES.
SQL Server 2019 Blackbelt Bundle
Includes access for ONE YEAR to all of our currently recorded versions of IEAzure, IEPTO1, IEVLT, IEPTO2, IEQueryStore, IECAG, and IECS.
The curriculum for this bundle includes these courses:
- IEAzure: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance (22:30:22)
- IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 (43:17:40)
- IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2 (40:00:55)
- IECAG: Immersion Event on Clustering and Availability Groups (18:07:27)
- IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning (13:51:39)
- IECS: Immersion Event on Columnstore Indexes (10:39:42)
- IEQS: Immersion Event on Solving Common Performance Problems with Query Store (9:47:43)
The full price for all seven of these already-discounted, recorded courses is $7,915. You can purchase the bundle for an additional 10% savings at $6,995! See the SHOP for any CURRENT SALE PRICES.
If you’re ready to purchase —>>>
Questions?
If you have any questions, please check our comprehensive F.A.Q. page.