We may earn an affiliate commission when you visit our partners.
Raphael Asghar
This course is designed for those who want to learn how to create The pre requisite courses SQL Administration Part 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.
Register for this course and see more details by visiting:
OpenCourser.com/course/bo4rtq/sql
14 deals to help you save
We found 14 deals and offers that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Use code at checkout.
Valid until December 3
Cyber Monday
Develop career-changing skills with these steeply discounted courses.
Up to
85%
off
BFCMSALE24
Use code at checkout.
Only 21 hours left!
Black Friday
Develop career-changing skills with these steeply discounted courses.
Up to
85%
off
BFCMSALE24
Use code at checkout.
Valid until December 1
For new customers
Save when you purchase top courses. For new customers only.
Special Offer
UDEAFNULP2024
Valid for a limited time only
Future-proof your career
Access O'Reilly books, live events, courses, and more. Save with an annual subscription.
Take
15%
off
What's inside
Learning objective
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
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
Syllabus
At the end of this course, the student will be well versed in creating, configuring, managing and deploying SSIS packages for data transformation and migration
Read more
Syllabus
At the end of this course, the student will be well versed in creating, configuring, managing and deploying SSIS packages for data transformation and migration
Read more
Introduction
Install SQL 2016 if you have not
Down Load and Install SQL 2016
Correction
Download and Install Data Tools for SSRS
Download and install Sample database
What is SSIS
SQL to SQL Export Transformation
SQL to Excel Transformation
Control Flow and Data Flow
Create a SSIS Package
Truncate a Table
SQL to Flat File
FTP Site Transformation
Conditional Split Transformation
Truncate tables for conditional split
Derived Column Task Transformation
Character Map Transformation
Merge Transformation
Union All Transformation
Multicast Transformation
Aggregates Transformation
Term Extraction Transformation
Audit Transformation
Data Conversion Transformation
Backup Task Transformation
For Each Container Transformation
For Each Container Task Transformation
For Each Container Job
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Develops proficiency in configuring, managing, and deploying SQL Server Integration Services (SSIS) packages for a wide range of data transformation and migration scenarios
Covers various data transformation tasks, including data conversion, term extraction, migration to flat files, and various database sources and destinations
Taught by Raphael Asghar, a recognized expert in SQL Server Administration
Prerequisites include prior knowledge of SQL Server Administration, making it suitable for intermediate learners
Emphasizes hands-on labs and interactive materials to reinforce learning
Covers advanced topics such as foreach look container, term extraction transformation, and audit transformation
Save this course
Save SQL Server Administration: (SQL Server Integration Services) to your list so you can find it easily later:
Save
Save
Reviews summary
Sql server admin: lots of new features
learners say this SQL Server Administration course is great for learning lots of new features. Students add that the course is well taught.
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL Server Administration: (SQL Server Integration Services) with these
activities:
Review SQL Server basics
Show steps
This activity will ensure that you have the fundamental knowledge of SQL Server and its basics to actively participate in the course
Show steps
-
Read through the official Microsoft documentation on SQL Server
-
Take an online course or tutorial
-
Review your notes from a previous SQL Server course
Follow tutorials on creating SSIS packages
Show steps
This activity will provide you with hands-on experience in creating and configuring SSIS packages, which is a key skill for this course
Browse courses on
Data Transformation
Show steps
-
Find online tutorials or resources that provide step-by-step instructions on creating SSIS packages
-
Follow the instructions in the tutorials to create your own SSIS packages
-
Experiment with different settings and options to see how they affect the behavior of the packages
Complete practice exercises on SSIS
Show steps
This activity will help you reinforce your understanding of SSIS concepts and improve your problem-solving skills
Browse courses on
Data Transformation
Show steps
-
Find online practice exercises or quizzes on SSIS
-
Complete the exercises and check your answers to identify areas where you need more practice
-
Review the solutions to the exercises to learn from your mistakes and reinforce your understanding
Four other activities
Expand to see all activities and additional details
Show all seven activities
Mentor other students in the course
Show steps
This activity will allow you to reinforce your understanding of the course material while helping others
Show steps
-
Identify opportunities to help other students in the course
-
Provide guidance and support to other students
-
Answer questions and share your knowledge
Attend industry events and meetups
Show steps
This activity will allow you to connect with other professionals in the field and learn about the latest trends and technologies
Show steps
-
Identify industry events and meetups in your area
-
Attend these events and actively participate in discussions
-
Network with other attendees and exchange contact information
Attend workshops and training sessions
Show steps
This activity will allow you to learn from experts in the field and stay up-to-date on the latest technologies
Show steps
-
Identify workshops and training sessions that are relevant to your interests
-
Attend these events and actively participate in the sessions
-
Take notes and ask questions to enhance your learning
Contribute to open-source SSIS projects
Show steps
This activity will allow you to contribute to the community and gain valuable experience in working on real-world projects
Browse courses on
Data Transformation
Show steps
-
Identify open-source SSIS projects that you are interested in
-
Fork the project and make changes or add new features
-
Submit a pull request to merge your changes back into the main project
Review SQL Server basics
Show steps
This activity will ensure that you have the fundamental knowledge of SQL Server and its basics to actively participate in the course
Show steps
Show steps
Show steps
- Read through the official Microsoft documentation on SQL Server
- Take an online course or tutorial
- Review your notes from a previous SQL Server course
Follow tutorials on creating SSIS packages
Show steps
This activity will provide you with hands-on experience in creating and configuring SSIS packages, which is a key skill for this course
Browse courses on
Data Transformation
Show steps
Show steps
Show steps
- Find online tutorials or resources that provide step-by-step instructions on creating SSIS packages
- Follow the instructions in the tutorials to create your own SSIS packages
- Experiment with different settings and options to see how they affect the behavior of the packages
Complete practice exercises on SSIS
Show steps
This activity will help you reinforce your understanding of SSIS concepts and improve your problem-solving skills
Browse courses on
Data Transformation
Show steps
Show steps
Show steps
- Find online practice exercises or quizzes on SSIS
- Complete the exercises and check your answers to identify areas where you need more practice
- Review the solutions to the exercises to learn from your mistakes and reinforce your understanding
Four other activities
Expand to see all activities and additional details
Show all seven activities
Mentor other students in the course
Show steps
This activity will allow you to reinforce your understanding of the course material while helping others
Show steps
Show steps
Show steps
- Identify opportunities to help other students in the course
- Provide guidance and support to other students
- Answer questions and share your knowledge
Attend industry events and meetups
Show steps
This activity will allow you to connect with other professionals in the field and learn about the latest trends and technologies
Show steps
Show steps
Show steps
- Identify industry events and meetups in your area
- Attend these events and actively participate in discussions
- Network with other attendees and exchange contact information
Attend workshops and training sessions
Show steps
This activity will allow you to learn from experts in the field and stay up-to-date on the latest technologies
Show steps
Show steps
Show steps
- Identify workshops and training sessions that are relevant to your interests
- Attend these events and actively participate in the sessions
- Take notes and ask questions to enhance your learning
Contribute to open-source SSIS projects
Show steps
This activity will allow you to contribute to the community and gain valuable experience in working on real-world projects
Browse courses on
Data Transformation
Show steps
Show steps
Show steps
- Identify open-source SSIS projects that you are interested in
- Fork the project and make changes or add new features
- Submit a pull request to merge your changes back into the main project
Career center
Learners who complete SQL Server Administration: (SQL Server Integration Services) will develop knowledge and skills
that may be useful to these careers:
ETL Developer
ETL Developer
An ETL Developer designs and develops data transformation and migration solutions. This course provides the skills needed to become an ETL Developer, including how to design and implement SSIS packages for data transformation and migration. These skills are essential for ETL Developers who need to build and maintain data integration and migration systems.
Data Integration Specialist
Data Integration Specialist
A Data Integration Specialist designs and implements data integration solutions. This course provides the skills needed to become a Data Integration Specialist, including how to design and implement SSIS packages for data transformation and migration. These skills are essential for Data Integration Specialists who need to build and maintain data integration systems.
Data Warehouse Engineer
Data Warehouse Engineer
A Data Warehouse Engineer designs and builds data warehouses. This course may be useful to Data Warehouse Engineers who want to learn how to use SSIS to automate data transformation and migration tasks. These skills can be valuable for Data Warehouse Engineers who need to build and maintain data warehouses.
Database Administrator
Database Administrator
A Database Administrator installs, configures, and maintains databases. This course may be useful to Database Administrators as it teaches the skills needed to manage and deploy SSIS packages. These skills can be valuable for Database Administrators who need to automate data transformation and migration tasks.
Data Architect
Data Architect
A Data Architect designs and manages the architecture of data systems. This course may be useful to Data Architects who want to learn how to use SSIS to implement data transformation and migration solutions. These skills can be valuable for Data Architects who need to design and implement data integration and migration projects.
Data Engineer
Data Engineer
A Data Engineer designs, builds, and maintains data pipelines and infrastructure. This course may be useful to Data Engineers as it teaches the skills needed to design, configure, manage, and deploy SSIS packages for data transformation and migration. These skills can be valuable for Data Engineers who need to move data between different systems and databases.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst uses data to help organizations make better decisions. This course may be useful to Business Intelligence Analysts as it teaches the skills needed to design and implement data transformation and migration solutions using SSIS. These skills can be valuable for Business Intelligence Analysts who need to work with data from multiple sources and transform it into a format that can be used for analysis and reporting.
Data Analyst
Data Analyst
A Data Analyst gathers, interprets, and presents data to help organizations make better decisions. This course may be useful to Data Analysts as it teaches the skills needed to design and implement data transformation and migration solutions using SQL Server Integration Services (SSIS). These skills can be valuable for Data Analysts who need to work with data from multiple sources and transform it into a format that can be used for analysis and reporting.
Database Developer
Database Developer
A Database Developer designs and develops database applications. This course may be useful to Database Developers who want to learn how to use SSIS to automate data transformation and migration tasks. These skills can be valuable for Database Developers who work on projects that involve data integration and migration.
Data Scientist
Data Scientist
A Data Scientist uses data to build predictive models and solve business problems. This course may be useful to Data Scientists as it teaches the skills needed to design and implement data transformation and migration solutions using SSIS. These skills can be valuable for Data Scientists who need to work with data from multiple sources and transform it into a format that can be used for machine learning and data mining.
Cloud Engineer
Cloud Engineer
A Cloud Engineer designs, builds, and maintains cloud-based systems. This course may be useful to Cloud Engineers who want to learn how to use SSIS to automate data transformation and migration tasks to and from the cloud. These skills can be valuable for Cloud Engineers who work on projects that involve data integration and migration to and from the cloud.
Systems Engineer
Systems Engineer
A Systems Engineer designs, implements, and maintains computer systems. This course may be useful to Systems Engineers who want to learn how to use SSIS to automate data transformation and migration tasks. These skills can be valuable for Systems Engineers who work on projects that involve data integration and migration.
Systems Analyst
Systems Analyst
A Systems Analyst analyzes and designs computer systems. This course may be useful to Systems Analysts who want to learn how to use SSIS to automate data transformation and migration tasks. These skills can be valuable for Systems Analysts who work on projects that involve data integration and migration.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software applications. This course may be useful to Software Engineers who want to learn how to use SSIS to automate data transformation and migration tasks. These skills can be valuable for Software Engineers who work on projects that involve data integration and migration.
Information Technology Manager
Information Technology Manager
An Information Technology Manager plans and manages the IT infrastructure of an organization. This course may be useful to Information Technology Managers who want to learn how to use SSIS to automate data transformation and migration tasks. These skills can be valuable for Information Technology Managers who need to manage data integration and migration projects.
For more career information including salaries, visit:
OpenCourser.com/course/bo4rtq/sql
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Server Administration: (SQL Server Integration Services).
Provides a very deep dive into developing solutions with SSIS. It useful reference for developers who need to understand all the details of the SSIS platform.
Comprehensive guide to SQL Server Integration Services (SSIS). It covers all aspects of SSIS, from installation and configuration to data transformation and deployment. It is an excellent resource for those who want to learn how to use SSIS to build data integration solutions.
Comprehensive collection of best practices for all aspects of SSIS development.
Comprehensive guide to SQL Server Integration Services (SSIS). It covers all aspects of SSIS, from installation and configuration to data transformation and deployment. It is an excellent resource for those who want to learn how to use SSIS to build data integration solutions.
Provides a solid foundation for understanding and working with SSIS for data integration.
Contains a collection of interview questions and answers related to SSIS.
Introduces the basic concepts of SSIS, although it is significantly outdated for the current course.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/bo4rtq/sql
Share
Similar courses
Here are nine courses similar to
SQL Server Administration: (SQL Server Integration Services).
Mastering SQL Server 2016 Integration Services (SSIS)-Part 1
OpenCourser.com/course/a6c5a6/mastering
Mastering SQL Server 2016 Integration Services (SSIS)...
Most relevant
Optimizing a Data Warehouse on the Microsoft SQL Server Platform
OpenCourser.com/course/ur4qhy/optimizing
Optimizing a Data Warehouse on the Microsoft SQL Server...
Most relevant
Mastering ETL: Data Cleansing with SQL Server Integration Services
OpenCourser.com/course/21f5kn/mastering
Mastering ETL: Data Cleansing with SQL Server Integration...
Most relevant
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)
OpenCourser.com/course/m4fmto/become
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL...
Most relevant
SQL Server: Upgrading and Migrating to SQL Server 2016
OpenCourser.com/course/5hbceq/sql
SQL Server: Upgrading and Migrating to SQL Server 2016
Most relevant
Microsoft SQL Server Integration Services (SSIS) Training
OpenCourser.com/course/cfg6tq/microsoft
Microsoft SQL Server Integration Services (SSIS) Training
Most relevant
SQL Server Reporting Services Part 2 (SSRS)
OpenCourser.com/course/17jzh7/sql
SQL Server Reporting Services Part 2 (SSRS)
Most relevant
SQL Server Administration Part 3
OpenCourser.com/course/ser9ir/sql
SQL Server Administration Part 3
Most relevant
Designing SSIS Integration Solutions
OpenCourser.com/course/pjo9qy/designing
Designing SSIS Integration Solutions
Most relevant
Effort
5.5 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Good to know
Develops proficiency in configuring, managing, and deploying SQL Server Integration Services (SSIS) packages for a wide range of data transformation and migration scenarios
Covers various data transformation tasks, including data conversion, term extraction, migration to flat files, and various database sources and destinations
Taught by Raphael Asghar, a recognized expert in SQL Server Administration
Prerequisites include prior knowledge of SQL Server Administration, making it suitable for intermediate learners
Emphasizes hands-on labs and interactive materials to reinforce learning
Covers advanced topics such as foreach look container, term extraction transformation, and audit transformation
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser