SQL Server操作管理

Managing SQL Server Operations

Learn best practices for automating, monitoring, and maintaining SQL Server.

1256 次查看
微软
edX
  • 完成时间大约为 4
  • 中级
  • 英语
注:因开课平台的各种因素变化,以上开课日期仅供参考

你将学到什么

Managing SQL Server with the SQL Server Agent and PowerShell

Monitoring and troubleshooting SQL Server with built in utilities, system views and Extended Events

Maintaining SQL Server backups, updates, indexes, statistics, and integrity checks

课程概况

SQL Server database administrators know how important it is to automate routine administrative tasks and systems.

Learn best practices in this course, part of the SQL Server Database Administration series.

You’ll explore ways to monitor performance, errors, and events, and get helpful details on server maintenance and the tasks involved.

Plus, you’ll engage these topics on multiple platforms, including SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases.

This computer science course introduces features and technologies for managing database operations. Topics include: Automating SQL Server Management, Monitoring SQL Server, and SQL

课程大纲

Module 1: SQL Server Management
This module introduces the SQL Server Agent, which you will use to create and execute management jobs. You will also learn the role of PowerShell for managing SQL Server.

Module 2: SQL Server Monitoring and Troubleshooting
This module covers built-in tools to monitor and troubleshoot activities and errors in SQL Server. You will learn how to monitor SQL Server with powerful extended events.

Module 3: SQL Server Maintenance
This module covers verifying backups, updating SQL Server, managing statistics, indexes, and performing integrity checks.

预备知识

Familiarity with database concepts and basic SQL query syntax.
A willingness to learn actively and persevere when troubleshooting technical problems is essential.

千万首歌曲。全无广告干扰。
此外,您还能在所有设备上欣赏您的整个音乐资料库。免费畅听 3 个月,之后每月只需 ¥10.00。
Apple 广告
声明:MOOC中国十分重视知识产权问题,我们发布之课程均源自下列机构,版权均归其所有,本站仅作报道收录并尊重其著作权益。感谢他们对MOOC事业做出的贡献!
  • Coursera
  • edX
  • OpenLearning
  • FutureLearn
  • iversity
  • Udacity
  • NovoEd
  • Canvas
  • Open2Study
  • Google
  • ewant
  • FUN
  • IOC-Athlete-MOOC
  • World-Science-U
  • Codecademy
  • CourseSites
  • opencourseworld
  • ShareCourse
  • gacco
  • MiriadaX
  • JANUX
  • openhpi
  • Stanford-Open-Edx
  • 网易云课堂
  • 中国大学MOOC
  • 学堂在线
  • 顶你学堂
  • 华文慕课
  • 好大学在线CnMooc
  • (部分课程由Coursera、Udemy、Linkshare共同提供)

© 2008-2022 CMOOC.COM 慕课改变你,你改变世界