This course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks. This course covers content that was in retired Microsoft Course 20764: Administering a SQL Database Infrastructure.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

After completing this course, you will be able to:
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Use encryption and auditing features to protect data
Describe recovery models and backup strategies
Backup and Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data

1

  • MODULE 1: SQL SERVER SECURITY

  • Authenticating Connections to SQL Server

    Authorizing Logins to Connect to databases

    Authorization Across Servers

    Partially Contained Databases

2

  • MODULE 2: ASSIGNING SERVER AND DATABASE ROLES

  • Lesson 1: Working with Server Roles

    Lesson 2: Working with Fixed Database Roles

    Lesson 3: User-Defined Database Roles

3

  • MODULE 3: AUTHORIZING USERS TO ACCESS RESOURCES

  • Authorizing User Access to Objects

    Authorizing Users to Execute Code

    Configuring Permissions at the Schema Level

4

  • MODULE 4: PROTECTING DATA WITH ENCRYPTION AND AUDITING

  • Options for auditing data access in SQL Server

    Implementing SQL Server Audit

    Managing SQL Server Audit

    Protecting Data with Encryption

5

  • MODULE 5: RECOVERY MODELS AND BACKUP STRATEGIES

  • Understanding Backup Strategies

    SQL Server Transaction Logs

    Planning Backup Strategies

6

  • MODULE 6: BACKING UP SQL SERVER DATABASES

  • Backing Up Databases and Transaction Logs

    Managing Database Backups

    Advanced Database Options

7

  • MODULE 7: RESTORING SQL SERVER DATABASES

  • Understanding the Restore Process

    Restoring Databases

    Advanced Restore Scenarios

    Point-in-Time Recovery

8

  • MODULE 8: AUTOMATING SQL SERVER MANAGEMENT

  • Automating SQL Server management

    Working with SQL Server Agent

    Managing SQL Server Agent Jobs

    Multi-server Management

9

  • MODULE 9: CONFIGURING SECURITY FOR SQL SERVER AGENT

  • Understanding SQL Server Agent Security

    Configuring Credentials

    Configuring Proxy Accounts

10

  • MODULE 10: MONITORING SQL SERVER WITH ALERTS AND NOTIFICATIONS

  • Monitoring SQL Server Errors

    Configuring Database Mail

    Operators, Alerts, and Notifications

    Alerts in Azure SQL Database

11

  • MODULE 11: INTRODUCTION TO MANAGING SQL SERVER BY USING POWERSHELL

  • Getting Started with Windows PowerShell

    Configure SQL Server using PowerShell

    Administer and Maintain SQL Server with PowerShell

    Managing Azure SQL Databases using PowerShell

12

  • MODULE 12: TRACING ACCESS TO SQL SERVER WITH EXTENDED EVENTS

  • Extended Events Core Concepts

    Working with Extended Events

13

  • MODULE 13: MONITORING SQL SERVER

  • Monitoring activity

    Capturing and Managing Performance Data

    Analyzing Collected Performance Data

14

  • MODULE 14: TROUBLESHOOTING SQL SERVER

  • Applying a Troubleshooting Methodology

    Resolving Service-Related Issues

    Resolving Connectivity and Login issues

15

  • MODULE 15: IMPORTING AND EXPORTING DATA

  • Transferring Data to and from SQL Server

    Importing and Exporting Table Data

    Using bcp and BULK INSERT to Import Data

    Deploying Data-Tier Applications

Audience

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Language

English

Prerequisites

Experience using applications on Windows Servers Experience working with SQL Server or another RDMS

$3,275

Length: 5.0 days (40 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
09
Oct
Monday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
13
Nov
Monday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
22
Jan
Monday
9:00 AM ET -
5:00 PM ET
Available
Schedule select
11
Mar
Monday
8:00 AM PT -
4:00 PM PT
Available
Schedule select
06
May
Monday
9:00 AM ET -
5:00 PM ET
Available
Loading...