MCSE Data Management and Analytics

MCSE Data Management and Analytics

Course Information

MCSE Data Management and Analytics

Course Details

Certification: MCSE Data Management and Analytics
Vendor: Microsoft
Course prerequisite: Before earning your MCSE: Data Management and Analytics certification, you will need to have earned one of the following qualifications: MCSA: SQL Server 2012/2014, MCSA: SQL 2016 BI Development, MCSA: SQL 2016 Database Administration, MCSA: SQL 2016 Database Development, MCSA: Machine Learning, MCSA: BI Reporting, MCSA: Data Engineering with Azure
Study time: 20-30 hours
Practical learning: Practice labs are available for the MCSE Data Management and Analytics courses.

Certification Details

To gain the MCSE: Data Management and Analytics one of the following exams must be passed:

Exam 70-464: Developing Microsoft SQL Server 2012 Databases
Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012
Exam 70-466: Implementing Data Models & Reports with SQL Server 2012
Exam 70-467: Designing Business Intelligence Solutions with SQL Server 2012

Once you have passed the exam, you will have earned your internationally recognised MCSE: Data Management and Analytics certification which is awarded by Microsoft.

Career Path Opportunities

Database Analyst
Database Designer
Business Intelligence Analyst
Business Intelligence Consultant

What's Included

  • Developing Microsoft SQL Server 2012 Databases (70-464)
  • Designing Database Solutions for Microsoft SQL Server 2012 (70-465)
  • Implementing Data Models & Reports with SQL Server 2012 (70-466)
  • Exam 70-467: Designing Business Intelligence Solutions with SQL Server 2012
  • 12 months unlimited access
  • Student mentor
  • Student care team
  • CV review service

Why Learn With Us

Let us help you become the best you can be.

CV Review

We will revise your CV to showcase your new qualification and give you the edge when it comes to getting an interview.


Learn more

Student Support

Our dedicated student support team is only a phone call or email away, to answer your questions and help you prepare for exams.


Learn more

Flexible Finance

Our 0% interest finance plans are fully flexible and range from six to 36 months, allowing you to enrol on your course with complete peace of mind.


Learn more

Partnered with Leaders

We partner with the world’s leading course providers to make sure you have high-quality learning materials that will accelerate your learning.


Learn more

Expert Team

Our expert team of career advisors undergo daily training for the latest updates and demands in the industry, to help find you the perfect role to begin your career.


Learn more

Get This Qualification On Your CV

Transform your career today

Validate your technical expertise with industry recognised certifications from the world's biggest software maker, Microsoft

Course Curriculum

MCSE Data Management and Analytics

1
Exam 70-464: Developing Microsoft SQL Server 2012 Databases
  1. SQL 2012 And The 464 Test
  2. Working with Data Types
  3. Tables
  4. Data Constraints
  5. Planning In Indexing
  6. Table Structures
  7. Improving Performance with Non-Clustered Indexes
  8. Using Indexes And Execution Plans
  9. Working with Views
  10. Designing and Implementing Stored Procedures
  11. Merging Data and Passing Tables
  12. Designing and Implementing User Functions
  13. Creating Highly Concurrent SQL Server Applications
  14. Handling Errors in T-SQL
  15. Triggers
  16. Implementing Managed Code
  17. Storing XML in SQL
  18. Querying XML
  19. Working with the Spatial Data
  20. Working With Full-Text Indexes and Queries
2
Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012
  1. Designing A Database Server Infrastructure
  2. Designing A Logical Database Scheme
  3. Designing A Physical Database Implementation
  4. Incorporating Data Files Into the Database
  5. Tuning Database Performance
  6. Designing Database Security
  7. Policy Based Management
  8. Monitoring Server Health
  9. Designing Database Backup Solution
  10. Automating Multi Server Maintenance
  11. Managing SQL Server With Windows Powershell
  12. Replicating Data
  13. Planning High Availability
  14. Review of SQL Statements
  15. Eleven Rules of Database Design
3
Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
  1. Introduction To Business Intelligence And Data Modeling
  2. Implementing Reports The SQL Server Reporting Services
  3. Supporting Self Service Reporting
  4. Managing Report Execution And Delivery
  5. Creating Multidimensional Databases
  6. Working With Cubes And Dimensions
  7. Working With Measures And Measure Groups
  8. Introduction To MDX
  9. Customizing Cube Functionality
  10. Implementing A Tabular Data Model
  11. Introduction To DAX
  12. Implementing An Analysis Services Tabular Data Model
  13. SQL Analysis Services
  14. Creating Data Visualizations With Power View
  15. Supporting Self Service Reporting
  16. Performing Predictive Analysis With Data Mining
  17. Predictive Analytics
4
Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
  1. Intro To Business Intelligence 
  2. Database Essentials 
  3. Business Intelligence Development 
  4. Business Intelligence Results 
  5. Advanced Reporting And Development 
  6. SQL Server Integration Services (SSIS) 
  7. SQL Server 2014 New Features 
  8. Course Review And Exam Prep

Why Get Qualified ?

Gain new skills and knowledge

Thinking ahead and learning the skills needed to move forward in your current career path will mean you are more likely to be considered for future roles.

Gain credibility early in your career

A certification from IT Online Learning shows prospective employees that you have the right skills and credentials needed to succeed in your career.

Increase your opportunity for promotion

Gaining the right set of qualifications will increase your chances of moving into a supervisory or management role, giving you the opportunity to increase your salary.

Average Salary Projection

HIGH
Source: Adzuna
Average Salary
Business Intelligence Analyst

85K

Average Salary
You Can Earn

55K

Average Salary
Database Analyst

45K

Salary Projection

Average Salary

Business Intelligence Consultant

55K

You can earn an average of

55K

a year

Enquire About MCSE Data Management and Analytics

Learn more about how we use your data.