Microsoft 70-463 Implementing a Data Warehouse with SQL...
4.0 (59 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
345 students enrolled

Microsoft 70-463 Implementing a Data Warehouse with SQL...

Implementing Data Warehouse with SQL Server 2012
4.0 (59 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
345 students enrolled
Last updated 4/2017
English
English [Auto-generated]
Current price: $11.99 Original price: $199.99 Discount: 94% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • This course will prepare you to pass the exam Microsoft 70-463: Implementing Data Warehouse with SQL Server 2012.
  • This course is designed for ETL and Data Warehouse developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation.

Requirements
  • Basic understanding of SQL server
  • Interest in Business Intelligence (BI) solutions
Description

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012. 


This course is designed for ETL and Data Warehouse Developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Primary responsibilities may include:

  • Mastering data using Master Data Services
  • Cleansing data using Data Quality Services
  • ETL Package development for data loading/transfer/transformation
  • Data Synchronization
  • One-time data or application migration
  • Ad-hoc data manipulations, transformations
  • Scheduling ETL jobs
  • Managing, configuring and deploying SQL Server Integration Services (SSIS) packages

This training course on implementing a Data Warehouse with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-463.

This course will provide all the skills and knowledge for the following areas:

  • Designing and implementing dimensions
  • Designing and implementing fact tables
  • Defining connection managers
  • Designing and implementing data flow
  • Managing SSIS package execution
  • Implementing script tasks in SSIS
  • Designing and implementing control flow
  • Implementing package logic using SSIS variables and parameters
  • Implementing data load options
  • Implementing script components in SSIS
  • Troubleshooting data integration issues
  • Installing and maintaining SSIS components
  • Implementing auditing, logging, and event handling
  • Deploying SSIS solutions
  • Configuring SSIS security settings
  • Installing and maintaining Data Quality Services
  • Implementing master data management solutions
  • Creating a data quality project to clean data

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. 

Who this course is for:
  • IT Professionals who wish to gain Microsoft Certification
  • ETL and data warehouse developers
Course content
Expand all 100 lectures 04:40:30
+ Module 1
12 lectures 40:25
Introduction to Data Warehousing
00:14
OLTP vs. OLAP Part1
04:33
OLTP vs. OLAP Part2
03:07
Data Warehouse
02:49
Data Warehouse Architecture
02:37
Creating a Data Warehouse Part2
02:10
Presenting OLAP Data
05:29
OLTP & OLAP Comparison Demonstration Part1
03:57
OLTP & OLAP Comparison Demonstration Part2
03:43
Exam Scenarios
04:31
Module Review
01:37
+ Module 2
14 lectures 41:39
Designing a Data Warehouse
00:09
Data Modeling
01:53
Data Warehouse Schemas
01:20
Time Dimensions
02:02
Data Modeling Considerations Part1
02:21
Data Modeling Considerations Part2
05:16
Implementing a Data Model
02:04
Logical Model
02:48
Physical Model
06:38
Dimensions and Facts Part1
05:12
Dimensions and Facts Part2
05:26
Exam Scenarios Part1
02:09
Exam Scenarios Part2
01:49
Module Review
02:32
+ Module 3
12 lectures 33:32
ETL with SSIS
00:11
Introduction to SSIS
01:09
SSIS Tools
01:24
Data Flow Tasks
01:59
Data Sources
01:05
Transformations
06:30
Utilizing SQL Server Data Tools
03:00
Data Flow Task Part1
05:53
Data Flow Task Part2
05:58
Module Review
01:18
+ Module 4
14 lectures 46:41
SSIS Control Flow
00:09
Control Flow Tasks
01:16
Integration Services Variables
02:28
Expressions
01:14
Precedence
01:16
Containers and Annotation
04:49
Transactions
01:31
Checkpoints
03:48
Control Flow Tasks & Precedence Part1
06:31
Control Flow Tasks & Precedence Part2
07:29
Control Flow Tasks & Precedence Part3
06:51
Exam Scenarios
03:13
Module Review
00:53
+ Module 5
13 lectures 37:24
Troubleshooting Packages
00:09
Overview of Troubleshooting
01:11
Debugging Part1
02:24
Debugging Part2
01:20
Breakpoints
02:36
Error Handling
02:59
SSIS Log Providers
03:33
Custom Logging
01:10
Troubleshooting and Logging Part1
06:42
Troubleshooting and Logging Part2
06:03
Troubleshooting and Logging Part3
05:50
Module Review
00:51
+ Module 6
10 lectures 29:50
Advanced Packages
00:16
Maintaining a Data Warehouse
03:27
Change Data Capture
04:45
Slowly Changing Dimensions
02:49
Script Components
02:35
Incremental Updates Part1
05:25
Incremental Updates Part2
06:55
Exam Scenarios Part1
01:01
Exam Scenarios Part2
01:51
Module Review
00:46
+ Module 7
8 lectures 22:30
Data Quality Services
00:08
Introduction to Data Quality Services
01:19
Working with Data Quality Services Part1
04:28
Working with Data Quality Services Part2
04:43
Working with Data Quality Services Part3
03:15
Exam Scenarios
02:23
Module Review
00:53
+ Module 8
6 lectures 09:43
Master Data Services
00:12
Introduction to Master Data Services
00:47
MDS vs. DQS
01:28
How MDS Works
03:54
Exam Scenarios
02:32
Module Review
00:50
+ Module 9
9 lectures 17:33
Deployment and Security
00:08
Deployment Options
02:43
Package Deployment
01:38
Securing Packages
01:35
Deploying SSIS Packages & Projects Part1
05:32
Deploying SSIS Packages & Projects Part2
02:01
Exam Scenarios
02:02
Module Review
00:49
Program Review
01:05