MICROSOFT 70-467: Designing Business Intelligence Solutions With SQL Server 2012

Course

Online

Price on request

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Course Description
Microsoft SQL Server 2012 is the one of the latest versions of Microsoft SQL Server, the extremely popular and widely used database system in the world.
In this course, you will learn how to design, implement, and maintain a Business Intelligence (BI) platform with Microsoft SQL Server 2012. You'll learn to design a data warehouse and Business Intelligence solutions including: ETL, BI Delivery, Reporting Services, Excel Reporting, SharePoint Server BI along with how to monitor and optimize a BI solution.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Who Is This Course For?
BI professionals such as BI architects or database professionals who need to design BI solutions.
By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

Certification Details
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Server
  • Sharepoint
  • Database
  • SQL
  • Database training
  • Design
  • Business Intelligence

Course programme

Module 1: Intro to Business Intelligence

  • 1.1 The Business Intelligence Solution
  • 1.2 Overview of Business Intelligence
  • 1.3 BI and Power Pivot Demo
  • 1.4 ETL Intro
  • 1.5 Designing Data Warehouses
  • 1.6 Design for Speed
  • 1.7 BI Semantic Model

Module 2: Database Essentials

  • 2.1 Basic Database Objects Demo
  • 2.2 Stored Procedures and Triggers Demo
  • 2.3 Database Clusters Demo
  • 2.4 SQL Server Management
  • 2.5 Table Triggers
  • 2.6 DB Configuring Options
  • 2.7 DB Backup
  • 2.8 DB Files and Restore

Module 3: Business Intelligence Development

  • 3.1 Using SQL Server Data Tools Demo
  • 3.2 Building an IS Integration Services Package Demo
  • 3.3 Loading Data from Remote Sources Demo
  • 3.4 Processing Data from Web Service Demo

Module 4: Business Intelligence Results

  • 4.1 Report Building Intro Setup Demo
  • 4.2 Using Report Builder Demo
  • 4.3 Reporting from Multiple Tables Demo
  • 4.4 Report Function and Matrix Demo
  • 4.5 Interactive Reports Demo
  • 4.6 Sorting Report Data Demo

Module 5: Advanced Reporting and Development

  • 5.1 Drill Through Reports
  • 5.2 Data Visualization
  • 5.3 Creating Store Procedure from Scratch
  • 5.4 Memory Optimize Table

Module 6: SQL Server Integration Services (SSIS)

  • 6.1 Building Our First Integration Project
  • 6.2 Data Transformation
  • 6.3 Introduction to Big Data
  • 6.4 Transformation Using Store Procedure
  • 6.5 Transformation Using SSIS
  • 6.6 Building Fact Table Using Store Procedure
  • 6.7 Building Fact Table Using SSIS

Module 7: SQL Server 2014 New Features

  • 7.1 Backup Enhancements
  • 7.2 Index Enhancements
  • 7.3 Online DB Enhancements
  • 7.4 Back Up to The Cloud
  • 7.5 Partition Data

Module 8: Course Review and Exam Prep

  • 8.1 BI Review
  • 8.2 SharePoint Overview
  • 8.3 SharePoint Demo
  • 8.4 Exam Preparation
  • 8.5 Before You Take the Exam

MICROSOFT 70-467: Designing Business Intelligence Solutions With SQL Server 2012

Price on request