Administering Microsoft SQL Server Databases Course



Course Details:

Length: 5 days

Price: $2,985/person (USD)

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Digital Badge

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included?: Yes

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location

Onsite for Teams

Group Teams
@ Your Organization

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.

 

Course Overview

You have created databases and executed queries on them. You are now ready to perform database administration tasks such as installation of SQL Server instances, configuration of SQL Server databases and settings, monitoring database performance, controlling user access to databases, and database maintenance. In addition to these tasks, SQL Server provides many advanced features that enable you to manage databases efficiently. By familiarizing yourself with these tasks and features, you can plan, deploy, administer, and maintain SQL Server databases efficiently. In this course, you will perform database administration tasks.


Register Early: Registration Deadline is 2 Weeks Prior to Class Start.


Learning Objectives

Upon successful completion of this course, students will be able to administer SQL Server databases.
You will:

  • Identify the SQL Server Platform and Tools
  • Deploy SQL Server
  • Configure SQL Server
  • Manage Databases
  • Implement Advanced Security Settings
  • Apply Encryption and Compression
  • Work with Indexes and Log Files
  • Work with Backup and Restore
  • Implement High Availability
  • Optimize Server Performance
  • Troubleshoot Issues and Recover Databases
  • Perform Advanced Management Tasks

Course Notes

Course Taught With: 2012 software
SQL Server Versions That Can Attend: 2022, 2019, 2016, 2014, and 2012


Target Audience

This course is designed for Database Administrators who administer and maintain SQL Server databases. This course will be attended by database professionals who are familiar with SQL Server databases and who are responsible for administering and maintaining SQL Server databases as their primary job responsibility. In addition, this course can be attended by individuals who develop applications that access SQL Server database.

 

Course Topics

Lesson 1: Identifying the SQL Server Platform and Tools
Topic A: Overview of SQL Server Features
Topic B: Create Filegroups and Partitions

 

Lesson 2: Deploying SQL Server
Topic A: Install SQL Server
Topic B: Migrate SQL Server From a Previous Version

 

Lesson 3: Configuring SQL Server
Topic A: Configure Server Properties
Topic B: Configure Memory and CPU
Topic C: Configure Database Mail

 

Lesson 4: Managing Databases in SQL Server
Topic A: Create a Contained Database
Topic B: Configure Database Options

 

Lesson 5: Managing SQL Server Security
Topic A: Configure Server Security
Topic B: Create Server Roles
Topic C: Configure Database Security

 

Lesson 6: Implementing Advanced Security Settings
Topic A: Create Certificate-Based Logins
Topic B: Apply Auditing and Policy-Based Management Strategies

 

Lesson 7: Applying Encryption and Compression
Topic A: Apply Encryption on Databases
Topic B: Compress a Database Table

 

Lesson 8: Working with Indexes and Log Files
Topic A: Work with Full Text Indexes
Topic B: Configure Advanced Storage and Indexing Settings
Topic C: Configure Log Files

 

Lesson 9: Working with Backup and Restore
Topic A: Perform a Backup
Topic B: Restore a Database
Topic C: Import and Export Data
Topic D: Configure the SQL Server Agent

 

Lesson 10: Implementing High Availability
Topic A: Work with Clustering
Topic B: Work with Replication
Topic C: Work with Mirroring and AlwaysOn
Topic D: Work with Central Management Servers

 

Lesson 11: Optimizing Server Performance
Topic A: Manage Server Performance
Topic B: Optimize Indexes

 

Lesson 12: Troubleshooting Issues and Recovering Databases
Topic A: Troubleshoot Database Issues
Topic B: Perform a Database Recovery

 

Lesson 13: Performing Advanced Database Management Tasks
Topic A: Manage Database Infrastructure
Topic B: Configure SSIS


Course FAQs

This course is taught by a live instructor and is available in two class formats:

  1. Live Online for Individuals
  2. Onsite/Online for Private Groups







Related Microsoft SQL Server Information:

Public instructor-led Microsoft SQL Server course prices start at $2,985 per student. Group training discounts are available.

Self-Paced Microsoft SQL Server eLearning courses cost $600 at the starting point per student. Group purchase discounts are available.







Registration:

Have a Group?
Request Private Training

4/28/2025 10:00:00 AM
Online Class

Registration Deadline - 04/13/2025

 

8/4/2025 10:00:00 AM
Online Class

Registration Deadline - 07/20/2025

 

11/3/2025 10:00:00 AM
Online Class

Registration Deadline - 10/19/2025

Start your training today!