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

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

Video Description

Business data analysis becomes more important as the amount of data involved in the analysis grows. This data is in various database management products, spreadsheets, and documents. A data warehouse collects needed data and organizes the data in a form that solves the complexities and performance issues that line-of-business applications present. In this VTC course, author Mark Long walks you through the information you need to get prepared to take Microsoft's 70-463 certification exam: Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is part of Microsoft's MCSA: SQL Server Certification. To begin learning today, simply click on the movie links.

Table of Contents

  1. Welcome
    1. Introduction 00:00:50
    2. Course Overview 00:02:19
    3. SQL Server Basics 00:04:18
    4. Database Types 00:04:03
    5. Terminology 00:05:33
    6. SQL Server 2012 Certification 00:04:43
    7. About the 70-463 Exam 00:03:01
  2. Getting Set Up
    1. System Hardware Requirements 00:04:19
    2. System Software Requirements 00:03:32
    3. Getting the Software 00:04:09
    4. Installing SQL Server 2012 pt. 1 00:05:52
    5. Installing SQL Server 2012 pt. 2 00:06:01
    6. Installing SQL Server 2012 pt. 3 00:04:10
    7. Verifying the Installation 00:03:56
    8. Attaching the Sample Database pt. 1 00:02:55
    9. Attaching the Sample Database pt. 2 00:04:00
    10. Exploring the Sample Database 00:04:53
    11. Downloading Books Online 00:04:24
    12. TechNet and MSDN 00:04:25
  3. Data Warehouse Basics
    1. Data Usage Challenges 00:04:18
    2. Understanding Normalization 00:04:19
    3. Normalized Structure Challenges 00:05:32
    4. Star Schema Basics 00:04:31
    5. Snowflake Schema Basics 00:05:37
    6. Understanding Granularity 00:04:27
    7. Auditing and Lineage 00:05:07
    8. Simple DW Example 00:06:18
  4. Creating a Data Warehouse
    1. Understanding Fact Tables 00:02:52
    2. Understanding Dimensions pt. 1 00:06:21
    3. Understanding Dimensions pt. 2 00:03:47
    4. Dimension Column Types 00:05:15
    5. Understanding SCDs pt. 1 00:05:30
    6. Understanding SCDs pt. 2 00:06:24
    7. Understanding SCDs pt. 3 00:05:37
    8. Creating Our DW Database 00:05:11
    9. Identifying Our Dimensions 00:03:16
    10. Identifying Our Fact Table 00:03:13
    11. Understanding Indexes 00:06:28
    12. Indexing the Data Warehouse 00:04:59
    13. Understanding Indexed Views 00:04:30
    14. Creating an Indexed View 00:06:32
    15. Understanding Data Compression 00:05:27
    16. Using Partitions 00:06:15
    17. Data Lineage pt. 1 00:04:40
    18. Data Lineage pt. 2 00:04:59
    19. Creating Our Dimensions 00:05:52
    20. Creating Our Fact Table 00:01:55
    21. Creating Our Relationships 00:05:39
  5. Data Flow Using SSIS
    1. SSIS Basics 00:06:04
    2. Getting SQL Server Data Tools 00:05:42
    3. Getting Visual Studio 00:06:35
    4. Using the Import Export Wizard 00:05:23
    5. SSIS Development Overview 00:05:46
    6. Data Movement Planning 00:03:56
    7. Simple SSIS Example pt. 1 00:06:09
    8. Simple SSIS Example pt. 2 00:05:48
    9. Using Connection Managers 00:06:42
    10. Data and Control Flow 00:04:01
    11. Understanding Containers 00:06:43
    12. Understanding Groups 00:04:42
    13. Data Conversion Task 00:05:02
    14. Customer Dimension Load Considerations 00:04:03
    15. Loading the Customer Dimension pt. 1 00:06:50
    16. Loading the Customer Dimension pt. 2 00:06:10
    17. Loading the Customer Dimension pt. 3 00:06:06
    18. Loading the FactInternetSales Table pt. 1 00:06:16
    19. Loading the FactInternetSales Table pt. 2 00:06:15
  6. Design and Implement Data Flow
    1. Creating a Data Flow Task 00:06:24
    2. Data Flow Source Adapters 00:06:19
    3. Data Flow Destination Adapters 00:05:56
    4. Row or Batch Processing 00:04:06
  7. Advanced Control Flow
    1. Using Variables pt. 1 00:05:59
    2. Using Variables pt. 2 00:04:18
    3. Understanding Variable Scope 00:03:20
    4. Property Parameterization pt. 1 00:06:11
    5. Property Parameterization pt. 2 00:04:33
    6. Parameters vs. Variables 00:03:14
    7. Understanding Expressions pt. 1 00:05:32
    8. Understanding Expressions pt. 2 00:06:23
    9. Package and Task Transactions pt. 1 00:06:20
    10. Package and Task Transactions pt. 2 00:06:12
  8. Data Services
    1. Data Quality Services Overview 00:04:07
    2. Implementing DQS 00:03:40
    3. Master Data Services Overview 00:04:07
  9. Custom Code in SSIS
    1. Script Task Basics 00:02:45
    2. Using a Script pt. 1 00:05:56
    3. Using a Script pt. 2 00:06:15
    4. Using a Script pt. 3 00:05:13
    5. Configuring Script Tools 00:04:04
  10. Deploying Packages
    1. Deploying SSIS Packages 00:02:27
    2. Creating the SSISDB Catalog 00:04:14
    3. Deploying a Project 00:04:01
    4. Executing a Package 00:05:00
    5. Scheduling a Package 00:05:58
  11. Conclusion
    1. Course Wrap Up 00:04:26
  12. Credits
    1. About the Author 00:02:39