MICROSOFT 70-467: Designing Business Intelligence Solutions With SQL Server 2012
Original price was: £295.00.£99.00Current price is: £99.00.
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.
Who is this course aimed at?
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.
What is included in this course?
When you enrol, you’ll not only gain powerful, career-enhancing skills but also receive exclusive benefits, including:
Course Assessment Process
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!
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.
Career Path
We’ve put together a list of relevant job titles you can apply for after achieving the Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 certification (note that some careers may require further study, training and/or work experience):
- Database Administrator
- Database Developer
- Database Analyst
- Business Intelligence Analyst
- Business Intelligence Architect
Course Outline
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
Payment Options
Pay securely online by debit or credit card or PayPal. Buying for your team? Talk to us about team training.
Student Reviews
There are no reviews for this course yet.
