SQL Server Administration: (SQL Server Integration Services)

Discover how to create SSIS packages for data migration in this friendly and simple course! Perfect for learners of all levels.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course is all about making data migration a breeze with SSIS packages! You’ll start from the basics and end up with skills that employers love.

Key Points

  • You'll learn to create SSIS packages for data migration.
  • Hands-on experience with data extraction, transformation, and loading.
  • Pre-requisites include SQL Administration and T-SQL courses.

Learning Outcomes

  • Design and configure SSIS packages effectively.
  • Manage and deploy packages across different platforms.
  • Understand key data transformation tasks including conversion and migration.

About This Course

Learn how to create SSIS packages that allow migration of data from source to destination

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.

  • 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

Instructor

Profile photo of Raphael Asghar
Raphael Asghar

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...

Review
4.9 course rating
4K ratings
ui-avatar of Mallika V
Mallika V.
4.5
6 months ago

very nice

  • Helpful
  • Not helpful
ui-avatar of Syed Rafi Ullah Syed
Syed R. U. S.
5.0
9 months ago

Good learning

  • Helpful
  • Not helpful
ui-avatar of Srinivasa Reddibathuni
Srinivasa R.
5.0
9 months ago

Great Course.

  • Helpful
  • Not helpful
ui-avatar of Chris Wotton
Chris W.
3.0
10 months ago

The content is what I was looking for, but the presentation is long winded and full of mistakes.

  • Helpful
  • Not helpful
ui-avatar of Wayne Jiang
Wayne J.
3.5
11 months ago

Good lessons for beginners. Keeps repeating "again" makes it annoying.

  • Helpful
  • Not helpful
ui-avatar of Amisha Jauhri
Amisha J.
5.0
1 year ago

good

  • Helpful
  • Not helpful
ui-avatar of Driss Zarhouni
Driss Z.
5.0
1 year ago

Formation très outils

  • Helpful
  • Not helpful
ui-avatar of DWARAMPUDI PRASANNA
Dwarampudi P.
5.0
1 year ago

good

  • Helpful
  • Not helpful
ui-avatar of Sagar Dahibhate
Sagar D.
4.5
1 year ago

Very Nice course for SSIS beginners with nice demonstrations.

  • Helpful
  • Not helpful
ui-avatar of John Bevilaqua
John B.
4.0
1 year ago

There are some very blatant errors in some of the packages as in the case where he tries to calculate the current age of a person but he neglects to check if their birthdate has been reached yet in the most current year.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses