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

Product Information

  • Title: Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 70-463)
  • Author(s): Mark Long
  • Release date: April 2013
  • Publisher(s): Virtual Training Company, Inc.
  • ISBN: 9781618660985