|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-sql-server-transaction-log-analysis/
课程评论：没有评论
**课程名称：** SQL Server 事务日志的高级分析 **课程概述：** 本课程将带你深入了解 SQL Server 事务日志的分析。事务日志记录了数据库中每一项被修改操作的历史。在数据被写入磁盘之前，事务的副本或记录会首先写入事务日志。这是 ACID 属性中“D”（持久性）的一部分。持久性保证已提交的事务能够永久保存。 课程将重点讲解： * SQL Server 的预写日志 (WAL) 工作原理：即在数据修改写入磁盘之前，相关的日志记录会先被写入磁盘。 * SQL Server 的内部架构如何实现这一过程。 * 尽管存在非日志操作的说法，但所有修改 SQL Server 内部对象的用户事务实际上都会被记录。 * 通过实际演示，让你掌握分析事务日志内容的方法。 **学员评价亮点：** * 内容清晰，使用先进的技术来演示关键点。 * 涵盖了 SQL Server 的多个方面，而不仅仅是 SQL 语法。 * 提供切实的案例演示。 * 简洁的介绍，适合快速了解事务日志的功能和探索其内容。 * 优秀的内幕知识和快速学成。 * 简单的易于理解的解释。 * 非常好的取证程序。 * 富有代表性的示例。 * 对 SQL Server 事务日志分析的学习非常有帮助。 * 简洁地回顾了基础 SQL 概念以及当前和文件级别的日志分析。
COURSE REVIEWS:Thanks Mike. Absolutely fantastic. Learnt so much. Clearly presented with excellent use of technology to demonstrate the key points. It covered many aspects of SQL Server not just SQL syntax and gave practical demonstrations of every subject covered. Brilliant. - Mr Dave Morgan"A very succinct introduction to the SQL Server transaction log. A must for anyone wishing to understand the function of the transaction log and learn how to explore its contents within the space of an hour or two." - Stylianos"Great" - Richard "The explanation was very simple and easy to understand." - Mansoor"Very good forensic procedures." - Thomas"Thanks very much, nice course" - Stanislaw"Great explanation and very representative examples." - Roman "I am learning a lot about SQL Server Transaction Log Analysis." - Debora"Concise review of basic SQL premises along with log analysis at current and file levels. Good course." - Mike H"Excellent material and quick to the point!" - Nick Y. COURSE INTRODUCTION: Welcome to Advanced SQL Server Transaction Log Analysis. In this course, we are going to take a deep dive into analyzing the transaction log. The SQL Server transaction log contains the history of every action that modified anything in the database. Before data is written or saved on disk a copy or record of that transaction is first written to the transaction log. This is part of the D in the ACID properties. Recall that D stands for durability and durability is the ACID property which guarantees that transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes. This process in SQL Server is accomplished by WAL or Write Ahead Logging. SQL Server uses a write-ahead log (WAL), which guarantees that no data modifications are written to disk before the associated log record is written to disk. No matter what you've read about non-logged operations the truth is that every user transactions that modifies an internal SQL Server object is logged. In the course we will learn how WAL works for SQL Srever and some internal architecture on how this is accomplished. Thanks for your interest in Advanced SQL Server Transaction Log Analysis and we will see you in the course.
