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 Databases 

  • 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