SQL Server Locking, Blocking and Deadlocks for Developers and DBAs

Learn to find and fix locking issues, and to avoid them in the first place.

Course Summary

 

Are you grappling with issues related to SQL Server or Azure SQL Database? Do you find yourself dealing with what you think are blocking problems, but aren’t quite sure what’s actually going wrong?  

Often, what customers refer to as blocking issues might be a misunderstanding of locks held for extended periods or even deadlocks. These challenges are common, but with the right knowledge, you can resolve them effectively.  

In this course, you’ll gain a deep understanding of how SQL Server manages transactions and locks, and get clarity on isolation levels and their appropriate usage. Whether you’re looking to expand your foundational knowledge or address specific, persistent issues, this course provides:
 
Expert Insights: Learn from a seasoned professional who tackles these issues on customer sites regularly.

Practical Exercises: Optional hands-on activities to apply what you’ve learned and solidify your understanding.

Interactive Quizzes: Test your knowledge and ensure you’re on the right track.

If you're ready to move beyond basic concepts and gain practical, actionable insights into locking, blocking, and deadlocks, this course is tailored for you. Enhance your skills, resolve issues efficiently, and become a more effective developer or DBA.

Course Curriculum

Greg Low

Paul Thompson

Developer​​

Wow. I can't believe how much I learned in this course. It's not too long but really hits the mark. Our users were endlessly complaining about deadlocks and slow performance cause by locking. This course has let me find and fix so many of our issues.

Thank you. Thank you. Thank you !!

Course Pricing

Most popular

Locking Course Access

$195 USD

Enrol

© 2024 SQL Down Under