Enquiry Form

    Complete the form below to receive more details about this course.





    Yes, I’d like Study247.co.uk to contact me via email and phone about course-related topics. Please read our privacy notice for more information.


    0844 264 3600
    nformation.

    Buying for Your Team ?

    You can buy this course for your colleague or members of your team by selecting the number of users you require and adding the course to your shopping basket.

    Once we received your order, we’ll send you a learner’s details spreadsheet to enter your learner’s details.

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

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

    Teachers
    Study247
    Category:
    Microsoft Courses/
    Original price was: £295.00.Current price is: £99.00.
    MICROSOFT 70-467: Designing Business Intelligence Solutions With SQL Server 2012

    Trusted by professionals from some of the world's leading companies

    Original price was: £295.00.Current price is: £99.00.

    Bulk Discounts

    Bigger orders = better discounts

    Courses Discount
    3 - 14 10%
    15 - 49 20%
    50 - 99 30%
    100 - 999 40%

    Enquire
    Duration: 35 Hours
    Awarded By : Microsoft
    Access : 12 Months
    Type : Online Course
    Eligible to Apply : Yes
    Learn How It Works Book Your Exam Buying for your team?

    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 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.

    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!

    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.

    Get Certified with Study247 today!

    It’s simple, effective and affordable.

    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
    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
    Training Features

    • Flexible Learning

      Study247 anytime, anywhere on any device.

    • World Class E-learning Platform

      Study in a user friendly, state-of-the-art e-learning platform.

    • Expert Instructor-Led Training

      Access step-by-step video tutorials delivered by leading industry experts.

    • Visual Demonstrations & Multimedia Presentations

      Develop your skills based on real world scenarios.

    • Quizzes & Mock Exam

      Interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for your final certification exam.

    • Flash Cards & Educational Games

      Allow you to train in ways that keep you engaged and focus.

    • Social Learning & Networking

      Interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.

    • Navigation & Controls

      Allows you to study in bite-size chunks. You can pause, rewind or fast forward your tutorials, take study notes and more.

    Need Practical Experience?

    As a bolt-on option, we offer Practice Labs as it provides users with an online lab platform to develop their practical skills in IT technologies such as CompTIA, Microsoft, Cisco and VMWare.

    In addition to the hardware you require, you also gain access to high quality practical exercises covering exam topics to help you to maximize your study time and increase your results. Practice Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

    You will gain unlimited access to the Practice Labs for 12 months- helping you to consolidate your learning and prepare you for work.Learn More

    Apply for an XO Student Discount Card

    When you enrol on a course with us, you automatically qualify for an XO student discount card which will enable you to enjoy savings from not only high street retailers, bars and restaurants, but also travel companies across the United Kingdom. Learn More

    Want to try before you buy?

    Start a FREE 2-days trial

    No credit card details required. No contracts. No obligations.

    Get Started Today