Simple play icon Course
Skills

Getting Started with SQL Server Maintenance

by Kevin Hill

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.

Preview this course

What you'll learn

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.

Table of contents

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

About the author

Kevin Hill

Kevin Hill is a career SQL Server DBA living in Dallas, TX. His specialties include HA/DR, Best Practice configuration, Performance tuning and teaching new and accidental DBAs

See more courses by Kevin Hill
Ready to upskill? Get started