MCSA: Data Warehouse Implementation Microsoft Sql 2012 (Exam 70-463)

Price

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

Inc VAT (was £295.00)
Save £196.00
Course Type
Online Course
Course Duration
35 Hours
Course Access
12 Months
Awarded By
Microsoft
Student Discount Card
Eligible
Share

Course Description

Study247 MCSA: Data Warehouse Implementation Microsoft SQL 2012 course introduces you to the key components of a data warehousing solution. The course provides learners with the technical skills required to design and implement a data warehouse. It also provides information on automating an ETL solution using SQL Server Integration Services.

This course will help current and aspiring data professionals to prepare for the Microsoft 70-463 exam, known as Implementing a Data Warehouse with SQL Server 2012.

Passing the Implementing a Data Warehouse with SQL Server 2012 (70-463) exam is a requirement to getting MCSA certified, which in turn is a prerequisite to achieving an MCSE certification.

What is included in this course?

When you enrol, you’ll not only gain powerful, career-enhancing skills but also receive exclusive benefits, including:

Who is this course aimed at?

Contact our course advisors to check whether this course is the right fit for you.

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 MCSA: Data Warehouse Implementation Microsoft SQL 2012 (Exam 70-463) certification (note that some careers may require further study, training and/or work experience):

  • Database Administrator
  • Database Developer
  • Database Analyst
Course Outline

Course Outline

Lesson 1: Introduction to Data Warehouses

  • Topic A: Overview of Data Warehouses
  • Topic B: Examine Data Warehousing Concepts
  • Topic C: Introduction to Data Analysis and Reporting Concepts

Lesson 2: Creating Dimensions and Changing Granularity of Dimensions

  • Topic A: Create Dimensions
  • Topic B: Change Granularity

Lesson 3: Creating Fact Tables and Column store Indexes

  • Topic A: Create Fact Tables
  • Topic B: Create Column store Indexes
  • Lesson 4: Implementing Data Warehouses in SQL Server 2012
  • Topic A: Overview of Data Warehouse Components
  • Topic B: Install Integration Services

Lesson 5: Working with Integration Services

  • Topic A: Create an SSIS Project
  • Topic B: Add Packages to an SSIS Project

Lesson 6: Managing Control Flow

  • Topic A: Deploy a Control Flow
  • Topic B: Execute Packages from Different Control Flow

Lesson 7: Working with Dynamic Variables

  • Topic A: Create Expressions with Variables
  • Topic B: Create Package Templates

Lesson 8: Implementing Data Flow

  • Topic A: Add Data Flow Components to a Data Flow Task
  • Topic B: Perform Transformation Tasks
  • Topic C: Track Changed Data

Lesson 9: Managing Data Flow

  • Topic A: Add Script Tasks and Script Components to an SSIS Package
  • Topic B: Profile OLTP Data
  • Topic C: Cleanse Data Using DQS

Lesson 10: Managing SSIS Package Execution

  • Topic A: Execute SSIS Packages on the Server
  • Topic B: Configure the Package Execution Strategy

Lesson 11: Debugging and Troubleshooting Packages

  • Topic A: Debug Package Execution Components
  • Topic B: Troubleshoot Package Failures

Lesson 12: Deploying Packages

  • Topic A: Deploy SSIS Packages
  • Topic B: Examine MSI Packages

Lesson 13: Securing Packages and Databases

  • Topic A: Secure Packages
  • Topic B: Secure Databases

Lesson 14: Working with MDS and Windows Azure

  • Topic A: Configure MDS
  • Topic B: Work with MDS Databases
  • Topic C: Work with Windows Azure
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.

For purchases of 1–9 learner enrolments, simply select the number of learners you wish to enrol and click Add to Basket. You can then complete your purchase using most major credit or debit cards, or PayPal. Once payment has been confirmed, we’ll process your order and email your course login instructions.

For 10 or more learner enrolments, bulk purchase discounts, or if you would prefer to pay by BACS bank transfer or invoice, please contact us using the enquiry form or email sales@study247.co.uk.

Purchase Order Payments: To purchase courses using a purchase order (PO), please email your PO details to sales@study247.co.uk, and our team will assist you with the enrolment process.

Student Reviews

There are no reviews for this course yet.

MCSA: Data Warehouse Implementation Microsoft Sql 2012 (Exam 70-463)
VISA●●PayPalApple Pay
14-day money-back guarantee
Buying for your team? Talk to us
Privacy
Protected
Secure
Checkout
TOTUM+ NUS Official Card

Unlock exclusive student discounts.

By purchasing a course on Study247, you become part of our community and are eligible to sign up for TOTUM+, the student discount card that provides a host of benefits. Join our community today and start saving on your favourite brands.
Search courses
Ask us about this course.