Implementing ETL with SQL Server Integration Services
Offered By: Microsoft via edX
Course Description
Overview
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.
Syllabus
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
Taught by
Randal Root and Cari Mason
Tags
Related Courses
Data Preparation (Import and Cleaning) for PythonA Cloud Guru Python aplicado a la Ciencia de Datos
Universidad Anáhuac via edX Google Data Analytics (PT)
Google via Coursera Analisis Data dengan Pemrograman R
Google via Coursera Análisis de datos con programación en R
Google via Coursera