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

Advanced Features with Relational Database Tables Using SQLiteStudio
Coursera Project Network via Coursera
Advanced Relational Database and SQL
Coursera Project Network via Coursera
Advanced SQL
Kaggle
Advanced SQL Retrieval Queries in SQLiteStudio
Coursera Project Network via Coursera
Aggregate Data with LibreOffice Base Queries
Coursera Project Network via Coursera