MCSE Data Management and Analytics2019-01-28T14:04:31+01:00

MCSE Data Management and Analytics

Courses / Data and Databases



MCSE Data Management and Analytics

Information security plays a vital role in every organisation and at every level. The security specialist program enhances your team’s awareness, skills and knowledge of the three key areas of information security, network security and computer forensics.

Study time: Full time – 10 to 15 days| Part time – 1 to 2 months
Vendor: Microsoft
Business support: Our customer success team measures and ensures engagement
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
Ideal for: Database analyst, database designer and business intelligence architect

Meet the Trainer             

Boris Misljencevic
Boris Misljencevic
Boris Misljencevic has over 5 years of experience working as a software engineer in the IT field. He has work experience with large Silicon Valley based tech companies as well as authoring multiple Android and web apps. Boris’s skills and interests lie in: C/C++, Python, Django, Java, Android, cloud computing as well as Windows and Linux development tools. His Education is in Computer Systems Engineering from Carleton University in Ottawa, Ontario. He is also an active pilot, holding both commercial and flight Instructor licenses.
Contact Us

“Data is growing at a rapid pace. By 2020 the new information generated per second for every human being will approximate amount to 1.7 megabytes.”


Content overview

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

Our Promise

Contact Us

Trusted by…

Data and Databases

Request a Callback

First Name*
Last name*
Company Email*
Company name*
Your role

Contact Information

Phone: 01273 907 919