MICROSOFT 70-467: Designing Business Intelligence Solutions With SQL Server 2012
Course
Online
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
Start date
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!
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