SQL Server Integration Services (SSIS)
Become an SSIS Expert: Develop Real-World ETL Workflows. Deep Dive into SSIS Architecture, Components & Best Practices.
1.00 (1 reviews)
1,006
students
30 hours
content
Mar 2025
last update
$54.99
regular price
What you will learn
Understand the core concepts of ETL (Extract, Transform, Load) and the role of SSIS in data integration.
Describe the SSIS architecture and how it integrates with the SQL Server environment.
Identify and explain the key components of an SSIS package, including Control Flow, Data Flow, and Connection Managers.
Configure and utilize various data sources in SSIS, such as OLEDB, flat files, and Excel.
Configure and utilize various data destinations in SSIS, including OLEDB, flat files, and Excel.
Apply basic transformations like data conversion, derived column, and copy column to manipulate data.
Implement conditional logic in SSIS packages using transformations like conditional split.
Perform data aggregation and sorting using transformations like Aggregate and Sort.
Combine data from different sources using Merge Join, Merge, and Union All transformations.
Utilize advanced transformations like Lookup, Row Sampling, Percentage Sampling, and OLE DB Command for complex data manipulation.
Explain the purpose and applications of the Multi-Cast transformation.
Utilize variables and parameters in SSIS packages to create dynamic and configurable workflows.
6372443
udemy ID
1/2/2025
course created date
2/8/2025
course indexed date
Bot
course submited by