|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/transaction-isolation-levels-in-memory-oltp-t-sql/
课程评论：没有评论
**课程名称：** T-SQL 中的事务、隔离级别与内存 OLTP **课程概述：** 本课程是一门在线视频培训课程，内容涵盖了 T-SQL 中的事务、并发问题及其通过事务隔离级别解决的方案。此外，课程还将重点介绍内存 OLTP（In-Memory OLTP）在 T-SQL 中的应用。 **主要学习内容：** * **事务 (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) * 可重复读、串行化或快照的适用场景 * 快照隔离级别 (Snapshot Isolation Level) * 读已提交快照隔离级别 (Read Committed Snapshot Isolation Level) * **内存 OLTP (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) * 内存 OLTP 隔离级别 (In-Memory OLTP Isolation Levels) * 内存 OLTP 快照隔离级别 * 内存 OLTP 可重复读隔离级别 * 内存 OLTP 串行化隔离级别 **课程目标：** 通过本课程的学习，学员将能够深入理解 T-SQL 事务的原理、掌握解决并发问题的各种隔离级别，并学会如何利用内存 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 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
