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
Ratings 4.78 / 5.00
What You Will Learn!
- Transactions & Deadlocks
- Concurrency Problems
- Isolation Levels
- In-Memory OLTP
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 Should Attend!
- 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
