In many of my courses and lectures, I talk about how unintuitive some features and syntax can be. In terms of development, one of the most complex, confusing, and potentially problematic features is locking. But, it’s not the locks themselves – it’s the way that data is handled. Locks are a necessary evil to ensure that data is consistent, accurate, and appropriately isolated from other users. But, did you realize that your statement’s accuracy is tied to your session’s isolation level? Did you realize that while “read committed” sounds like a perfectly reasonable isolation level in which to execute, it results in phenomena known as inconsistent analysis? Yes, you are only reading committed data – but at what point in time?
What does this all mean? What affects isolation? What affects your transactions? How do you control it? How and why might you want to change your isolation level?
Ultimately, being able to answer all of these questions will not only result in a better understanding of how the system works but also results in a more effective use of both the system and the data. Understanding your options will also allow you to increase statement accuracy, giving you a definable point in time to which a statement reconciles – even allowing you to do real-time analysis in an OLTP system without blocking.
Simply put, this is a course that every developer should attend so that they have a better grasp of what their batches, transactions, and code (in general) are doing as well as how their queries are affecting and affected by locks. For administrators, this course will give you a much better understanding of what’s going on, how to troubleshoot, and how to work with developers to create a system with more accurate data and less blocking!
This class is delivered live, online via streaming. By dedicating only 3 half-days of your time for 9 hours of lecture and up to 4.5 hours of open Q&A, this is an amazing ROI while you can still get work done during your day!
Instructor: Kimberly L. Tripp.
For a detailed agenda click HERE.
If you need help justifying training to your organization, we can help you:
Click HERE to go to our events registration page, and please make sure to select the correct class from the drop-down menu at the top of the page.
If you have any questions, please contact us.