Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Implementing Data Warehouse with Microsoft SQL Server
Setting up the environment
Course Introduction (2:34)
Data Warehouse Hardware Considerations (10:42)
FTDW Sizing Tool (3:56)
Download and Install Microsoft SQL Server Enterprise (11:54)
Download and attach AdventureworksDW SampleDatabase (5:33)
Enabling SQL Server Agent (2:33)
Download Microsoft SQL Server Express (4:07)
Install Microsoft SQL Server Express (6:47)
Attach AdventureworksDW sample database to SQL Server Express (6:39)
Download and Install SQL Server Data Tools - SSDT (6:03)
Testing access to adventureworksDW sample database (1:46)
Configuring Database Settings For Data Warehouse Implementation (6:38)
Download and Install Visual Studio - Part 1 (7:47)
Download and Install Visual Studio - Part 2 (5:09)
Some Data Warehouse Terminologies
What is a Data Warehouse (3:06)
What is ETL (2:27)
DW vs EDW (1:54)
Database vs Data Warehouse (3:14)
Designing A Data Warehouse
Logical design of a data warehouse (4:14)
Physical design of a data warehouse - Part 1 (9:55)
Physical design of a data warehouse - Part 2 (11:42)
Designing Dimension Tables (10:14)
Big Data Concepts
What is big data (2:43)
What is High Volume Data (3:03)
What is High Variety Data (3:22)
What is High Velocity Data (3:10)
Creating an ETL Solution with SSIS
Introduction to ETL with SSIS (2:41)
Exploring data source - Part 1 (8:41)
Exploring data source - Part 2 (4:36)
Introduction to control flow - Part 1 (9:55)
Introduction to control flow - part 2 (8:21)
Implementing data flow - Part 1 (9:44)
Implementing data flow - Part 2 (9:32)
Debugging and Troubleshooting SSIS Package
Debugging SSIS Package - Part 1 (7:20)
Debugging SSIS Package - Part 2 (6:53)
Logging SSIS Package Events (10:18)
Handling Errors in an SSIS Package (8:00)
Implementing an Incremental ETL Process
Introduction to incremental ETL (5:36)
Extracting Modified Data - Part 1 (4:53)
Extracting Modified Data - Part 2 (7:47)
Extracting Modified Data - Part 3 (5:28)
Extracting Modified Data - Part 4 (7:19)
Loading Modified Data - Part 1 (7:31)
Loading Modified Data - Part 2 (7:25)
Working with other slowly changing dimension (7:38)
Deploying and Configuring SSIS
Integration services catalogs (8:19)
Deploying SSIS Solution (11:52)
Executing a package with SQL Server Agent (10:58)
Configuring advanced SSIS settings (5:19)
Enforcing Data Quality
Installing Data Quality Services (6:57)
Cleansing Data with Data Quality Services (11:27)
Using Data Quality Services to find duplicate data - Part 1 (11:11)
Using Data Quality Services to find duplicate data - Part 2 (9:07)
Using Data Quality Services in an SSIS Data Flow (9:34)
Consuming Data in a Data Warehouse
Introduction to Business Intelligence (4:15)
Using SQL Server Reporting Services with Data Warehouse - Part 1 (8:12)
Using SQL Server Reporting Services with Data Warehouse - Part 2 (7:00)
Data Analysis with SSAS - Part 1 (9:27)
Data Analysis with SSAS - Part 2 (5:13)
Attach AdventureworksDW sample database to SQL Server Express
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock