Microsoft 365 - MCSE: Data Management and Analytics

Overview

On this 8 day accelerated course, you'll learn the skills to get MCSA: SQL Server 2016 and MCSE: Data Management and Analytics certified.

Choose from three distinct MCSA pathways to develop your SQL Server 2016 skills across Business Intelligence, Database Administration or Database Development. Then select an elective to advance your SQL Server skills across these distinct disciplines, learning how to manage business data both on premises and in cloud environments.

Below are the options available to you. First choose from the following MCSA certification courses:

• MCSA: SQL 2016 Database Development - where you'll validate your skills in developing SQL databases and querying data with transact SQL.
• MCSA: SQL 2016 Database Administration - will develop your understanding of database installation, maintenance, configuration and provision tasks with SQL databases.
• MCSA: SQL 2016 Business Intelligence Development - will develop your extract, transform and load (ETL) and data warehouse skills as well as your knowledge of BI solutions using models and analytical processing cubes.
• MCSA: BI Reporting - develop the skills you need to create and manage enterprise business intelligence solutions as well as gain an expert understanding of data analysis using Power BI.
• MCSA: SQL Server - master SQL Server querying, administration and implementation of a Data Warehouse.
• MCSA: Machine Learning - get the skills in operationalising Microsoft Azure machine learning and Big Data with R Server and SQL R Services.
• MCSA: Data Engineering with Azure -develop the skills to design and implement big data engineering workflows with the Microsoft cloud ecosystem and Microsoft HD Insight to extract strategic value from your data.

Then, to achieve this MCSE: Data Management and Analytics certification, choose just one of the following elective accelerated course and exam combinations:

• Designing and Implementing Cloud Data Platform Solutions - 2 days
• Designing and Implementing Big Data Analytics Solutions - 4 days
• Developing Microsoft SQL Server Databases - 3 days
• Designing Database Solutions for Microsoft SQL Server - 3 days
• Implementing Data Models and Reports with Microsoft SQL Server - 3 days
• Designing Business Intelligence Solutions with Microsoft SQL Server 2014 - 3 days
• Developing SQL Databases - 3 days
• Implementing a Data Warehouse using SQL - 3 days
• Developing SQL Data Models - 3 days
• Analyzing Big Data with Microsoft R - 3 days
• Perform Cloud Data Science with Azure Machine Learning - 3 days
• Perform Data Engineering on Microsoft Azure HDInsight - 3 days

Earning the MCSE: Data Management and Analytics certification will prove your competency in SQL administration, building enterprise-scale data solutions and leveraging business intelligence data- both on premises and in cloud environments.

Using our unique Lecture | Lab | Review technique, our Microsoft Certified Trainers will immerse you in the Microsoft Official Curriculum. This technique will make use of both theoretical and practical tasks. This will help you better retain information and develop your hands-on skills which can be applied in the office.

You'll be prepared for and sit your exams on-site. This is covered by your Certification Guarantee.

Earning an MCSE: Data Management and Analytics certification will qualify you for roles such as database analyst, database designer, and business intelligence analyst.