Microsoft MCSE: Data Management and Analytics

Code: mcsedma

What you'll learn

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.

Prerequisites

Depending on the course and elective exam you choose, the prerequisites vary greatly. Please call us on 080 80 800 888 to discuss your chosen elective and we can explain the process.

Exam info

You will sit a minimum of three exams, on-site, during this course. This is covered by your Certification Guarantee.

Depending on the MCSA path you choose you will take the two exams that align to one of the MCSA certifications:

MCSA: SQL 2016 Database Administration

Administering a SQL Database Infrastructure - exam 70-764
Provisioning SQL Databases - exam 70-765

MCSA: SQL 2016 Database Development

Querying Data with Transact-SQL - exam 70-761
Developing SQL Databases - exam 70-762

MCSA: SQL 2016 Business Intelligence Development

Implement a SQL Data Warehouse - exam 70-767
Developing SQL Data Models - exam 70-768

MCSA: BI Reporting

Analysing Data with Power BI - exam 70-778
Analysing and Visualising Data with Microsoft Excel - exam 70-779

MCSA: SQL Server

Querying Microsoft SQL Server - exam 70-461
Administering Microsoft SQL Server Databases - exam 70-462
Implementing a Data Warehouse with Microsoft SQL Server - exam 70-463

MCSA: Machine Learning

Analyzing Big Data with Microsoft R - exam 70-773
Perform Cloud Data Science with Azure Machine Learning - exam 70-774

MCSA: Data Engineering with Azure

Perform Data Engineering on Microsoft HD Insight - exam 70-775
Engineering Data with Microsoft Cloud Service - exam 70-776

You'll also choose just one of the following exams to get your MCSE: Data Management and Analytics certification:

70-473: Designing and Implementing Cloud Data Platform Solutions
70-475: Designing and Implementing Big Data Analytics Solutions
70-464: Developing Microsoft SQL Server Databases
70-465: Designing Database Solutions for Microsoft SQL Server
70-466: Implementing Data Models and Reports with Microsoft SQL Server
70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
70-762 - Developing SQL Databases
70-767 - Implementing a Data Warehouse using SQL
70-768 - Developing SQL Data Models
70-773 - Analyzing Big Data with Microsoft R
70-774 - Perform Cloud Data Science with Azure Machine Learning
70-775 - Perform Data Engineering on Microsoft Azure HDInsighT

Course Dates

Sorry, there are currently no dates available for this course. Please submit an enquiry and one of our team will contact you about potential future dates or alternative options.

FAQs

4 question

Yes, we do provide courses suitable for beginners. However, Firebrand's accelerated courses aren't easy and it's essential that you are interested and actively pursuing a career in IT.

Traditional training providers usually run their courses from 9am to 5pm. At Firebrand Training we maximise the number of learning hours to minimise the number of training days, so you’ll be back to your job as quickly as possible. You don’t waste time travelling to several courses and finding an exam centre after that.

Firebrand's accelerated courses are constantly reviewed. We ask our delegates for feedback after every course. We are official partners with leading vendors and therefore, we're provided with certification changes and updates, which we can then implement in our course delivery at a very early stage. This feedback is then analysed in view of changes or discrepancies. We will then address the topics mentioned and have a panel of subject matter experts provide us with valuable suggestions for improvement and solutions.

If you need to learn new skills and you want to be able to put them into practice quickly, then Firebrand is the right training company for you.

Our unique accelerated training method means that we are your fastest way to learn. By delivering training for up to 12 hours per day, seven days per week, with exam centres on-site, we ensure that you are trained and certified quicker than anywhere else, having spent less time out of the office away from the day job.

Can't find the answer you're looking for?

Our expert learning advisors are ready to help. Whether you need course recommendations, have technical queries, or want to discuss your learning goals, we're just a message away.

Related courses

All Microsoft Courses

Train your team

Since 2001 we've trained 134,561 employees from thousands of large and small organisations, saving them more than one million hours in training time.

Learn More