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

Free Download Transaction, Isolation Levels and In-Memory OLTP in T-SQL
Last updated 2/2020
Created by Vikas Munjal
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 33 Lectures ( 4h 5m ) | Size: 1.26 GB

Microsoft SQL Server Transact SQL Advanced Query and Developer Course, helpful in Microsoft Certification Exam 70-762
What you’ll learn
Transactions & Deadlocks
Concurrency Problems
Isolation Levels
In-Memory OLTP
Requirements
This course is not for beginners.
Beginner Level of T-SQL knowledge is must
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 TransactionsAuto Commit Transactions Implicit TransactionsExplicit TransactionsDeadlockLock ModesConcurrency ProblemsDirty Read ProblemNon Repeatable Read ProblemPhantom Read ProblemLost Update ProblemIsolation Levels and SolutionsRead Uncommitted Isolation LevelRead Committed Isolation LevelRepeatable Read Isolation LevelSerializable Isolation LevelScenario where Repeatable Read or Serializable or Snapshot can be usedSnapshot Isolation LevelRead Committed Snapshot Isolation LevelIn-Memory OLTPWhat are In-memory TablesScenarios of In-memory TableCreating In-memory Table and Testing its performanceIn-memory Table IndexesNative Compiled Stored ProcedureMigration from Existing Disk Based Tables to In-memory TableIn-Memory OLTP Isolation LevelsIn-Memory OLTP Snapshot Isolation LevelIn-Memory OLTP Repeatable Read Isolation LevelIn-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
Homepage

https://www.udemy.com/course/transaction-isolation-levels-in-memory-oltp-t-sql/