SQL Server 70-767: Implementing a Data Warehouse Using SQL

SQL Server 70-767: Implementing a Data Warehouse Using SQL

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 7h 40m | 3.24 GB

Prepare for Microsoft Exam 70-767: Implementing a Data Warehouse Using SQL, and develop practical skills to design, configure, and manage a data warehouse with SQL Server

In this video training, Scot Reagin couples discussion with demonstration to give you not only the technical and procedural aspects of implementing a data warehouse, but also a basis to make design choices that will make your job more efficient and effective.

Learn How To

  • Design and implement dimension tables and fact tables
  • Design Rowstore and Columnstore indexes
  • Design storage for a data solution
  • Implement SSIS packages
Table of Contents

01 SQL Server 70-767 – Introduction
02 Learning objectives
03 1.1 Design Hierarchies
04 1.2 Determine keys and key relationships
05 1.3 Design and maintain slowly changing dimensions
06 1.4 Implement auditing and lineage
07 Learning objectives
08 2.1 Identify measures
09 2.2 Identify dimension table relationships
10 2.3 Design many-to-many relationships
11 Learning objectives
12 3.1 Design Rowstore indexes
13 3.2 Design Columnstore indexes
14 Learning objectives
15 4.1 Configure hardware and file layout
16 4.2 Design partitions
17 Learning objectives
18 5.1 Implement an SSIS control flow
19 5.2 Implement an SSIS data flow
20 5.3 Implement transformations
21 5.4 Create variables and parameters
22 Learning objectives
23 6.1 Implement fuzzy grouping and fuzzy lookup
24 6.2 Implement checkpoints
25 6.3 Implement data profiling
26 Learning objectives
27 7.1 Configure SQL Server to use Change Data Capture
28 7.2 Using Change Data Capture
29 Learning objectives
30 8.1 Diagnose errors using the debugger
31 8.2 Deploy and configure packages
32 8.3 Execute packages
33 Learning objectives
34 9.1 Implement Data Quality Services
35 9.2 Configure Data Quality Services
36 9.3 Implement Data Quality Services in SSIS
37 Learning objectives
38 10.1 Implement Master Data Services
39 10.2 Configure Master Data Services
40 10.3 Administer Master Data Services
41 SQL Server 70-767 – Summary