|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-internals-and-architecture-overview/
课程评论：没有评论
课程名称：SQL Server 内部结构与架构概述 课程概述：SQL Server 是一个庞大而复杂的产品，它的 DBCC 命令可能包含超过十万行代码。在学习了基础知识，比如创建表、插入数据和备份数据库之后，许多数据库开发者或 DBA 日常的工作往往并不涉及内部结构。就像我驾驶了30年汽车却不懂发动机的部件。如果你想真正了解 SQL Server 的运作方式，就必须研究 SQL Server 两个核心引擎如何相互作用。存储引擎负责存储数据，而优化器处理查询。本课程将为你提供扎实的存储内部知识基础，涵盖数据在非常底层是如何存储的。你将学习与页面相关的专业术语以及一些新的命令，从而深入了解 SQL Server 如何存储数据。我们将讨论数据行结构和事务日志，课程结束时你将理解 SQL Server 中数据是如何移动的。这些知识将帮助你在许多 DBA 尚未掌握的层面上进行 SQL Server 的故障排除。我们还将通过示例和代码语法来确定哪些有效、哪些无效。任何关系数据库都是对象的集合，其中表是最基本的对象。然而，它们是什么以及它们的作用是两回事。关系数据库中有称为事务的实体，用以传输和操作数据。本课程将重点关注这些事务是如何以及在移动什么。感谢你对 SQL Server 内部结构的兴趣，我们课程中见！
SQL Server is a massive, complex product. One DBCC command can have over one hundred thousand lines of code.Once you've learned the basics… creating tables, inserting data, backing up databases… then what? The daily routine of a database developer or DBA often doesn't involve internal structures. I've been driving for 30 years but don't know the parts to my car's engine. Well, I'm not mechanic either. If you want to understand how SQL Server really operates then you have to undertake a study of how the two core engines of SQL Server work with one another. The storage engine stores data and the optimizer processes queries. This course will provide you with a solid foundation in storage internals. We are going to cover how data is stored at a very low level. You'll learn the vernacular specific to the page and several new commands that will provide us with some deep insight into what any how SQL Server stores data. We will cover the data row structure and the transaction log and by the end of this course you'll understand how data moves in SQL Server. This knowledge will help you troubleshoot SQL Server at a level most DBAs simply don't grasp. We will look at examples and code syntax to determine what works and what doesn't. Any relational database is a collection of objects, the table being the most fundamental. However, what they are and what they do are two different things. Relational databases have entities called transactions that transfer and manipulate data. This course will focus on how and what these transactions are moving. Thanks for you interest in SQL Server Internals.I'll see you in the course!!!
