Provisioning and Administering a SQL Server Database

Master the skills to efficiently provision and administer SQL Server databases, ideal for IT professionals responsible for database management and maintenance in on-premise environments.

Course Thumbnail

Essential Skills Gained

Checkmark

Design a robust SQL Server database infrastructure

Checkmark

Implement effective backup and recovery strategies

Checkmark

Configure security settings for database protection

Checkmark

Monitor and optimize SQL Server performance

Format

  • Instructor-led
  • 5 days with lectures and hands-on labs.

Audience

  • SQL Server Database Administrators
  • IT Professionals in Database Management
  • Application Developers using SQL Server
  • Database Maintenance Technicians

Description

This 5-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to provision and administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. This course combines the material from Microsoft’s 20764 and 20765 courses, but focus the topics around implementing SQL Server in an on-premise configuration. Even though the class uses SQL Server 2016, the concepts and topics apply to SQL Server 2008 through 2014.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: SQL Server Components

  1. Introduction to the SQL Server Platform

  2. Overview of SQL Server Architecture

  3. SQL Server Services and Configuration Options

Module 2: Installing SQL Server

  1. Considerations for installing SQL Server

  2. TempDB Files

  3. Installing SQL Server 2016

  4. Automating Installation

Module 3: Working with Databases

  1. Overview of SQL Server Databases

  2. Creating Databases

  3. Database Files and Filegroups

  4. Moving Database Files

  5. Buffer Pool Extension

Module 4: Recovery Models and Backup Strategies

  1. Understanding Backup Strategies

  2. SQL Server Transaction Logs

  3. Planning Backup Strategies

Module 5: Backing Up SQL Server Databases

  1. Backing Up Databases and Transaction Logs

  2. Managing Database Backups

  3. Advanced Database Options

Module 6: Restoring SQL Server Databases

  1. Understanding the Restore Process

  2. Restoring Databases

  3. Advanced Restore Scenarios

  4. Point-in-Time Recovery

Module 7: Performing Database Maintenance

  1. Ensuring Database Integrity

  2. Maintaining Indexes

  3. Automating Routine Database Maintenance

Module 8: Authenticating and Authorizing Users

  1. Authenticating Connections to SQL Server

  2. Authorizing Logins to Connect to databases

  3. Authorization Across Servers

  4. Partially Contained Databases

Module 9: Assigning Server and Database Roles

  1. Working with server roles

  2. Working with Fixed Database Roles

  3. Assigning User-Defined Database Roles

Module 10: Authorizing Users to Access Resources

  1. Authorizing User Access to Objects

  2. Authorizing Users to Execute Code

  3. Configuring Permissions at the Schema Level

Module 11: Automating SQL Server Management

  1. Automating SQL Server management

  2. Working with SQL Server Agent

  3. Managing SQL Server Agent Jobs

  4. Multi-server Management

Module 12: Configuring Security for SQL Server Agent

  1. Understanding SQL Server Agent Security

  2. Configuring Credentials

  3. Configuring Proxy Accounts

Module 13: Monitoring SQL Server with Alerts and Notifications

  1. Monitoring SQL Server Errors

  2. Configuring Database Mail

  3. Operators, Alerts, and Notifications

Module 14: Tracing Access to SQL Server with Extended events

  1. Extended Events Core Concepts

  2. Working with Extended Events

Module 15: Monitoring SQL Server

  1. Monitoring activity

  2. Capturing and Managing Performance Data

  3. Analyzing Collected Performance Data

  4. SQL Server Utility

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.