Become the DBA who can do it all

Essential SQL Server performance tuning and optimization courses for Mid-level and Senior DBAs

Tools change, software evolves, and along with it so does your job

You’re responsible for the databases that support your company’s applications, and the skills you need change faster than you can keep up.

Meet challenges head-on and stay ahead of disruptive technology

The modern DBA has become a business asset. You not only have to stand up servers and tune performance, but today you exist to partner with business leaders and demonstrate your value. No pressure, right?

We want to help you deliver elegant solutions that unite technology and business. We design training courses so you can get on top of changes in SQL Server and the Microsoft Data Platform. We believe the best technical learning is completely immersive and our focused events create life-long skills for our students. It’s time to transition from simply reacting to your database issues, to proactively driving your team’s success. ​

  • Live, instructor-led content
  • Hours of in-depth instruction
  • Chat and connect with peers and instructors

Courses for Mid-level and Senior DBAs

IEPTO1

Immersion Event on Performance Tuning and Optimization – Part 1

IEPTO1 is part one of two core courses for performance, tuning, and optimizing SQL Server systems. It focuses on the design and foundation of a solid SQL Server database—from data and log files to tempdb to indexing strategies and statistics to proper database maintenance.

It is highly recommended that you complete this course before taking IEPTO2.

  • Database Structures
  • Locking and Blocking
  • Logging, Recovery, and the Transaction Log
  • Index Fragmentation
  • Internals and Updates
  • Data File Internals and Maintenance
  • Isolation Levels and Versioning
  • Index Internals
  • Internals and Data Access
  • Indexing Strategies
  • Cardinality Estimation Issues

IEPTO2

Immersion Event on Performance Tuning and Optimization – Part 2

A lot of the solutions tie back to concepts presented in IEPTO1, but this course teaches you how to identify and troubleshoot problems from I/O to memory to CPU. Together these courses make an excellent foundation for a successful DBA career.

  • Creating a Foundation for Tuning and Optimizing
  • Wait Statistics Analysis
  • SQLOS Scheduling and CPU Performance Tuning
  • Putting New Features into Practice
  • Index Analysis
  • Extended Events
  • Deadlock Analysis
  • I/O Concepts and I/O Subsystems for DBAs
  • Analyzing Query Performance
  • Statement Execution, Stored Procedures, PlanCache
  • Performance Issue Patterns

IEQS

Immersion Event on Solving Common Performance Problems with Query Store

Query Store was designed for anyone who administers SQL Server, but those who want to leverage the feature to its fullest capacity also benefit from this course.

Considerations about configuration, implementation, and feature management are covered, along with using Query Store for troubleshooting basic and advanced performance issues, plan forcing, and workload analysis.

  • Query Store Fundamentals
  • Workload Characteristics and Query Store Performance
  • Forcing Plans
  • Other Uses of Query Store
  • Understanding the Query Store Data
  • Finding Performance Issues
  • Automatic Tuning
  • Visualizing Query Store Data

What past attendees are saying

Feel like you need to broaden your skillset?

A solid DBA has experience across many areas of SQL Server.

Not able to attend an in-person event?

Get the training you need, where and when you want it.

We work with Pluralsight to offer flexible, online training courses so you can get the skills you need on your schedule. Mix and match courses across all disciplines and in smaller, topic-based formats suited to your needs. These online courses are also a fantastic way to review and refresh your Immersion Event knowledge at any time.

It’s time to get ahead of the curve

Invest in learning new skills and you’ll elevate your entire team’s capabilities.