YoVDO

Getting Started with SQL Server Maintenance

Offered By: Pluralsight

Tags

SQL Courses Relational Databases Courses Database Administration Courses Performance Reviews Courses

Course Description

Overview

This course is for new or accidental DBAs, and is designed to help you learn the basics of essential SQL Server Maintenance items. Items such as backups, index rebuilds, and performance reviews are covered, with some relevant demos.

SQL is one of the leading database platforms in the world. In this course, Getting Started with SQL Server Maintenance, you will gain the ability to properly maintain a SQL Server instance. First, you will learn critical daily items. Next, you will discover what needs to be done weekly. Finally, you will explore how to handle less time critical, but still important tasks. When you are finished with this course, you will have the skills and knowledge of maintaining a SQL Server needed to protect your firm's data.

Syllabus

  • Course Overview 1min
  • Introducing SQL Server Maintenance 13mins
  • Daily Maintenance 39mins
  • Weekly Maintenance 29mins
  • Monthly Maintenance 29mins
  • Periodic Maintenance 23mins
  • Automating Maintenance with Free Tools 32mins
  • Summary and Resources 8mins

Taught by

Kevin Hill

Related Courses

Database Administration and SQL Language Basics
A Cloud Guru
PostgreSQL Administration Deep Dive
A Cloud Guru
Administering an AlloyDB Database
Google via Google Cloud Skills Boost
Advanced Data Modeling
Meta via Coursera
Amazon Aurora MySQL - Migration (Korean)
Amazon Web Services via AWS Skill Builder