Create faster and more secure applications

SQL Server courses for developers

Buy Now

You can’t be a great developer if you don’t understand how data works

Database technologies are constantly changing. To scale your application, you need to understand the data platform and how it performs.

Imagine your applications: available, reliable, and scalable

Developers who understand how to recognize and troubleshoot poor performance build applications that can stand the test of time. When you learn SQL Server and technology specific to the database, you create more secure and scalable applications.

Our developer courses are taught by industry experts who understand what developers need in order to create effective SQL Server code. Choose from a variety of Immersion Event courses that will help you widen your SQL Server knowledge and hone your skills. Each class can be taken as a standalone and doesn’t require a prerequisite.

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

Courses for Developers

IETLB

Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning

No longer think of SQL Server as a black-box that “just works.”

While SQL Server can do a lot for you, it also has a lot of options—each with pros and cons for certain environments. Learning how to fundamentally interact with SQL Server’s locking strategy will make you a proficient and effective developer—helping to improve scalability and manageability of your code.

Learn More
Buy Now
  • Batches, Transactions, and Error Handling
  • Locking / Isolation
  • Locking, Blocking, and Intro to Deadlocks
  • The Anatomy of a Data Modification
  • Table Maintenance & Schema Locks
  • Versioning

IEQUERY

Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems

Some of the most common and incorrectly identified problems are around queries and how SQL Server optimizes and caches code. This course focuses on the most common problems and their proper solutions!

Learn More
Buy Now
  • Capturing Query Information and Analyzing Plans
  • Backup & Recovery
  • Differentiate and Solve Caching / Statistics Problems

IEVLT

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

As more and more data is retained, tables grow larger and larger. Having a very large table (VLT) in SQL Server is possible but many tasks can be negatively affected by table size. Knowing how to better architect these VLTs will improve your performance, availability, and manageability

Learn More
Buy Now
  • Horizontal Partitioning Strategies
  • Partitioned Tables
  • Implementing the Sliding Window Scenario
  • Partitioning Techniques Combined
  • Partitioned Views
  • Tables, Indexes, Keys, & Relationships
  • Key Partitioning Concerns & Considerations
  • Review

IECS

Immersion Event on Columnstore Indexes

Columnstore indexes were introduced with SQL Server 2012 and the features across versions 2012, 2014, and 2016 varied greatly. However, in SQL Server 2016 and higher, they are essential to understand. While not every table can benefit from these, you might find a lot of power in their correct use for large, read-mostly/reporting tables.

Learn More
Buy Now
  • Columnstore Index Basics
  • Dynamic Management Views
  • Columnstore Index Maintenance
  • Columnstore Usage Strategies
  • Data Loading Patterns
  • Partitioned Tables

What past attendees are saying

"Great course! Impressive scope and depth of knowledge, very well delivered with real-world examples and practical takeaways."
Student
"The SQLskills training courses are excellent! Thank you for offering such an outstanding set of courses dedicated to SQL Server!"
Student
"The SQLskills classes never disappoint. So much information is presented in a short amount of time but that is so much better than most classes with a lot of free time and fluff."
Student
"A great course with much to take back to the office. Would recommend SQLskills to anyone and everyone."
Student
"Awesome course! Awesome instructors! Awesome event overall! The SQLskills courses are the best overall intensive courses for SQL Server."
Kirby RichterDell
"By far the most useful and educational training I have attended. Aside from the material covered, which was well organized, the discussions and Q&A information was great."
Student
Previous
Next

Feel like you need to broaden your skillset?

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

Accidental and Junior DBAs

Mid-level and Senior DBAs

Architects

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.

Learn More

It’s time to get ahead of the curve

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

Buy Now