MCSE Data Management and Analysis 2016 (Administration)

Description

MCSE: Data Management and Analysis ( Administration )

The Academy of South Florida offers the fastest, most effective method to learn the industry-standard, fundamental features of Microsoft SQL Server that have made Microsoft's premiere database solution a worldwide leader in data-driven business and application infrastructure.

With this SQL Server 2016 boot camp, you will gain valuable insight into the new, powerful capabilities that SQL Server 2016 adds to a database developer and administrator's solutions tool box.

MCSE: Data Management and Analysis certification covers everything from designing, installing, configuring, and maintaining a Microsoft Database environment, to implementing and troubleshooting database objects. This program covers all material and exams necessary to achieve an MCSA in Microsoft SQL Server 2016 Database Administration and MCSE: Data Management and Analysis.  


This 7-day boot camp is a combination of the following official Microsoft courses:
20764A: Administering a SQL Database Infrastructure 
20765A: Provisioning SQL Databases
• 20465A: Designing Database Solutions for Microsoft SQL Server


This course provides students with the technical skills required to authenticate and authorize users. Assign Server and Database roles.  This course helps people prepare for exam 70-764. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to maintaining, restoring, backing up and configuring a database. Also this course helps you prepare for the Exam 70-765. This course provides students with the knowledge and skills to provision, both on premise and in Azure SQL Server 2016. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to maintaining a database.


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

Provision a Database Server

Upgrade SQL Server

Configure SQL Server

Manage Databases and Files (shared)

Describe data warehouse concepts and architecture considerations.

Select an appropriate hardware platform for a data warehouse.

Design and implement a data warehouse.

Implement Data Flow in an SSIS Package.

Implement Control Flow in an SSIS Package.
 
Debug and Troubleshoot SSIS packages.

Implement an SSIS solution that supports incremental data warehouse loads and changing data.

Integrate cloud data into a data warehouse ecosystem infrastructure.

Implement data cleansing by using Microsoft Data Quality Services.

Implement Master Data Services to enforce data integrity.

Extend SSIS with custom scripts and components.

Deploy and Configure SSIS packages.

Describe how information workers can consume data from the data warehouse

Contact Us

THE ACADEMY

1.800.482.3172

FTL: 954.351.7040

MIA: 305.648.2000


Request More Information

 

Current Promotions!

 

  _____________________________________

 

 

 

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!

          

 

Top
  • Follow us on
  • Facebook Academy Page
  • Twitter Academy Page