MCSE Business Intelligence

Course code: LE001
Discounted Selected Courses
The offer has expired
Days Hours Minutes Seconds

This flexible home study learning option will allow you to earn a MCSE: Business Intelligence certification with no strict deadlines or timetabling.

  • Learn how to design solutions to deliver more data across entire organisations.
  • Develop skills to implement data models.
  • Learn how to design Business Intelligence Solutions with Microsoft SQL.
  • Learn techniques such as restoring databases, system functions and designing a data warehouse with Microsoft SQL Server 2012.
This course is only available to study online.
Course Overview

Improve your skill set with a certified qualification studied at your own pace. This flexible home study learning option will allow you to earn a MCSE: Business Intelligence certification with no strict deadlines or timetabling.

Benefit from a wide range of study methods including quizzes, presentations and student forums to help you get the most out of your course

Enrol today and fast track your career in the IT industry with a flexible home study learning option to suit you.

Course Duration

Up to 1 year.

Study Hours

Approximately 80 hours.

Course Outcome

MCSE Business Intelligence Certificate of Completion. You can choose to take your exams to receive the full qualification!

Entry Requirements

There are no specific entry requirements for this course.

Assessment

Exam simulations after each module

Course Content
  • Introduction to SQL Server 2012
  • T-SQL Overview
  • SELECT Statements
  • Filtering
  • Join and Set Operators
  • Subqueries and Table Expressions
  • System Functions
  • T-SQL Programming
  • Transactions
  • Query Performance
  • Introduction to SQL Server 2012
  • Installing SQL Server
  • Backup and Restore a Database
  • Tracing Access to SQL Server
  • Importing and Exporting Data
  • SQL Server Security
  • Automating SQL Server
  • Monitoring SQL Server
  • Maintaining SQL Server
  • Troubleshooting SQL Server
  • Introduction to Data Warehousing
  • Designing a Data Warehouse
  • ETL with SSIS
  • SSIS Control Flow
  • Troubleshooting Packages
  • Advanced Packages
  • Data Quality Services
  • Master Data Services
  • Deployment and Security
  • Course Introduction
  • SQL Server Reporting Services
  • SSRS Management
  • Multidimensional Cubes
  • Advanced Cube Concepts
  • Customizing Cubes and Security
  • Multidimensional expressions (MDX)
  • Tabular Data Models
  • Data Analysis eXpressions (DAX)
  • Data Mining
  • Course Introduction
  • Designing a Data Warehouse
  • Extraction, Transformation and Load (ETL) with SSIS
  • Deploying and Securing Packages
  • SQL Server Reporting Services (SSRS)
  • SSRS Reports
  • Multidimensional Cubes
  • Tabular Data Models
  • MDX/DAX
  • Data Mining