Course 7: SQL Server Integration Services (SSIS)
7 STUDENTS ENROLLED
This course is designed for those who want to learn how to create SQL SSIS packages that migrate data from various heterogeneous sources to a central point; while at the same time it will show the student how to extract, transform and load data to various destinations. The course will cover the following:
- Prerequisite courses: SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended
- Creating SSIS packaged from scratch
- Executing Data transformation tasks such as, data conversion, term extraction, for each look container
- Connecting to various databases sources and destinations
- Examples of movement of data from heterogeneous environments and much more
Course Curriculum
1. SSIS Scripts and Docs | |||
SSIS Scripts and Docs | 00:00:00 | ||
2. Table of Contents | |||
Table of Contents | 00:00:00 | ||
3. Install SQL 2016 if you have not | |||
Install SQL 2016 if you have not | 00:00:00 | ||
4. Download Site for SQL 2016 Server | |||
Download Site for SQL 2016 Server | 00:00:00 | ||
5. Correction | |||
Correction | 00:00:00 | ||
6. Data Tools | |||
Data Tools | 00:00:00 | ||
7. Sample Database | |||
Sample Database | 00:00:00 | ||
8. What is SQL Server Integration Services | |||
What is SQL Server Integration Services | 00:00:00 | ||
9. SQL to SQL Export | |||
SQL to SQL Export | 00:00:00 | ||
10. SQL to Excel | |||
SQL TO Excel | 00:00:00 | ||
11. Control Flow vs Data Flow | |||
Control Flow vs Data Flow | 00:00:00 | ||
12. Create a Simple Package Using SSIS | |||
Create a Simple Package Using SSIS | 00:00:00 | ||
13. Truncate Table | |||
Truncate Table | 00:00:00 | ||
14. SQL to Flat File | |||
SQL to Flat File | 00:00:00 | ||
15. FTP | |||
FTP | 00:00:00 | ||
16. Conditional Split | |||
Conditional Split | 00:00:00 | ||
17. Conditional Split Truncate Table | |||
Conditional Split Truncate Table | 00:00:00 | ||
18. Derived Columns | |||
Derived Columns | 00:00:00 | ||
19. Character Map Transformation | |||
Character Map Transformation | 00:00:00 | ||
20. Merge Transformation | |||
Merge Transformation | 00:00:00 | ||
21. Union All | |||
Union All | 00:00:00 | ||
22. Multicast Transformation | |||
Multicast Transformation | 00:00:00 | ||
23. Aggregate Transformation | |||
Aggregate Transformation | 00:00:00 | ||
24. Term Extraction | |||
Term Extraction | 00:00:00 | ||
25. Audit Transformation | |||
Audit Transformation | 00:00:00 | ||
26. Data Conversion | |||
Data Conversion | 00:00:00 | ||
27. Backup Task | |||
Backup Task | 00:00:00 | ||
28. For Each Loop Container | |||
For Each Loop Container | 00:00:00 | ||
29. For Each Container Task | |||
For Each Container Task | 00:00:00 | ||
30. Foreach Loop Job | |||
Foreach Loop Job | 00:00:00 |