Transaction, Isolation Levels and In-Memory OLTP in T-SQL
this online video training course on Transactions, Concurrency Problems, Isolation Levels, and In-Memory OLTP. Learn how to handle concurrency scenarios, increase performance in ETL and session management, and handle millions of concurrent transactions. Perfect for interviews and the 70-762 exam.
What you’ll learn
- Transactions & Deadlocks
- Concurrency Problems
- Isolation Levels
- In-Memory OLTP
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
User Reviews
Be the first to review “Transaction, Isolation Levels and In-Memory OLTP in T-SQL”
You must be logged in to post a review.
There are no reviews yet.