• Length:
    4 Weeks
  • Effort:
    2–3 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $99 USD

  • Institution
  • Subject:
  • Level:
    Intermediate
  • Language:
    English
  • Video Transcript:
    English

Prerequisites

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

About this course

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

What you'll learn

  • 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
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.

Meet your instructors

Geoff Allix
Microsoft Certified IT Professional for SQL Server
Content Master
Chris Randall
Senior Content Developer, Microsoft Learning Experiences
Microsoft

Pursue a Verified Certificate to highlight the knowledge and skills you gain $99.00

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    EdX, a non-profit, relies on verified certificates to help fund free education for everyone globally