Advanced Data Management

Lesson 1: Advanced Queries

• 3.1.0 Overview
• 3.1.1 Advanced Queries - Checklist of Activities
• 3.1.2 Lecture Notes [45 minutes]
• 3.1.3 Readings [100 minutes]
• 3.1.4 Websites [15 minutes]
• 3.1.5 Excel 2016: Cleaning Up Your Data [146 minutes]
• 3.1.6 Pain Points - Student Perspective [5 minutes]

Lesson 2: Advanced Queries Continue

• 3.2.1 Advanced Queries - Checklist of Activities [5 minutes]
• 3.2.2 Lecture Notes [60 minutes]
• 3.2.3 Readings [60 minutes]
• 3.2.4 Partition Large Data Tables [9 minutes]

Lesson 3: Advanced Queries Continue

• 3.3.1 Advanced Queries - Checklist of Activities [5 minutes]
• 3.3.2 Lecture Notes [30 minutes]
• 3.3.3 Readings [136 minutes]
• 3.3.4 Websites [15 minutes]
• 3.3.5 Analyze Execution Plans and Tune Queries [5 minutes]
• 3.3.6 Improve Queries With Covering Indexes [5 minutes]
• 3.3.7 Understanding Extract, Transform and Load [2 minutes]

Lesson 4: Advanced Queries Continue

• 3.4.1 Advanced Queries - Checklist of Activities [5 minutes]
• 3.4.2 Lecture Notes [60 minutes]
• 3.4.3 Readings [52 minutes]
• 3.4.4 Websites [15 minutes]
• 3.4.5 Server health and extended events [8 minutes]
• 3.4.6 Aggregate Data [7 minutes]

Lesson 5: Extract, Transform & Load

• 3.5.0 Overview [5 minutes]
• 3.5.1 Extract, Transform & Load - Checklist of Activities [5 minutes]
• 3.5.2 Lecture Notes [45 minutes]
• 3.5.3 Readings [136 minutes]
• 3.5.4 Videos [78 minutes]
• 3.5.5 SSIS Data Flow and Exec SQL Task [6 minutes]

Lesson 6: Extract, Transform & Load Continue

• 3.6.1 Extract, Transform & Load - Checklist of Activities [5 minutes]
• 3.6.2 Lecture Notes [60 minutes]
• 3.6.3 Readings [162 minutes]
• 3.6.4 Videos [145 minutes]
• 3.6.5 Websites [30 minutes]
• 3.6.6 Database Mail Video [7 minutes]
• 3.6.7 SSIS - Moving Files Using Variables [4 minutes]

Lesson 7: Extract Transform & Load Continue

• 3.7.1 Extract, Transform & Load - Checklist of Activities [5 minutes]
• 3.7.2 Lecture Notes [60 minutes]
• 3.7.3 Readings [138 minutes]
• 3.7.4 Videos [41 minutes]
• 3.7.5 Websites [15 minutes]
• 3.7.6 SSIS - Conditional Split Video [4 minutes]

Lesson 8: Extract Transform and Load Continue

• 3.8.1 Extract, Transform & Load - Checklist of Activities [5 minutes]
• 3.8.2 Lecture Notes [60 minutes]
• 3.8.3 Readings [150 minutes]
• 3.8.4 Videos [57 minutes]
• 3.8.5 SSIS - Variable Sources Video [5 minutes]

Lesson 09 - Automate Data Movement

• 3.9.0 Overview [5 minutes]
• 3.9.1 Automate Data Movement - Checklist of Activities [5 minutes]
• 3.9.2 Lecture Notes [60 minutes]
• 3.9.3 Readings [172 minutes]
• 3.9.4 Videos [33 minutes]
• 3.9.5 Websites [15 minutes]
• 3.9.6 Create SQL Agent Job - Stored Procedured [7 minutes]

Lesson 10: Business Intelligence

• 3.10.0 Overview [5 minutes]
• 3.10.1 Business Intelligence - Checklist of Activities [5 minutes]
• 3.10.2 Lecture Notes [60 minutes]
• 3.10.3 Readings [172 minutes]
• 3.10.4 Websites [15 minutes]
• 3.10.5 Advanced SQL for Data Scientists [84 minutes]
• 3.10.6 Facts or Measures [3 minutes]
• 3.10.7 Dimensions [2 minutes]
• 3.10.8 Star and Snowflak Schemas [4 minutes]

Lesson 11: Business Intelligence Continue

• 3.11.1 Business Intelligence - Checklist of Activities [5 minutes]
• 3.11.2 Lecture Notes [60 minutes]
• 3.11.3 Readings [22 minutes]
• 3.11.4 Websites [15 minutes]
• 3.11.5 Understanding Extract, Transform and Load [2 minutes]
• 3.11.6 ETL in an Integration Services packages [4 minutes]
• 3.11.7 Data Analysis Expression (DAX) [4 minutes]
• 3.11.8 Learning Microsoft Power Bi Desktop [175 minutes]

Lesson 12: Business Intelligence Continue

• 3.12.1 Business Intelligence - Checklist of Activities [5 minutes]
• 3.12.2 Lecture Notes [60 minutes]
• 3.12.3 Websites [15 minutes]
• 3.12.4 Making Data Mean More through Storytelling | Ben Wellington | TEDxBroadway [14 minutes]

Lesson 13: Cloud-Based Data Architecture

• 3.13.0 Module 5: Overview [5 minutes]
• 3.13.1 Cloud-Based Data Architecture - Checklist of Activities [5 minutes]
• 3.13.2 Lecture Notes [60 minutes]
• 3.13.3 Websites [15 minutes]
• 3.13.4 Videos [456 minutes]
• 3.13.5 Intro to Big Data Applications [18 minutes]

Lesson 14: Cloud-Based Data Architecture

• 3.14.1 Checklist of Activities [5 minutes]
• 3.14.2 Lecture Notes [60 minutes]
• 3.14.3 Websites [15 minutes]
• 3.14.4 Videos [198 minutes]

Lesson 15: Advanced Data Management - Assessment

• 3.15.1 Assessment - Checklist of Activities [5 minutes]
• 3.15.2 Review Assessment Topics [180 minutes]