|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-2019-administration-sql-server-part-2/
课程评论：没有评论
Coursera 课程《SQL Server 2019：Administration SQL Server Part 2》内容精炼 本课程将 Udemy 平台上的两门课程融为一体，重点关注 SQL Server 的数据库管理和优化。 **第一部分：索引优化** 本部分旨在解决 SQL Server 性能缓慢的问题，并深入剖析索引的配置与修改。课程将重点讲解： * **索引基础：** 详细解释聚集索引和非聚集索引的结构、Table SCAN 与 Table SEEK 的区别。 * **高级索引策略：** 涵盖覆盖索引、避免过度索引 (Over-indexing)、移除重复索引、单列索引的定义。 * **索引维护：** 讲解合并索引、列存储索引、过滤索引的注意事项及其缓存计划，以及 SARGABLE 的概念。 * **聚集索引选择：** 教授如何选择正确的聚集索引。 * **碎片化管理：** 强调碎片化的重要性，并教授如何去除碎片。 * **页分裂与 FILLFACTOR：** 讲解页分裂的追踪和 FILLFACTOR 的定义。 * **索引重建选项：** 对比 Rebuild Index 和 Reorganize，并介绍 ABORT_AFTER_WAIT 选项。 **第二部分：数据库配置与修改** 本部分将深入探讨 SQL Server 数据库的创建、配置和修改，帮助您避免潜在的陷阱： * **数据库创建与配置：** 演示如何通过附加文件创建数据库，以及数据库的各项配置选项。 * **性能调优关键：** 重点讲解 MAXDOP (最大并行度) 的设置。 * **实用工具详解：** 介绍 Query Store 的功能与激活，以及 Broker 服务的用途与激活。 * **其他重要设置：** 探讨更改数据库所有者产生的影响，以及 TARGET RECOVERY TIME 的概念。 **为何学习 SQL 管理？** SQL 技能在当今就业市场需求旺盛。SQL Server 因其易用性，能帮助您快速掌握特定领域的技能。无论您是技术主管、开发人员、未来 DBA，还是其他与 SQL 相关的职业，本课程都将为您提供宝贵的知识。课程视频时长控制在 10 分钟内，以保证学习的趣味性。 本课程时长约 2.5 小时，旨在帮助您成为一名更优秀的 SQL Server 管理员。
This course brings together two of my courses on the Udemy platform which are:SQL server: Configuring and modifying a database on SQL ServerSQL server: The complete course on Indexes (4 h of class) The first chapter will talk about the index: You have problems of slowness on your SQL servers, and you suspect the implementation of your indexes? You haven't set up indexes on your tables, because you don't know the differences between a clustered and a non-clustered index? In this first chapter, come and discover the importance of a good index setup on your tables, don't go on a spending spree buying disk storage, when it may be the index setup that is wrong! It's simple, indexes are the first reason, of your performance improvements on a SQL server.The training in detail:The structure of a clustered and a non-clustered index.The Table SCAN and the Table SEEK The covering index and Why you should not index the whole table (Over indexing).Remove duplicate indexes, and see the definition of a SINGLE index.Remember to consolidate indexes, and the columnstore index.Beware of filtered indexes and their associated cache plan, and see what is the term SARGABLE?How to choose the right Clustered Index Why fragmentation is important, and how to remove itTracking page splits and the FILLFACTOR definitionRebuild Index Vs REORGANIZE and the ABORT_AFTER_WAIT optionThe second chapter will talk about the configuration and modification on your database: Do you know that a bad choice of your AUTOGROW of your DB, can lower your performance on your server? And yes it's not a myth:)In this course we will see that it is possible to enable a myriad of options, when creating a DB on SQL server.This course aims firstly, to make you discover these options, and then to help you avoid the pitfalls when activating certain options.So why watch this chapter ?Changing the parallelism (MAXDOP) of a DBCreating, configuring and modifying a DB (Creating a DB by attaching a file etc...)Learn the utility and activation of the Query StoreLearn the use and activation of the BROKER service The impact of changing the owner of a DBWhat is TARGET RECOVERY Time? And many other modules in this 2.5 hour course.Why get into SQL administration?SQL is one of the most actively sought after skills in the job market.Administering SQL Server today is a full-time job.In addition, SQL Server, by its simplicity, allows you to quickly gain skills on specific subjects. If you are a Tech Lead, a developer, a future DBA, or any other profession that will tackle SQL, then this course is for you:) I also made sure that the videos were no longer than 10 minutes, so that it wouldn't be too boring:)Look at the average of my other courses (4,4/5), and you will see that my courses are quality courses:)
