学习SQL Server 2016管理核心技能，涵盖数据访问配置、备份恢复、性能监控与高可用性，助你备考MCSA 70-764认证考试。
原始标题：SQL Server 2016: Administer a Database Infrastructure
Updated: 03/2025
Duration: 5h 29m | .MP4 1280×720, 30 fps(r) | AAC, 48000 Hz, 2ch | 746 MB
Level: Intermediate | Genre: eLearning | Language: English
SQL Server comes with many features for monitoring, securing, optimizing, and supporting your database infrastructure. Learn how to use these features to administer your SQL Server instances, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam.
Adam Wilbert covers four main skill areas required of SQL Server 2016 administrators: configuring access to data, managing backups, monitoring performance, and implementing the high-availability features of the product. Learn about data encryption, access control, role-level security, and dynamic data masking. Use SQL Server auditing to gain insights into the health and performance of your system, and determine upgrade paths. Discover how to back up SQL Server and perform full or partial restores, and monitor activity. Explore indexing and query execution plan management. Plus, learn to configure availability groups to mitigate hardware failure.
此处内容需要权限查看
会员免费查看
