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

Transaction, Isolation Levels and In-Memory OLTP in T-SQL, available at $54.99, has an average rating of 4.7, with 33 lectures, based on 44 reviews, and has 310 subscribers.

You will learn about Transactions & Deadlocks Concurrency Problems Isolation Levels In-Memory OLTP This course is ideal for individuals who are Helpful in handling concurrency scenarios related to Transactions or In-Memory OLTP can increase performance in ETL, Session Management or Also helpful in Handling Millions of Concurrent Transaction , Sensor Data or Helpful in Interviews and 70-762 Exam It is particularly useful for Helpful in handling concurrency scenarios related to Transactions or In-Memory OLTP can increase performance in ETL, Session Management or Also helpful in Handling Millions of Concurrent Transaction , Sensor Data or Helpful in Interviews and 70-762 Exam.

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

Summary

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

Price: $54.99

Average Rating: 4.7

Number of Lectures: 33

Number of Published Lectures: 33

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 33

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Transactions & Deadlocks

Concurrency Problems

Isolation Levels

In-Memory OLTP

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: What is Transaction

Lecture 2: Demonstration Scripts

Lecture 3: Practical Example of Implementing a Transaction

Chapter 2: Concurrency Problems

Lecture 1: Demonstration Scripts till Section 3

Lecture 2: Dirty Read Problem

Lecture 3: Non Repeatable Read Problem

Lecture 4: Phantom Read Problem

Lecture 5: Lost Update Problem

Chapter 3: Isolation Levels and Solutions

Lecture 1: Read Uncommitted Isolation Level

Lecture 2: Read Committed Isolation Level

Lecture 3: Repeatable Read Isolation Level

Lecture 4: Serializable Isolation Level

Lecture 5: Scenario where Repeatable Read or Serilizable or Snashot can be used

Lecture 6: Snapshot Isolation Level Part 1

Lecture 7: Snapshot Isolation Level Part 2

Lecture 8: Read Committed Snapshot Isolation Level

Chapter 4: More on Locking and Transactions

Lecture 1: Demonstration Scripts

Lecture 2: Auto Commit , Implicit and Explicit Transaction

Lecture 3: Deadlock

Lecture 4: Lock Modes

Lecture 5: Pessimistic v/s Optimistic Concurrency Control

Chapter 5: In-Memory OLTP

Lecture 1: Demonstration Scripts

Lecture 2: What are Inmemory Tables

Lecture 3: Advantages of In-memory Table

Lecture 4: Creating Inmemory Table and Testing its performance

Lecture 5: Inmemory Table Indexes

Lecture 6: Native Compiled Stored Procedure

Lecture 7: Migration from Existing Disk Based Tables to Inmemory Table

Chapter 6: In-Memory OLTP Isolation Levels

Lecture 1: Demonstration Scripts

Lecture 2: In-Memory OLTP Snapshot Isolation Level

Lecture 3: In-Memory OLTP Repeatable Read Isolation Level

Lecture 4: In-Memory OLTP Serializable Isolation Level

Lecture 5: Bonus Lecture

Instructors

Vikas Munjal
SQL Server | MSBI Microsoft Certified Trainer & Consultant

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!