Transaction, Isolation Levels and In-Memory OLTP in T-SQL
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Microsoft SQL Server Transact SQL Advanced Query and Developer Course, helpful in Microsoft Certification Exam 70-762Description
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
Requirements
- Requirements
- This course is not for beginners.
- Beginner Level of T-SQL knowledge is must
Vikas Munjal
4.5 Raiting
Transaction, Isolation Levels and In-Memory OLTP in T-SQL
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Microsoft SQL Server Transact SQL Advanced Query and Developer Course, helpful in Microsoft Certification Exam 70-762 Another major portion of the course consists of In-Memory OLTP in T-SQL ....
