Microsoft - MCSE: Data Management and Analytics

Duration

Duration:

Just 8 Days

Method

Method:

Classroom / Online / Hybrid

Next date

Next date:

1/5/2024 (Wednesday)

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:

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.

Four reasons why you should sit your MCSE: Data Management & Analytics course with Firebrand Training

  1. You'll be MCSE: Data Management & Analytics trained and certified faster. Learn more on this 8-day accelerated course. You'll get at least 12 hours a day of quality learning time in a distraction-free environment
  2. Your MCSE: Data Management & Analytics course is all-inclusive. One simple price covers all course materials, exams, accommodation and meals – so you can focus on learning
  3. Pass MCSE: Data Management & Analytics first time or train again for free. Your expert instructor will deliver our unique accelerated learning methods, allowing you to learn faster and be in the best possible position to pass first time. In the unlikely event that you don't, it's covered by your Certification Guarantee
  4. Study MCSE: Data Management & Analytics with an award-winning training provider. We've won the Learning and Performance Institute's "Training Company of the Year" three times. Firebrand is your fastest way to learn, with 134.561 students saving more than one million hours since 2001

Pathway

Step 1: Attain your chosen MCSA:

Step 2: Choose one of the following electives to achieve your MCSE: Data Management and Analytics certification

Exam Track

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

What's Included

Depending on the elective you’ve chosen, the following will be included:

  • Microsoft Official Curriculum
  • Microsoft Official Practice Tests

Your accelerated course includes:

  • Accommodation *
  • Meals, unlimited snacks, beverages, tea and coffee *
  • On-site exams **
  • Exam vouchers **
  • Practice tests **
  • Certification Guarantee ***
  • Courseware
  • Up-to 12 hours of instructor-led training each day
  • 24-hour lab access
  • Digital courseware **
  • * For residential training only. Accommodation is included from the night before the course starts. This doesn't apply for online courses.
  • ** Some exceptions apply. Please refer to the Exam Track or speak with our experts
  • *** Pass first time or train again free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.

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.

Are you ready to get certified in record time?

We interview all applicants for the course on their technical background, degrees and certifications held, and general suitability. If you get through this screening process, it means you stand a great chance of passing.

Firebrand Training is an immersive training environment. You must be committed to the course. The above prerequisites are guidelines, but many students with less experience have other background or traits that have enabled their success in accelerated training through Firebrand Training.

If you have any doubts as to whether you meet the pre-requisites please call (0)8 44 68 27 85 and speak to one of our enrolment consultants, who can help you with a training plan.

Reviews

We've currently trained 134.561 students in 12 years. We asked them all to review our Accelerated Learning. Currently,
96,41% have said Firebrand exceeded their expectations:

"The training for PL-100 is an intense course, jam-packed with references, resources delivered by a super knowledgeable instructor. Would recommend having a sound base knowledge of Microsoft Power Platform before attending. MS Learn provides topics for PL-100 and also a study guide for the exam which is very useful when preparing for exam."
Jessica Brooks, Kenvue. (3/1/2024 (Wednesday) to 4/1/2024 (Thursday))

"Training facilities were great and the hotel onsite is nice."
Anonymous. (18/12/2023 (Monday) to 20/12/2023 (Wednesday))

"It's the best way to learn without any distraction. Training, eat, sleep, shower."
Anonymous. (13/12/2023 (Wednesday) to 15/12/2023 (Friday))

"When learning with Firebrand, everything is taken care of for you. This allows you to pour everything into absorbing and understanding your course content amongst peers."
ML, Griggster Limited. (3/10/2023 (Tuesday) to 6/10/2023 (Friday))

"Perfect instructor with much knowledge and the ability to bring it to the people. Thank you. The topic is huge but I would have expected a little bit more working together in the system."
Reinhard Decker, VAT Vakuumventile AG. (10/10/2023 (Tuesday) to 13/10/2023 (Friday))

Course Dates

Microsoft - MCSE: Data Management and Analytics

Start

Finish

Status

Book now

10/4/2024 (Wednesday)

17/4/2024 (Wednesday)

Finished - Leave feedback

 

1/5/2024 (Wednesday)

8/5/2024 (Wednesday)

Wait list

 

27/5/2024 (Monday)

3/6/2024 (Monday)

Open

Book now

28/8/2024 (Wednesday)

4/9/2024 (Wednesday)

Open

Book now

13/11/2024 (Wednesday)

20/11/2024 (Wednesday)

Open

Book now

Latest Reviews from our students