TypeClassroom Training
Time5 Days

Contact Us

Fields marked with an * are required
Administering SQL Database Infrastructure Training Course & Certification

Administering SQL Database Infrastructure Training Course & Certification


Audience & Prerequisites


Administering SQL Database Infrastructure Training Course

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Objectives of Administering SQL Database Infrastructure Training

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • 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

Intended Audience of Administering SQL Database Infrastructure course

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.


Section 1SQL Server Security
Lecture 1Authenticating Connections to SQL Server
Lecture 2Authorizing Logins to Connect to databases
Lecture 3Authorization Across Servers
Lecture 4Partially Contained Databases
Lecture 5Lab : Create Logins & Database Users
Lecture 6Lab: Correct Application Login Issues
Lecture 7Lab: Configure Security for Restored Databases
Section 2Assigning Server and Database Roles
Lecture 8Working with server roles
Lecture 9Working with Fixed Database Roles
Lecture 10Assigning User-Defined Database Roles
Lecture 11Lab: Assigning server and database roles
Lecture 12Lab: Verify Security
Section 3Authorizing Users to Access Resources
Lecture 13Authorizing User Access to Objects
Lecture 14Authorizing Users to Execute Code
Lecture 15Configuring Permissions at the Schema Level
Lecture 16Lab: Granting, Denying, and Revoking Permissions on Objects
Lecture 17Lab: Granting EXECUTE Permissions on Code
Lecture 18Lab: Granting Permissions at the Schema Level
Section 4Protecting Data with Encryption and Auditing
Lecture 19Options for auditing data access in SQL Server
Lecture 20Implementing SQL Server Audit
Lecture 21Managing SQL Server Audit
Lecture 22Protecting Data with Encryption
Lecture 23Lab: Working with SQL Server Audit
Lecture 24Lab: Encrypt a Column as Always Encrypted
Lecture 25Lab: Encrypt a Database using TDE
Section 5Recovery Models and Backup Strategies
Lecture 26Understanding Backup Strategies
Lecture 27SQL Server Transaction Logs
Lecture 28Planning Backup Strategies
Lecture 29Lab: Plan a Backup Strategy
Lecture 30Lab: Configure Database Recovery Models
Section 6Backing Up SQL Server Databases
Lecture 31Backing Up Databases and Transaction Logs
Lecture 32Managing Database Backups
Lecture 33Advanced Database Options
Lecture 34Lab: Backing Up Databases
Lecture 35Lab: Performing Database, Differential, and Transaction Log Backups
Lecture 36Lab: Performing a Partial Backup
Section 7Restoring SQL Server 2016 Databases
Lecture 37Understanding the Restore Process
Lecture 38Restoring Databases
Lecture 39Advanced Restore Scenarios
Lecture 40Point-in-Time Recovery
Lecture 41Lab: Restoring a Database Backup
Lecture 42Lab: Restring Database, Differential, and Transaction Log Backups
Lecture 43Lab: Performing a Piecemeal Restore
Section 8Automating SQL Server Management
Lecture 44Automating SQL Server management
Lecture 45Working with SQL Server Agent
Lecture 46Managing SQL Server Agent Jobs
Lecture 47Multi-server Management
Lecture 48Lab: Create a SQL Server Agent Job
Lecture 49Lab: Test a Job
Lecture 50Lab: Schedule a Job
Lecture 51Lab: Configure Master and Target Servers
Section 9Configuring Security for SQL Server Agent
Lecture 52Understanding SQL Server Agent Security
Lecture 53Configuring Credentials
Lecture 54Configuring Proxy Accounts
Lecture 55Lab: Analyzing Problems in SQL Server Agent
Lecture 56Lab: Configuring a Credential
Lecture 57Lab: Configuring a Proxy Account
Lecture 58Lab: Configuring and testing the Security Context of a Job
Section 10Monitoring SQL Server with Alerts and Notifications
Lecture 59Monitoring SQL Server Errors
Lecture 60Configuring Database Mail
Lecture 61Operators, Alerts, and Notifications
Lecture 62Alerts in Azure SQL Database
Lecture 63Lab: Configuring Database Mail
Lecture 64Lab: Configuring Operators
Lecture 65Lab: Configuring Alerts and Notifications
Lecture 66Lab: Testing Alerts and Notifications
Section 11Introduction to Managing SQL Server by using PowerShell
Lecture 67Getting Started with Windows PowerShell
Lecture 68Configure SQL Server using PowerShell
Lecture 69Administer and Maintain SQL Server with PowerShell
Lecture 70Managing Azure SQL Databases using PowerShell
Lecture 71Lab: Getting Started with PowerShell
Lecture 72Lab: Using PowerShell to Change SQL Server settings
Section 12Tracing Access to SQL Server with Extended events
Lecture 73Extended Events Core Concepts
Lecture 74Working with Extended Events
Lecture 75Lab: Using the System_Health Extended Events Session
Lecture 76Lab: Tracking Page Splits Using Extended Events
Section 13Monitoring SQL Server
Lecture 77Monitoring activity
Lecture 78Capturing and Managing Performance Data
Lecture 79Analyzing Collected Performance Data
Lecture 80SQL Server Utility
Lecture 81Lab: Monitoring SQL Server
Section 14Troubleshooting SQL Server
Lecture 82A Trouble Shooting Methodology for SQL Server
Lecture 83Resolving Service Related Issues
Lecture 84Resolving Connectivity and Log-in issues
Lecture 85Lab: Troubleshoot and Resolve a SQL Login Issue
Lecture 86Lab: Troubleshoot and Resolve a Service Issue
Lecture 87Lab: Troubleshoot and Resolve a Windows Login Issue
Lecture 88Lab: Troubleshoot and Resolve a Job Execution Issue
Lecture 89Lab: Troubleshoot and Resolve a Performance Issue
Section 15Importing and Exporting Data
Lecture 90Transferring Data to and from SQL Server
Lecture 91Importing and Exporting Table Data
Lecture 92Using bcp and BULK INSERT to Import Data
Lecture 93Deploying and Upgrading Data-Tier Application
Lecture 94Lab: Import and Excel Data Using the Import Wizard
Lecture 95Lab: Import a Delimited Text File Using bcp
Lecture 96Lab: Import a Delimited Text File using BULK INSERT
Lecture 97Lab: Create and Test an SSIS Package to Extract Data
Lecture 98Lab: Deploy a Data-Tier Application