Setup Menus in Admin Panel

Course 7: SQL Server Integration Services (SSIS)


     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
© Copyright by Rafacademy@2016