Managing SQL Server Database Concurrency

Focused View

Gerald Britton

1:44:58

18 View

01 - Course Overview

01 - Course Overview.mp4

02:15

02 - Introducing SQL Server Concurrency Control

02 - Introducing Concurrency.mp4

01:49

03 - Concurrency in Computing Systems.mp4

01:43

04 - Understanding ACID.mp4

01:19

05 - Getting the Tools Installed.mp4

03:14

06 - Upcoming Modules.mp4

01:06

03 - Understanding Transactions

07 - Introducing Transactions.mp4

01:27

08 - Understanding Roles and Responsibilities.mp4

01:36

09 - Demo- Autocommit.mp4

02:01

10 - Demo- Explicit Transactions.mp4

01:57

11 - Demo- Implicit Transactions.mp4

02:36

12 - Revisiting Autocommit, Explicit, and Implicit Transactions.mp4

04:04

13 - Introducing Savepoints.mp4

00:49

14 - Demo- Savepoints.mp4

01:44

15 - Module Summary.mp4

00:46

04 - Managing Basic Isolation Levels

16 - Introducing Isolation Levels.mp4

01:56

17 - Understanding Isolation Levels and Anomalies.mp4

01:48

18 - Demo- Read Uncommitted.mp4

04:25

19 - Demo- Read Committed.mp4

03:01

20 - Demo- Repeatable Read and Serializable.mp4

01:50

21 - Summary.mp4

00:49

05 - Implementing Snapshot Isolation Levels

22 - Introducing Snapshot Isolation and Row Versioning.mp4

02:15

23 - Demo- Running with Read Committed Snapshot Isolation.mp4

02:29

24 - Demo- Using Snapshot Isolation When Modifying Data.mp4

02:13

25 - Demo- Dynamic Management Views (DMVs).mp4

02:16

26 - Locking vs. Row Versioning.mp4

01:59

27 - Summarizing Snapshot Isolation.mp4

01:38

06 - Locking in the SQL Server Database Engine

28 - Introducing Locking.mp4

02:44

29 - Demo- Blocking in Action.mp4

02:52

30 - Demo- Understanding Lock Granularity and Hierarchy.mp4

02:07

31 - Reviewing SQL Server Locking Granularities.mp4

02:42

32 - Introducing Locking Modes.mp4

03:40

33 - Demo- Locking Modes in Action.mp4

01:08

34 - Introducing Lock Escalation.mp4

02:09

35 - Demo- Lock Escalation in Action.mp4

03:12

36 - Module Summary and Additional Resources.mp4

01:09

07 - Optimizing Concurrency and Locking Behavior

37 - Introducing Concurrency Optimization.mp4

02:57

38 - Demo- Understanding Locking and Blocking.mp4

01:12

39 - Common Lock Mode Compatibility.mp4

01:26

40 - Demo- Lock Incompatibility and the Consequences.mp4

02:46

41 - Introducing Deadlock Analysis Using SSMS.mp4

00:58

42 - Demo- Analyzing Deadlocks Using Extended Events.mp4

06:26

43 - Handling and Avoiding Deadlocks.mp4

01:32

44 - Controlling Deadlocks with DEADLOCK PRIORITY.mp4

01:10

45 - Demo- Frameworks for Avoiding and Handling Deadlocks.mp4

02:51

46 - Recapping Concurrency Optimization and Deadlock Handling.mp4

01:24

08 - Summary

47 - Course Summary.mp4

05:28

Description

This course will dig into topics such as deadlocks, isolation levels, and more when managing SQL Server Database.

What You'll Learn?

Are you sometimes unsure about what type of database transaction or what isolation level makes sense for your application? Have you ever run into blocking problems or the dreaded deadlock? In this course, Managing SQL Server Database Concurrency, you will learn foundational knowledge of how SQL Server maximises the shared use of a database system while safeguarding the integrity of the data under its care and quickly delivering results to all applications that use it. First, you will learn how transactions are used and the various levels of isolation available. Next, you will discover how SQL Server uses locking to enable concurrency without affecting data integrity. Finally, you will explore how to analyze concurrency-affecting queries, including those that deadlock, and some techniques you can use to keep to avoid such issues. When you are finished with this course, you will have the skills and knowledge of concurrency management needed to explain database behavior, debug and fix blocking and deadlocking queries, and design queries that can do their jobs efficiently while minimizing their effects on other work being done simultaneously.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Gerald Britton

Instructor's Courses

Gerald Britton is a Pluralsight author and expert on Python programming practices and Microsoft SQL Server development and administration. A multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater).

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.