by | Released July 2013 | ISBN: 9781771371186

In this SQL Server 70-463 Exam training course, expert Steve Hamilton will teach you everything you need to know to pass the Implementing a Data Warehouse with Microsoft SQL Server 2012 test. It is required that you pass the 70-463 exam in order to achieve your MCSA and MCSE certifications from Microsoft.Steve Hamilton takes you through each of the topics that you will have to master to pass the SQL Server 2012 70-463 exam. Throughout this tutorial video, you will learn how to design and implement a data warehouse, extract and transform data, load data, configure and deploy SSIS solutions and build data quality solutions. Each topic is broken down into step-by-step lessons, allowing you to learn quickly, and retain what you learn more effectively.Once you have completed this video based training course for the Microsoft SQL Server 70-463 Exam, you will have a comprehensive understanding of how to Implement a Data Warehouse with SQL Server 2012. You will be fully prepared to write, and pass, your 70-463 exam and continue towards earning your MCSA and MCSE certifications. Show and hide more Publisher resources Download Example Code

1. Introduction Data Warehousing 2012
   • What You Will Learn 00:03:06
   • Data Warehouse Concepts And Architecture 00:05:11
   • Data Warehouse Solutions 00:05:07
2. Data Warehouse Hardware
   • Data Warehouse Challenges - Memory 00:06:20
   • Data Warehouse Challenges - Physical 00:04:52
   • Data Warehouse Architectures 00:07:13
   • Data Warehouse Appliances 00:04:04
3. Designing And Implementing A Data Warehouse
   • Data Warehouse Logical Design 00:07:19
   • Data Warehouse Physical Design 00:08:28
   • Exercise: Implementing A Data Warehouse Schema 00:02:05
   • Solution For Implementing A Data Warehouse Schema 00:06:19
4. Design And Implement A Data Warehouse Schema
   • ETL And SSIS 00:10:14
   • Defining A Data Source 00:07:32
   • Implementing A Data Flow - Part 1 00:08:15
   • Implementing A Data Flow - Part 2 00:09:03
   • Exercise: Implementing A SSIS Package 00:03:39
   • Solution For Implementing A SSIS Package 00:06:05
5. Control Flows And SSIS Package
   • Introduction To Control Flows 00:09:48
   • Dynamic Packages 00:11:08
   • Defining Containers - Part 1 00:06:55
   • Defining Containers - Part 2 00:07:35
   • Manage Consistency 00:06:20
   • Exercise: Implement Control Flows In SSIS 00:02:52
   • Solution For Implementing Control Flow SSIS 00:04:18
6. Debugging And Troubleshooting SSIS Packages
   • Debugging SSIS 00:09:35
   • Error Log Providers 00:07:39
   • Error Handling And SSIS - Part 1 00:07:57
   • Error Handling And SSIS - Part 2 00:05:26
   • Exercise: Debugging And Troubleshooting SSIS 00:02:54
   • Solution For Debugging And Troubleshooting SSIS 00:04:39
7. Incremental ETL Process
   • Introduction To Incremental ETL Processes 00:09:50
   • Extract Modified Data - Part 1 00:09:27
   • Extract Modified Data - Part 2 00:07:09
   • Load Modified Data 00:09:45
   • Exercise: Load Incremental Data 00:05:10
   • Solution For Incremental Load 00:09:57
8. Enforcing Data Quality
   • Data Cleansing 00:07:23
   • Data Quality Services 00:06:56
   • Data Quality Services And Matching Data 00:09:05
   • Exercise Cleansing Data 00:04:30
   • Solution For Cleansing Data 00:09:13
   • Exercise: De-Duplicating Data 00:05:32
   • Solution For De-Duplicating Data 00:09:42
9. Master Data Services
   • What Is Master Data Services 00:07:54
   • Implementing Master Data Services 00:09:18
   • Excel Add-In For Master Data Services 00:07:34
10. Extending SSIS
    • Custom SSIS Components 00:05:44
    • Scripting And SSIS - Part 1 00:07:18
    • Scripting And SSIS - Part 2 00:08:17
11. Deploying SSIS Packages
    • Overview Of SSIS Deployment 00:08:09
    • Deploying SSIS Packages - Part 1 00:07:17
    • Deploying SSIS Packages - Part 2 00:09:16
    • Planning SSIS Package Execution 00:08:41
    • Exercise: Deploying An SSIS Package 00:03:31
    • Solution For Deploying SSIS Package 00:06:41
12. Consuming Data
    • Data Warehouse Using Excel 00:08:31
    • Using PowerPivot And Data Warehouse 00:08:06
    • Data Warehouse And SSRS 00:08:06
    • Exercise: Using Excel And PowerPivot 00:03:02
    • Solution For Excel And PowerPivot 00:05:39
13. About The Author
    • Learn About Me 00:02:04
Show and hide more