Setup Menus in Admin Panel

Home
Course
Course 7: SQL Server Integration Services (SSIS)

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

top

© Copyright by Rafacademy@2016