1 - Introduction to Data Warehousing
Overview of Data WarehousingConsiderations for a Data Warehouse SolutionLab : Exploring a Data Warehousing Solution
2 - Planning Data Warehouse Infrastructure
Considerations for Data Warehouse InfrastructurePlanning Data Warehouse HardwareLab : Planning Data Warehouse Infrastructure
3 - Designing and Implementing a Data Warehouse
Data Warehouse Design OverviewDesigning Dimension TablesDesigning Fact TablesPhysical Design for a Data WarehouseLab : Implementing a Data Warehouse
4 - Creating an ETL Solution with SSIS
Introduction to ETL with SSISExploring Data SourcesImplementing Data FlowLab : Implementing Data Flow in an SSIS Package
5 - Implementing Control Flow in an SSIS Package
Introduction to Control FlowCreating Dynamic PackagesUsing ContainersManaging ConsistencyLab : Implementing Control Flow in an SSIS PackageLab : Using Transactions and Checkpoints
6 - Debugging and Troubleshooting SSIS Packages
Debugging an SSIS PackageLogging SSIS Package EventsHandling Errors in an SSIS PackageLab : Debugging and Troubleshooting an SSIS Package
7 - Implementing a Data Extraction Solution
Planning Data ExtractionExtracting Modified DataLab : Extracting Modified Data
8 - Loading Data into a Data Warehouse
Planning Data LoadsUsing SSIS for Incremental LoadsUsing Transact-SQL Loading TechniquesLab : Loading a Data Warehouse
9 - Enforcing Data Quality
Introduction to Data QualityUsing Data Quality Services to Cleanse DataUsing Data Quality Services to Cleanse DataLab : Cleansing Data
10 - Master Data Services
Introduction to Master Data ServicesImplementing a Master Data Services ModelManaging Master DataCreating a Master Data HubLab : Implementing Master Data Services
11 - Extending SQL Server Integration Services
Using Scripts in SSISUsing Custom Components in SSISLab : Using Custom Scripts
12 - Deploying and Configuring SSIS Packages
Overview of SSIS DeploymentDeploying SSIS ProjectsPlanning SSIS Package ExecutionLab : Deploying and Configuring SSIS Packages
13 - Consuming Data in a Data Warehouse
Introduction to Business IntelligenceEnterprise Business IntelligenceSelf-Service BI and Big DataLab : Using a Data Warehouse
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is intended for database professionals who need to create and support a data warehousing solution. Primary responsibilities include:
Implementing a data warehouse.
Developing SSIS packages for data extraction, transformation, and loading.
Enforcing data integrity by using Master Data Services.
Cleansing data by using Data Quality Services.