Microsoft 70-463 Implementing a Data Warehouse with SQL...
4.0 (29 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
208 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft 70-463 Implementing a Data Warehouse with SQL... to your Wishlist.

Add to Wishlist

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

Implementing Data Warehouse with SQL Server 2012
4.0 (29 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
208 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 is the target audience?
  • IT Professionals who wish to gain Microsoft Certification
  • ETL and data warehouse developers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
100 Lectures
04:40:30
+
Implementing a Data Warehouse with Microsoft SQL Server 2012
2 Lectures 01:13

Course Modules
00:38
+
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
About the Instructor
iCollege Certifications
4.1 Average rating
2,031 Reviews
13,475 Students
100 Courses
Certification Leader

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Our collective knowledge and experience in education and training sets the standard for service delivery in learning solutions.

Stone River eLearning
4.2 Average rating
17,554 Reviews
285,788 Students
205 Courses
280,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 450,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.