Transaction, Isolation Levels and In-Memory OLTP in T-SQL
4.7 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
63 students enrolled

Transaction, Isolation Levels and In-Memory OLTP in T-SQL

Microsoft SQL Server Transact SQL Advanced Query and Developer Course, helpful in Microsoft Certification Exam 70-762
4.7 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
63 students enrolled
Created by Vikas Munjal
Last updated 2/2020
English
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 6 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Transactions & Deadlocks
  • Concurrency Problems
  • Isolation Levels
  • In-Memory OLTP
Course content
Expand all 33 lectures 04:05:43
+ Introduction
3 lectures 19:28
Demonstration Scripts
00:02
Practical Example of Implementing a Transaction
16:53
+ Concurrency Problems
5 lectures 26:10
Demonstration Scripts till Section 3
00:05
Non Repeatable Read Problem
04:26
Phantom Read Problem
02:47
Lost Update Problem
07:28
+ Isolation Levels and Solutions
8 lectures 56:34
Read Uncommitted Isolation Level
06:11
Read Committed Isolation Level
04:00
Repeatable Read Isolation Level
07:10
Serializable Isolation Level
08:05
Scenario where Repeatable Read or Serilizable or Snashot can be used
01:13
Snapshot Isolation Level Part 1
10:29
Snapshot Isolation Level Part 2
11:26
Read Committed Snapshot Isolation Level
08:00
+ More on Locking and Transactions
5 lectures 30:11
Demonstration Scripts
00:02
Auto Commit , Implicit and Explicit Transaction
05:55
Deadlock
06:47
Lock Modes
12:21
Pessimistic v/s Optimistic Concurrency Control
05:06
+ In-Memory OLTP
7 lectures 01:26:25
Demonstration Scripts
00:02
What are Inmemory Tables
08:23
Advantages of In-memory Table
26:00
Creating Inmemory Table and Testing its performance
18:04
Inmemory Table Indexes
10:18
Native Compiled Stored Procedure
11:21
Migration from Existing Disk Based Tables to Inmemory Table
12:17
+ In-Memory OLTP Isolation Levels
5 lectures 26:53
Demonstration Scripts
00:02
In-Memory OLTP Snapshot Isolation Level
14:51
In-Memory OLTP Repeatable Read Isolation Level
05:23
In-Memory OLTP Serializable Isolation Level
04:35
Bonus Lecture
02:01
Requirements
  • This course is not for beginners.
  • Beginner Level of T-SQL knowledge is must
Description

This  online video training course includes topics related to Transactions , Concurrency Problems , their solutions using Transaction Isolation Levels . Another major portion of the course consists of In-Memory OLTP in T-SQL .

The details topics are


Transactions


Auto Commit  Transactions

Implicit  Transactions

Explicit Transactions

Deadlock

Lock Modes


Concurrency Problems


Dirty Read Problem

Non Repeatable Read Problem

Phantom Read Problem

Lost Update Problem


Isolation Levels and Solutions


Read Uncommitted Isolation Level

Read Committed Isolation Level

Repeatable Read Isolation Level

Serializable Isolation Level

Scenario where Repeatable Read or Serializable or Snapshot can be used

Snapshot Isolation Level

Read Committed Snapshot Isolation Level


In-Memory OLTP


What are In-memory Tables

Scenarios of In-memory Table

Creating In-memory Table and Testing its performance

In-memory Table Indexes

Native Compiled Stored Procedure

Migration from Existing Disk Based Tables to In-memory Table


In-Memory OLTP Isolation Levels


In-Memory OLTP Snapshot Isolation Level

In-Memory OLTP Repeatable Read Isolation Level

In-Memory OLTP Serializable Isolation Level

Who this course is for:
  • Helpful in handling concurrency scenarios related to Transactions
  • In-Memory OLTP can increase performance in ETL, Session Management
  • Also helpful in Handling Millions of Concurrent Transaction , Sensor Data
  • Helpful in Interviews and 70-762 Exam