Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

299 USD 18.99 USD 94%
Test scorm

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. 

read more

Module 1

  • Introduction to Data Warehousing
  • OLTP vs. OLAP
  • Data Warehouse
  • Data Warehouse Architecture
  • Creating a Data Warehouse
  • Presenting OLAP Data
  • OLTP and OLAP Comparison Demonstration
  • Exam Scenarios
  • Module Review

Module 2

  • Designing a Data Warehouse
  • Data Modeling
  • Data Warehouse Schemas
  • Time Dimensions
  • Data Modeling Considerations
  • Implementing a Data Model
  • Logical Model
  • Physical Model
  • Dimensions and Facts
  • Exam Scenarios
  • Module Review

Module 3

  • ETL with SSIS
  • Introduction to SSIS
  • Upgrading SSIS Packages
  • SSIS Tools
  • Data Flow Tasks
  • Data Sources
  • Transformations
  • Utilizing SQL Server Data Tools
  • Data Flow Task
  • Exam Scenarios
  • Module Review

Module 4

  • SSIS Control Flow
  • Control Flow Tasks
  • Integration Services Variables
  • Expressions
  • Precedence
  • Containers and Annotation
  • Transactions
  • Checkpoints
  • Control Flow Tasks and Precedence
  • Exam Scenarios
  • Module Review

Module 5

  • Troubleshooting Packages
  • Overview of Troubleshooting
  • Debugging
  • Breakpoints
  • Error Handling
  • SSIS Log Providers
  • Custom Logging
  • Troubleshooting and Logging
  • Exam Scenarios
  • Module Review

Module 6

  • Advanced Packages
  • Maintaining a Data Warehouse
  • Change Data Capture
  • Slowly Changing Dimensions
  • Script Components
  • Incremental Updates
  • Exam Scenarios
  • Module Review

Module 7

  • Data Quality Services
  • Introduction to Data Quality Services
  • Data Quality Services Components
  • Working with Data Quality Services
  • Exam Scenarios
  • Module Review

Module 8

  • Master Data Services
  • Introduction to Master Data Services
  • MDS vs. DQS
  • How MDS Works
  • Exam Scenarios
  • Module Review

Module 9

  • Deployment and Security
  • Deployment Options
  • Package Deployment
  • Securing Packages
  • Deploying SSIS Packages and Projects
  • Exam Scenarios
  • Module Review
  • Program Review
  1. Module 1
6
Start
Data Warehouse
7
Start
Data Warehouse Architecture
8
Start
Creating a Data Warehouse
8
Start
Creating a Data Warehouse
9
Start
Presenting OLAP Data
10
Start
OLTP and OLAP Comparison Demonstration
10
Start
OLTP and OLAP Comparison Demonstration
11
Start
Exam Scenarios
12
Start
Module Review
  1. Module 2
13
Start
Designing a Data Warehouse
14
Start
Data Modeling
15
Start
Data Warehouse Schemas
16
Start
Time Dimensions
17
Start
Data Modeling Considerations
17
Start
Data Modeling Considerations
18
Start
Implementing a Data Model
19
Start
Logical Model
20
Start
Physical Model
21
Start
Dimensions and Facts
21
Start
Dimensions and Facts
22
Start
Exam Scenarios
22
Start
Exam Scenarios
23
Start
Module Review
  1. Module 3
24
Start
ETL with SSIS
25
Start
Introduction to SSIS
26
Start
Upgrading SSIS Packages
27
Start
SSIS Tools
28
Start
Data Flow Tasks
29
Start
Data Sources
30
Start
Transformations

No reviews for this course !

Add New Discussion

How do you rate this product?

Select currency