O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Video 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.

Table of Contents

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