Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Managing SQL Server Operations

Microsoft via edX

This course may be unavailable.

Overview

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

Syllabus

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.

Taught by

Chris Randall and Geoff Allix

Reviews

Start your review of Managing SQL Server Operations

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.