MCSE Business Intelligence

Course code: LE001

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

Assessment

Fun quizzes and exam simulations after each module reinforce your confidence and aid progression to the next stage. Please note in order to achieve the official qualification you will have to successfully complete a Microsoft exam. This will be at an additional cost and It is your own responsibility to pay for these.

Course Duration

With this flexible home learning course you can fast-forward, rewind or repeat all the online classes so you can go at your own pace with no strict deadlines. Two weeks or twelve months, it’s completely up to you.

Study Method

This blended learning solution offers a highly interactive and engaging learning environment with video demonstrations, multimedia presentations and educational games to assist with your study. This course also includes the use of social networking forums so you chat and gain friendly advice and support from other students.

Course Outcome

Upon successful completion of each of the courses in this bundle, you will receive a certification of completion so you can showcase your achievement to future employers. Please note in order to achieve the official qualification you will have to successfully complete a Microsoft exam. This will be at an additional cost and It is your own responsibility to pay for these.

Awarding body

Microsoft has certification paths for many technical job roles. Each of these certifications consists of passing a series of exams to earn certification.

Q&As

No previous knowledge is required to enrol onto this course.

To receive the full certification from Microsoft you will need to sit an exam, at the cost of around £100 at a Pearson Vue centre.

That's not a problem. We want to make sure you’re 100% confident about enrolling on the course and starting your study. So, just give our Student Adviser Team a call on 03300 563 100 and they’ll do their best to help.

You may also like

£219.00

£239.00

£219.00

Enrol now

If you are interested in and you’re looking for a more flexible approach to learning that fits around your life - this is the ideal course for you. Enrol online today by clicking below or speak to one of our advisers for more information.

Enrol on this course