-86%

Stone River Elearning – Microsoft 70-463 Implementing a Data Warehouse with SQL

Name: Stone River Elearning - Microsoft 70-463 Implementing a Data Warehouse with SQL
Availability: InStock

$42.00

Instant Download: You will receive a download link via your order email immediately
Should you have any questions, please contact us: [email protected]

Category: IT & Technology Tags: Microsoft 70-463 Implementing a Data Warehouse with SQL, Stone River eLearning, Stone River Elearning - Microsoft 70-463 Implementing a Data Warehouse with SQL

Description
Reviews (0)

Stone River Elearning – Microsoft 70-463 Implementing a Data Warehouse with SQL

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

Course Curriculum

Implementing a Data Warehouse with Microsoft SQL Server 2012

Course Introduction (0:35)
Course Modules (0:38)

Module 1

Introduction to Data Warehousing (0:14)
OLTP vs. OLAP Part1 (4:33)
OLTP vs. OLAP Part2 (3:07)
Data Warehouse (2:49)
Data Warehouse Architecture (2:37)
Creating a Data Warehouse Part1 (5:38)
Creating a Data Warehouse Part2 (2:10)
Presenting OLAP Data (5:29)
OLTP & OLAP Comparison Demonstration Part1 (3:57)
OLTP & OLAP Comparison Demonstration Part2 (3:43)
Exam Scenarios (4:31)
Module Review (1:37)

Module 2

Designing a Data Warehouse (0:09)
Data Modeling (1:53)
Data Warehouse Schemas (1:20)
Time Dimensions (2:02)
Data Modeling Considerations Part1 (2:21)
Data Modeling Considerations Part2 (5:16)
Implementing a Data Model (2:04)
Logical Model (2:48)
Physical Model (6:38)
Dimensions and Facts Part1 (5:12)
Dimensions and Facts Part2 (5:26)
Exam Scenarios Part1 (2:09)
Exam Scenarios Part2 (1:49)
Module Review (2:32)

Module 3

ETL with SSIS (0:11)
Introduction to SSIS (1:09)
Upgrading SSIS Packages (0:51)
SSIS Tools (1:24)
Data Flow Tasks (1:59)
Data Sources (1:05)
Transformations (6:30)
Utilizing SQL Server Data Tools (3:00)
Data Flow Task Part1 (5:53)
Data Flow Task Part2 (5:58)
Exam Scenarios (4:14)
Module Review (1:18)

Module 4

SSIS Control Flow (0:09)
Control Flow Tasks (1:16)
Integration Services Variables (2:28)
Expressions (1:14)
Precedence (1:16)
Containers and Annotation (4:49)
Transactions (1:31)
Checkpoints (3:48)
Control Flow Tasks & Precedence Part1 (6:31)
Control Flow Tasks & Precedence Part2 (7:29)
Control Flow Tasks & Precedence Part3 (6:51)
Control Flow Tasks & Precedence Part4 (5:13)
Exam Scenarios (3:13)
Module Review (0:53)

Module 5

Troubleshooting Packages (0:09)
Overview of Troubleshooting (1:11)
Debugging Part1 (2:24)
Debugging Part2 (1:20)
Breakpoints (2:35)
Error Handling (2:59)
SSIS Log Providers (3:33)
Custom Logging (1:10)
Troubleshooting and Logging Part1 (6:42)
Troubleshooting and Logging Part2 (6:03)
Troubleshooting and Logging Part3 (5:50)
Exam Scenarios (2:36)
Module Review (0:51)

Module 6

Advanced Packages (0:16)
Maintaining a Data Warehouse (3:27)
Change Data Capture (4:45)
Slowly Changing Dimensions (2:49)
Script Components (2:35)
Incremental Updates Part1 (5:25)
Incremental Updates Part2 (6:55)
Exam Scenarios Part1 (1:01)
Exam Scenarios Part2 (1:51)
Module Review (0:46)

Module 7

Data Quality Services (0:08)
Introduction to Data Quality Services (1:19)
Data Quality Services Components (5:21)
Working with Data Quality Services Part1 (4:28)
Working with Data Quality Services Part2 (4:43)
Working with Data Quality Services Part3 (3:15)
Exam Scenarios (2:23)
Module Review (0:53)

Module 8

Master Data Services (0:12)
Introduction to Master Data Services (0:47)
MDS vs. DQS (1:28)
How MDS Works (3:54)
Exam Scenarios (2:32)
Module Review (0:50)

Module 9

Deployment and Security (0:08)
Deployment Options (2:43)
Package Deployment (1:38)
Securing Packages (1:35)
Deploying SSIS Packages & Projects Part1 (5:32)
Deploying SSIS Packages & Projects Part2 (2:01)
Exam Scenarios (2:02)
Module Review (0:49)
Program Review (1:05)

Sale Page: https://stoneriverelearning.com/p/microsoft-70-463
Archive: https://archive.ph/wip/XANr3

Delivery Method

– After your purchase, you’ll see a View your orders link which goes to the Downloads page. Here, you can download all the files associated with your order.

– Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from IMCourse.net.

– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.

– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible from 8:00 AM – 8:00 PM (UTC+8).

Thank You For Shopping With Us!