4.5  18 reviews on Udemy

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
Course from Udemy
 122 students enrolled
 en
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

Transaction, Isolation Levels and In-Memory OLTP in T-SQL
$ 49.99
per course
Also check at

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

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK