你将学到什么
Deciding on full or incremental loading
Isolating ETL data
Creating an ETL script
ETL abstraction layers
The design environment
Control flows
Data sources
Data transformations
Data destinations
Precedence constraints
Connection managers
Execute SQL tasks
Progress/execution results
Resetting destination database
Data flows
Data flow paths
Error output paths
Configuring data sources and destinations
Executing SSIS packages
Deploying SSIS packages
课程概况
Microsoft SQL Server Integration Services (SSIS) features graphical tools and wizards for:
building and debugging packages
tasks for performing workflow functions
executing SQL statements
data sources and destinations for extracting and loading data
transformations for cleaning, aggregating, merging, and copying data
In this computer science course, you’ll extract data from a wide variety of data sources, such as files and relational data sources, perform data integration and transformation solutions, and load data into single or multiple destinations. You will solve complex business problems using best practices and troubleshooting techniques.
课程大纲
0 | Module 0 - Start Here
Welcome to DAT217x: Implementing ETL with SQL Server Integration Services (SSIS)
Setting Up Your Lab Environment in Azure
1 | Module 1 - ETL Processing
ETL Overview
ETL Tools
Data Sources and Destinations
Creating Example Databases
Module Assessment
Module Summary
2 | Module 2 - ETL with SQL Programming
ETL Scripts
Transformations
Implementing ETL with SQL Objects
Lab | Programming an ETL Process with SQL
Module Assessment
Module Summary
3 | Module 3 - ETL Processing with SSIS
Creating SSIS Projects
Programming SSIS Packages
Execute SQL Tasks
Implementing SSIS Packages
Lab | Creating an ETL Process with SSIS
Module Assessment
Module Summary
4 | Module 4 - SSIS Data Flows
Creating Data Flows
Data Flow Transformations
Performance Options
Lab | Creating an SSIS ETL Package Using Data Flow Tasks
Module Assessment
Module Summary
5 | Module 5 - Deployment and Troubleshooting
Error Handling
Deployment
Module Assessment
Module Summary
6 | Module 6 - Final
Final Assessment
Bonus Video
Post-Course Survey
预备知识
A familiarity with Basic SQL Query and Transactional statements (select, insert, update, delete). Ability to write and execute statements using SQL Server Management Studio. A basic understanding of the Business Intelligence process.
