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

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

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 1 votes
• 3 stars: 1 votes
• 4 stars: 16 votes
• 5 stars: 26 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!