Course Outline

MCSA SQL Server 2016 Database Administration Bootcamp

MS518 | Day | 6 Days

The Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration certification shows that you have the primary set of SQL Server skills that are relevant across multiple solution areas in a business environment.

The primary goal of this course is to help each student pass the exams required to earn their MCSA SQL 2016 Database Administration certification. To do this, your knowledgeable instructor will blend hands-on labs with lecture and practice exams to prepare you to pass each exam. The practice exams identify knowledge gaps that the instructor will fill with customized, hands-on labs and tailored lectures. 

Who should take this course

The MCSA SQL 2016 Database Administration certification is for IT professionals either looking to get their first job in Microsoft Database technology or to document their existing skill sets. This boot camp is intended for students seeking to earn the MCSA SQL 2016 Database Administration certification and who need an expert instructor to guide them throughout the training and exam preparation process.

Course Objectives

After completing this course, students will have the knowledge to:

Course Outline

Module 1: Authenticating and Authorizing Users

This module covers SQL Server security models, logins, and users.

Lessons

 

Module 2: Assigning Server and Database Roles

This module covers fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.

Lessons

 

Module 3: Authorizing Users to Access Resources

This module covers permissions and the assignment of permissions.

Lessons

 

Module 4: Protecting Data with Encryption and Auditing

This module covers SQL Server Audit.

Lessons

 

Module 5: SQL Server Recovery Models

This module describes the concept of the transaction log and SQL Server recovery models. It also introduces the different backup strategies available with SQL Server.

Lessons

 

Module 6: Backup of SQL Server Databases

This module describes SQL Server Backup and the backup types

Lessons

 

Module 7: Restoring SQL Server Databases

This module describes the restoration of databases.

Lessons

 

Module 8: Automating SQL Server Management

This module describes how to use SQL Server Agent for automation. It also explains the benefits of using master and target servers to centralize the administration of automation.

Lessons

 

Module 9: Configuring Security for SQL Server Agent

This module describes the considerations for SQL Server Agent security, including proxy accounts and credentials.

Lessons

 

Module 10: Monitoring SQL Server with Alerts and Notifications

This module covers the configuration of database mail, alerts and notifications.

Lessons

 

Module 11: Introduction to Managing SQL Server by using PowerShell

This module introduces PowerShell for SQL Server.

Lessons

 

Module 12: Tracing Access to SQL Server

This module describes how to use SQL Profiler and SQL Trace stored procedures to capture information about SQL Server. The module also describes how to use Distributed Replay to capture trace information from multiple servers, and how to monitor locking.

Lessons

 

Module 13: Monitoring SQL Server

This module explains how to use Distributed Management Views to monitor SQL Server. It also describes configuration of data collection and the SQL Server Utility.

Lessons

 

Module 14: Troubleshooting SQL Server

This module explains the SQL Server troubleshooting methodology and discusses the most common issues that can arise when working with SQL Server systems.

Lessons

 

Module 15: Importing and Exporting Data

This module covers the use of the import/export wizards and explains how they relate to SSIS. The module also introduces BCP and BULK INSERT.

Lessons

 

Module 16: SQL Server 2016 Components

Describe the SQL Server platform, SQL Server services, and SQL Server configuration options.

Lessons

 

Module 17: Installing SQL Server 2016

This modules describes the process to install SQL Server 2016.

Lessons

 

Module 18: Upgrading SQL Server to SQL Server 2016

This module describes how you go about upgrading your current SQL Server installation to SQL Server 2016.

Lessons

 

Module 19: Deploying SQL Server on Microsoft Azure

This module describes the options available to run SQL Server on Azure.

Lessons

 

Module 20: Working with Databases

This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.

Lessons

 

Module 21: Database Storage Options

At the end of this module you will be able to describe the database storage options.

Lessons

 

Module 22: Performing Database Maintenance

This module covers database maintenance.

Lessons