SQL Server 2012/2014: Advanced Course
Module 1: Designing and Implementing a Data Warehouse
- Logical Design for a Data Warehouse
- Physical design for a Data Warehouse
Module 2: Creating an ETL Solution with SSIS
- Introduction to ETL with SSIS
- Exploring Data Sources
- Implementing Data Flow
Module 3: Implementing Control Flow in an SSIS Package
- Introduction to Control Flow
- Creating Dynamic Packages
- Using Containers
- Managing Consistency
Module 4: Debugging and Troubleshooting SSIS Packages
- Debugging an SSIS Package
- Logging SSIS Package Events
- Handling Errors in an SSIS Package
Module 5: Implementing an Incremental ETL Process
- Introduction to Incremental ETL
- Extracting Modified Data
- Loading Modified data
Module 6: Using Master Data Services
- Master Data Services Concepts
- Implementing a Master Data Services Model
- Managing Master Data
- Creating a Master Data Hub
Module 7: Extending SQL Server Integration Services
- Using Scripts in SSIS
- Using Custom Components in SSIS
Module 8: Deploying and Configuring SSIS Packages
- Overview of SSIS Deployment
- Deploying SSIS Projects
- Planning SSIS Package Execution
Module 9: Enforcing Data Quality
- Introduction to Data Quality
- Using Data Quality Services to Cleanse Data
- Using Data Quality Services to Match data
Module 10: Introduction to Data Warehousing
- Overview of Data Warehousing
- Considerations for a Data Warehouse Solution
Module 11: Data Warehouse Hardware Considerations
- Considerations for building a Data Warehouse
- Data Warehouse Reference Architectures and Appliances
Module 12: Consuming Data in a Data Warehouse
- Introduction to Business Intelligence
- Introduction to Reporting
- An Introduction to Data Analysis