SQL Admin Essentials

Become familiar with SQL server administration by discovering the new features in SQL Server 2008-17 and the important capabilities across the SQL server data platform. 


No prior product knowledge needed. 

Course length: 2 days, Delivery: Online or In-class. 
Please call (475) 328-2227 with questions.

Upcoming Classes

Course Overview

1.    Authenticating and Authorizing Users 

  • Authenticating connections to SQL Server

  • Authorizing logins to access databases

  • Authorization across servers

  • Partially contained databases

2.    Assigning Server and Database Roles 

  • Working with server roles

  • Working with fixed database roles

  • Creating user-defined database roles

3.    Authorizing Users to Access Resources 

  • Authorizing user access to objects

  • Authorizing users to execute code

  • Configuring permissions at the schema level

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.    SQL Server Recovery Models 

  • Backup strategies

  • Understanding SQL Server transaction login

  • Planning a SQL Server backup strategy

6.    Backup of SQL Server Databases 

  • Backing up databases and transaction logs

  • Managing database backups

  • Working with backup options

7.    Restoring SQL Server Database

  • Understanding the restore process

  • Restoring databases

  • Working with point-in-time recovery

  • Restoring system databases and individual files

8.    Automating SQL Server Management 

  • Working with SQL Server agent

  • Managing SQL Server agent jobs

  • Multi-Server Management

 9.   Configuring Security for SQL Server Agent 

  • Understanding SQL Server Agent Security

  • Configuring credentials

  • Configuring proxy accounts

10.    Monitoring SQL Server with Alerts and Notifications 

  • Configuration of database mail

  • Monitoring SQL Server errors

  • Configuring operators, alerts, and notifications

  • Alerts in Azure SQL database

11.    Introduction to Managing SQL Server by using PowerShell 

  • Configure SQL Server using PowerShell

  • Administer SQL Server using PowerShell

  • Maintain the SQL Server environment using PowerShell

  • Managing Azure SQL Server databases using PowerShell

12.    Tracing Access to SQL Server 

  • Capturing activity using SQL Server profiler

  • Improving performance with the database engine tuning advisor

  • Working with tracing options

  • Distributed replay

  • Monitoring locks

13.    Monitoring SQL Server 

  • Monitoring activity

  • Capturing and managing performance data

  • Analyzing collected performance data

14.    Troubleshooting SQL Server 

  • SQL Server troubleshooting methodology

  • Resolving service related issues

  • Resolving login and connectivity issues

  • Troubleshooting common issues

15.    Importing and Exporting Data 

  • Transferring data to/from SQL Server

  • Importing and exporting table data

  • Using BCP and BULK INSERT to import data

  • Deploying and upgrading data-tier applications