Learn how to design and implement an enterprise data warehouse, with Microsoft SQL Server.
Overview
Syllabus
Introduction
- Welcome
- What you should know
- Using the exercise files
- Finding and downloading SQL Server 2012 trial edition
- Installing SQL Server 2012 trial edition
- Finding and installing the sample data
- Overview of data warehousing
- Understanding the differences between typical databases and data warehouses
- Implementing a data warehouse using a SQL database engine
- Logical design for a data warehouse
- Choosing between star and snowflake schema design techniques
- Physical design for a data warehouse
- Considerations for building a data warehouse
- Data warehouse reference architectures
- Appliances and big data
- Introduction to ETL with SSIS
- Exploring source data
- Introduction to control flow
- Implementing data flow
- Debugging an SSIS package
- Logging SSIS package events
- Handling errors in an SSIS package
- Introduction to incremental ETL
- Extracting modified data
- Loading modified data
- Working with slowly changing dimensions
- Installing and maintaining SSIS components
- Deploying SSIS solutions
- Using SQL Server Agent to execute an ETL package
- Configuring advanced SSIS settings
- Installing Data Quality Services
- Using Data Quality Services to cleanse data
- Using Data Quality Services to find duplicate data
- Utilizing Data Quality Services in an SSIS data flow
- Introduction to business intelligence
- Using Reporting Services with a data warehouse
- Introduction to data analysis with SQL Server Analysis Services (SSAS)
- Next steps
Taught by
Martin Guidry