Repeatable Read and Serializable Isolation Levels

Rated 5.00 out of 5 based on 1 customer rating
(1 customer review)

$49.00 for 2 years

Learn why read committed is not enough, and the tradeoffs you make if you choose serializable or repeatable read with disk based tables.

Out of stock

Description

Serializable and Repeatable Read isolation levels offer protections so your users won’t see weird or incorrect data — but there are tradeoffs for those protections. Learn how to tell if your existing applications are using these types of isolation levels, when you might want to raise your isolation level in SQL Server, and the tradeoffs you make if you choose serializable or repeatable read with disk-based tables.

This course includes 47 minutes of videos, plus a quiz:

  • Why do we have repeatable read and serializable? (10 minutes)
  • Course downloads: scripts and slides (PDF)
  • Demo: Give me correct data or give me death (15 minutes)
  • Animated play diagram of the index intersection problem (6 minutes)
  • How you can get serializable isolation, even if you didn’t ask for it (4 minutes)
  • How to tell if apps are using repeatable read or serializable (5 minutes)
  • What’s the best way to get correct data? (7 minutes)
  • Course quiz (10 questions)
  • Course survey (optional)

1 review for Repeatable Read and Serializable Isolation Levels

  1. Rated 5 out of 5

    Gisela Nagy (verified owner)

    I learned a lot here, especially that you can have non-repeatable reads within one single select statement!
    The course is splitted in 6 short videos (between 5 and 15 min), so there is no excuse of not having time to watch it, perfect for me 😉 Also the quiz at the end helps a lot to check if you understood everything well.
    Thanks Kendra!

Add a review

Your email address will not be published. Required fields are marked *

You may also like…