MCSE Data Management and Analytics
Overview
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
“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
Trusted by…
