MCSE data management and analytics

COURSE OVERVIEW

If you're looking to demonstrate your skill in building and administrating enterprise scale data solutions onsite and in the Cloud, then the MCSE Data Management and Analytics certification is for you. 

  • 1

    Validate your experience

    Validate your skills in managing and maintaining enterprise databases to ensure high levels of data availability.

  • 2

    Meet demand

    Prove you have what it takes to plan database environments and leverage business intelligence to improve devision making.

  • 3

    Great Earnings

    With an average salary of £40,000+ MCSE certified professionals enjoy lucrative and rewarding careers.

Your quick course guide

Certification: MCSE Data Management and Analytics 

Vendor: Microsoft

Provider: Skillsoft

Student support: StudentCare™ and expert mentors

Prerequisites: MCSA SQL Server 2012/2014 or MCSA SQL 2016 Database Administration

Assessment: Exam based, one of: 70-464, 70-465, 70-466 or 70-467

Resources: Internet access and email

Ideal for: Database analyst, database designer and business intelligence architect

Included in your modules

70-464: Developing Microsoft SQL Server Databases

  • Implementing tables and views
  • Implementing indexes
  • Stored procedures
  • CLR integration
  • Working with data
  • Working with XML data
  • Tuning and optimising queries
  • Managing and troubleshooting

70-465: Designing Database Solutions for Microsoft SQL Server

  • Planning infrastructure
  • Private clouds
  • Windows Azure SQL database
  • High availability
  • Clustering and AlwaysOn
  • Backup and recovery

70-466: Implementing Data Models and Reports with Microsoft SQL Server

  • Design and Install Analysis Services and Tools
  • Designing Multidimensional Models and Data Sources
  • Implement and Configure Cubes
  • Design and Implement Dimensions
  • Implement Partitions and Custom Logic
  • MDX Queries, Process Models, and Deploy Databases
  • Manage, Maintain, and Troubleshoot SSAS
  • Create and Manage Tabular Data Models
  • Design Reports and Create Data Sources and Datasets
  • Report Formatting and Interactivity
  • Manage Reporting Services
  • Process Report and Create Subscriptions and Schedules

70-467: Designing Business Intelligence Solutions with Microsoft SQL Server

  • Designing BI Solutions: BI Infrastructure Design
  • Designing BI Solutions: Extract, Transform, and Load
  • Designing BI Solutions: Data Models
  • Designing BI Solutions: Reporting Services
  • Designing BI Solutions: SharePoint Integration
  • Designing BI Solutions: MDX Queries and Performance
  • Designing BI Solutions: Availability and Recovery

Get certified the Learning People way

Professional development that works around you

  • World's #1 eLearning portal
  • Global community of peers
  • Expert mentors
  • Test prep
  • Hands on interactive Practice Labs
  • Unlimited access
  • Training mapped to Microsoft exam curriculum
  • Award winning training used globally by leading corporate clients

Average salary

2015 JAN
  JUL
2016 JAN
  JUL
2017 JAN
  JUL
Read more

Why join us?

  • Award winning customer support
  • We know the job market inside out
  • Trusted by the giants
  • Value for money
  • CV detox - exclusive to our students
  • We're with you from start to finish
  • Expert career advice
  • Progress reports
  • Exam booking support
  • All UK students receive an NUS student discount card
  • Your success is our success

CV detox

It's not just about your CV...