Call us:
03300 563100
Basket 0

MCSE Business Intelligence

Course Code: LE001

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. 

  • Learn how to design solutions to deliver more data across the entire organisation from implementing a data models to designing Business Intelligence Solutions with Microsoft SQL.
  • Learn techniques such as restoring databases, system functions and designing a data warehouse with Microsoft SQL Server 2012. 
  • Benefit from your own personal tutor who will offer guidance and support to ensure you progress with ease and confidence.

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

Enrol now and receive a £25 gift voucher towards your next course.

Course Content

  • Microsoft Exam 70-461 - Querying SQL Server 2012
    • 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
    Microsoft Exam 70-462 - Administering Microsoft SQL Server 2012
    • 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
  • Microsoft Exam 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012
    • 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
    Microsoft Exam 70-463 - Implementing Data Models and Reports with Microsoft SQL Server 2012
    • 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
    Microsoft Exam 70-463 - Designing Business Intelligence Solutions with Microsoft SQL 2012
    • 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

Other Information

  • 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. Fun quizzes and exam simulations after each module reinforce your confidence and aid progression to the next stage. This course also includes the use of social networking forums so you chat and gain friendly advice and support from other students. 

  • Course Outcomes

    Upon successful completion of this course, you will receive a Learn365 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. 

course questions & answers

What skills do I need to enrol onto this course?

No previous knowledge is required to enrol onto this course.

Are there any additional costs?

No. Everything you need is included in the price!

What do i do if i still have questions?

For further information please contact us.

Similar Courses

  • Direct debit:
    ?When paid by direct debit - Call for details - See T&C's

Pay up front:£279 Save £100 by paying up front

Free UK Delivery

Contact Us

Additional discounts available on selected courses until 22nd August

    • Days
    • Hours
    • Minutes
    • Seconds
Live Chat
Basket 0