MCSE Data Platform

MCSE Data Platform

Course Information

Microsoft Certified Solutions Expert Data Platform

Course Details

Certification: MCSE Data Platform
Vendor: Microsoft
Course prerequisite:You will be required to have gained the MCSA: SQL Server 2012 certification.
Study time: 20-30 hours per course
Practical learning: Practice labs are available for the MCSE Data Platform courses.

Certification Details

The MCSE: Data Platform certification requires you to study two courses and pass both of the exams associated with these training courses.

Exam 70-464: Developing Microsoft SQL Server Databases
Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012

Successful completion of these two courses and a passing mark for each exam will result in the MCSE: Data Platform certification which is awarded by Microsoft.

Career Path Opportunities

Data Administrator
Data Platform Engineer
Database Analyst
Database Designer

What's Included

  • Developing Microsoft SQL Server Databases (70-464)
  • Designing Database Solutions for Microsoft SQL Server 2012 (70-465)
  • 12 months unlimited access
  • Student mentor
  • Student care team
  • Career support

Why Learn With Us

Let us help you become the best you can be.

Career Support

Students receive access to our recruitment resource pack which includes our CV review guide, enabling you to showcase your new skills.

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 6 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 team 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 Platform

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
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

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

Source: Adzuna
Average Salary
Data Platform Engineer
Average Salary
You Can Earn
Average Salary
Data Administrator

Salary Projection

Average Salary

Database Analyst


You can earn an average of £42k a year

Enquire About MCSE Data Platform

Learn more about how we use your data.