Overview
This 5 day 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.
Admission Requirements
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design.
Available Exams and Certifications
This course will help you you prepare for the Exam 70-764. CLICK HERE to learn more about this exam.
This course contributes towards earning your MCSA: SQL 2016 Database Administration. CLICK HERE to learn more.
Course Outcomes
After completing this course, students will be able to:
- 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
-
Module 1: SQL Server Security
-
Lecture 2.1Authenticating Connections to SQL Server
-
Lecture 2.2Authorizing Logins to Connect to databases
-
Lecture 2.3Authorization Across Servers
-
Lecture 2.4Partially Contained Databases
-
-
Module 2: Assigning Server and Database Roles
-
Lecture 3.1Working with server roles
-
Lecture 3.2Working with Fixed Database Roles
-
Lecture 3.3Assigning User-Defined Database Roles
-
-
Module 3: Authorizing Users to Access Resources
-
Lecture 4.1Authorizing User Access to Objects
-
Lecture 4.2Authorizing Users to Execute Code
-
Lecture 4.3Configuring Permissions at the Schema Level
-
-
Module 4: Protecting Data with Encryption and Auditing
-
Lecture 5.1Options for auditing data access in SQL Server
-
Lecture 5.2Implementing SQL Server Audit
-
Lecture 5.3Managing SQL Server Audit
-
Lecture 5.4Protecting Data with Encryption
-
-
Module 5: Recovery Models and Backup Strategies
-
Lecture 6.1Understanding Backup Strategies
-
Lecture 6.2SQL Server Transaction Logs
-
Lecture 6.3Planning Backup Strategies
-
-
Module 6: Backing Up SQL Server Databases
-
Lecture 7.1Backing Up Databases and Transaction Logs
-
Lecture 7.2Managing Database Backups
-
Lecture 7.3Advanced Database Options
-
-
Module 7: Restoring SQL Server 2016 Databases
-
Lecture 8.1Understanding the Restore Process
-
Lecture 8.2Restoring Databases
-
Lecture 8.3Advanced Restore Scenarios
-
Lecture 8.4Point-in-Time Recovery
-
-
Module 8: Automating SQL Server Management
-
Lecture 9.1Automating SQL Server management
-
Lecture 9.2Working with SQL Server Agent
-
Lecture 9.3Managing SQL Server Agent Jobs
-
Lecture 9.4Multi-server Management
-
-
Module 9: Configuring Security for SQL Server Agent
-
Lecture 10.1Understanding SQL Server Agent Security
-
Lecture 10.2Configuring Credentials
-
Lecture 10.3Configuring Proxy Accounts
-
-
Module 10: Monitoring SQL Server with Alerts and Notifications
-
Lecture 11.1Monitoring SQL Server Errors
-
Lecture 11.2Configuring Database Mail
-
Lecture 11.3Operators, Alerts, and Notifications
-
Lecture 11.4Alerts in Azure SQL Database
-
-
Module 11: Introduction to Managing SQL Server by using PowerShell
-
Lecture 12.1Getting Started with Windows PowerShell
-
Lecture 12.2Configure SQL Server using PowerShell
-
Lecture 12.3Administer and Maintain SQL Server with PowerShell
-
Lecture 12.4Managing Azure SQL Databases using PowerShell
-
-
Module 12: Tracing Access to SQL Server with Extended events
-
Lecture 13.1Extended Events Core Concepts
-
Lecture 13.2Working with Extended Events
-
-
Module 13: Monitoring SQL Server
-
Lecture 14.1Monitoring activity
-
Lecture 14.2Capturing and Managing Performance Data
-
Lecture 14.3Analyzing Collected Performance Data
-
Lecture 14.4SQL Server Utility
-
-
Module 14: Troubleshooting SQL Server
-
Lecture 15.1A Trouble Shooting Methodology for SQL Server
-
Lecture 15.2Resolving Service Related Issues
-
Lecture 15.3Resolving Connectivity and Log-in issues
-
-
Module 15: Importing and Exporting Data
-
Lecture 16.1Transferring Data to and from SQL Server
-
Lecture 16.2Importing and Exporting Table Data
-
Lecture 16.3Using bcp and BULK INSERT to Import Data
-
Lecture 16.4Deploying and Upgrading Data-Tier Application
-