SQL Server Administration: (SQL Server Integration Services)
What you'll learn
- At the end of this course, the student will be able to design, configure, manage and deploy SSIS packages that migrate data from source to destination using many platforms
Course content
- Preview05:12
- Preview13:49
- 13:49Down Load and Install SQL 2016
- 01:12Correction
- 08:28Download and Install Data Tools for SSRS
- 12:19Download and install Sample database
- 14:28What is SSIS
- 13:34SQL to SQL Export Transformation
- 10:52SQL to Excel Transformation
- 11:34Control Flow and Data Flow
- 18:14Create a SSIS Package
- 10:09Truncate a Table
- 14:15SQL to Flat File
- 10:32FTP Site Transformation
- 24:53Conditional Split Transformation
- 04:54Truncate tables for conditional split
- 12:11Derived Column Task Transformation
- 08:26Character Map Transformation
- 13:25Merge Transformation
- 05:02Union All Transformation
- 12:36Multicast Transformation
- 15:40Aggregates Transformation
- 10:09Term Extraction Transformation
- 09:29Audit Transformation
- 14:35Data Conversion Transformation
- 09:07Backup Task Transformation
- 14:47For Each Container Transformation
- 17:06For Each Container Task Transformation
- 09:01For Each Container Job
Requirements
- The pre requisite courses SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended. All software and SQL scripts and documents will be provided via email zip file
Description
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 and shows the student how to extract, transform and load data to various destinations. The pre requisite courses SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended. Those that are not familiar with SQL Server Administration should not take this course. The course covers data transformation tasks such as, data conversion, term extraction, migration to flat files, various databases sources and destinations, FTP site tasks, and foreach look container that allows the SSIS package to dump multiple files from source to destination. Those that finish this course will have the necessary skills that recruiters are looking for to fill SQL Server Administration jobs.
Who this course is for:
- 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 and shows the student how to extract, transform and load data to various destinations. The pre requisite courses SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended. Those that are not familiar with SQL Server Administration should not take this course.
Instructor
![Raphael Asghar](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.5 Instructor Rating
- 18,751 Reviews
- 111,783 Students
- 25 Courses
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.