We may earn an affiliate commission when you visit our partners.
Emilio Melo
SSIS is the main on-premises ETL (Extract, Transform, and Load) tool from Microsoft, and it's heavily utilized for data engineering on SQL Server. In this course, you'll learn how to install and configure SSIS, and develop ETL packages with it.
Data engineering is in the backbone of advanced analytics, business intelligence, and machine learning activities, and is also one of the most exciting and rewarding professions in the IT industry today.
is the main SQL Server tool for achieving ETL (Extract, Transform, and Load) goals, whether you are:
This course is no longer available. Find something similar by browsing:
SSIS
ETL
Data Engineering
Data Transformation
Data Extraction
Data Loading
SQL Server
Register for this course and see more details by visiting:
OpenCourser.com/course/0msa6d/extracting
What's inside
Syllabus
Course Overview
Understanding the SSIS Interface
Building Your First SSIS Package
Defining Common Control Flow Operations
Read more
Syllabus
Course Overview
Understanding the SSIS Interface
Building Your First SSIS Package
Defining Common Control Flow Operations
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Data engineering mastery is in high demand
Introduces the industry-standard ETL tool, SSIS
Covers core SSIS concepts and operations
Builds a strong foundation for ETL tasks
Taught by industry professional, Emilio Melo
Requires hands-on practice for effective learning
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Ssis fundamentals for data engineering
According to students, this course provides a solid foundation in SSIS, making it excellent for beginners transitioning into data engineering roles. Learners praise the clear explanations, step-by-step approach, and practical examples, which help in building complex ETL packages. However, a common concern is that the course content and associated environment setup feel somewhat dated, with videos showing older UI versions. While strong on fundamentals, some reviewers note it lacks advanced topics for those seeking deeper dives.
Ideal for new SSIS users, offers a strong foundational understanding.
"Overall, a very good introduction to SSIS."
"This course took me from zero knowledge of SSIS to being able to build complex ETL packages for my work."
"Excellent course! As a data analyst looking to expand my ETL skills, this was exactly what I needed."
"Good for absolute beginners, but not for intermediate users looking to deepen their knowledge."
Instructor provides clear explanations and practical demos.
"The instructor explains concepts clearly and provides practical examples. I found the hands-on demos particularly useful for understanding the data flow tasks."
"Absolutely fantastic! The step-by-step approach and clear explanations made everything easy to follow. The instructor's pacing is perfect."
"As a data analyst looking to expand my ETL skills, this was exactly what I needed. The instructor demystifies SSIS and provides clear, actionable steps."
Some learners desired more in-depth coverage and advanced techniques.
"My only minor gripe is that some parts felt a little rushed, and I wish there were more advanced topics covered."
"For those already familiar with other ETL tools, it might feel a bit slow initially, and deeper dives into performance tuning or error handling would be beneficial."
"I found it a bit basic, given my prior experience with other ETL tools."
Course materials and associated environment need updating.
"The course covers the basics well, but it feels somewhat dated. SSIS itself has evolved, and some of the UI elements shown in the videos don't quite match the latest versions..."
"I struggled with this course. The content seemed okay, but the environment setup was a nightmare. The videos use an older version of SQL Server Management Studio and SSIS..."
"My suggestion for improvement would be to update the material for the latest SSIS versions, as some interfaces have changed."
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 Extracting and Transforming Data in SSIS with these
activities:
Review SSIS Concepts
Show steps
Refreshes knowledge of SSIS concepts, providing a stronger foundation for the course.
Browse courses on
SSIS
Show steps
-
Review SSIS architecture and components.
-
Recall ETL process and how SSIS fits in.
-
Go over data flow and control flow concepts.
Azure Data Factory for ETL
Show steps
Expands knowledge of ETL by exploring Azure Data Factory, a cloud-based ETL service.
Browse courses on
Azure Data Factory
Show steps
-
Create an Azure Data Factory pipeline.
-
Use data flow activities for data transformations.
-
Schedule and monitor the pipeline.
Hands-on SSIS Package Development
Show steps
Provides hands-on practice developing SSIS packages, reinforcing the concepts learned in the course.
Browse courses on
SSIS Packages
Show steps
-
Create a simple SSIS package with data flow and control flow.
-
Implement transformations and data manipulations.
-
Debug and troubleshoot the package.
-
Optimize the package for performance.
One other activity
Expand to see all activities and additional details
Show all four activities
ETL Project: Design and Implement
Show steps
Challenges students to apply their knowledge by designing and implementing a complete ETL project, deepening their understanding.
Browse courses on
Data Warehousing
Show steps
-
Define the ETL requirements and scope.
-
Design the data model and SSIS package.
-
Implement the SSIS package.
-
Test and deploy the ETL solution.
Review SSIS Concepts
Show steps
Refreshes knowledge of SSIS concepts, providing a stronger foundation for the course.
Browse courses on
SSIS
Show steps
Show steps
Show steps
- Review SSIS architecture and components.
- Recall ETL process and how SSIS fits in.
- Go over data flow and control flow concepts.
Azure Data Factory for ETL
Show steps
Expands knowledge of ETL by exploring Azure Data Factory, a cloud-based ETL service.
Browse courses on
Azure Data Factory
Show steps
Show steps
Show steps
- Create an Azure Data Factory pipeline.
- Use data flow activities for data transformations.
- Schedule and monitor the pipeline.
Hands-on SSIS Package Development
Show steps
Provides hands-on practice developing SSIS packages, reinforcing the concepts learned in the course.
Browse courses on
SSIS Packages
Show steps
Show steps
Show steps
- Create a simple SSIS package with data flow and control flow.
- Implement transformations and data manipulations.
- Debug and troubleshoot the package.
- Optimize the package for performance.
One other activity
Expand to see all activities and additional details
Show all four activities
ETL Project: Design and Implement
Show steps
Challenges students to apply their knowledge by designing and implementing a complete ETL project, deepening their understanding.
Browse courses on
Data Warehousing
Show steps
Show steps
Show steps
- Define the ETL requirements and scope.
- Design the data model and SSIS package.
- Implement the SSIS package.
- Test and deploy the ETL solution.
Career center
Learners who complete Extracting and Transforming Data in SSIS will develop knowledge and skills
that may be useful to these careers:
Data Engineer
Data Engineer
A Data Engineer is responsible for designing and building the infrastructure that allows data to be processed, transformed, and loaded into data stores. This course provides foundational knowledge of how to use SSIS, a leading ETL tool, to execute these tasks.
Database Administrator
Database Administrator
A Database Administrator is responsible for the day-to-day operations of a database. This includes managing user access, performance tuning, and data backups. This course can help Database Administrators gain valuable experience with SSIS, a tool that can be used to automate many of these tasks.
Data Analyst
Data Analyst
A Data Analyst is responsible for collecting, cleaning, and analyzing data to identify trends and patterns. This course can help Data Analysts build a strong foundation in SSIS, a tool that can be used to streamline the data transformation process.
Software Engineer
Software Engineer
A Software Engineer is responsible for designing, developing, and maintaining software applications. This course can help Software Engineers gain valuable experience with SSIS, a tool that can be used to integrate data from multiple sources into a single application.
Business Intelligence Analyst
Business Intelligence Analyst
A Business Intelligence Analyst is responsible for using data to identify opportunities and solve problems for businesses. This course can help Business Intelligence Analysts build a strong foundation in SSIS, a tool that can be used to automate many of the data processing and transformation tasks that are essential for effective business intelligence.
Data Scientist
Data Scientist
A Data Scientist is responsible for using data to develop predictive models and identify trends. This course can help Data Scientists build a strong foundation in SSIS, a tool that can be used to automate the data processing and transformation tasks that are essential for effective data science.
Information Technology Manager
Information Technology Manager
An Information Technology Manager is responsible for planning, implementing, and managing the technology infrastructure of an organization. This course can help Information Technology Managers gain valuable experience with SSIS, a tool that can be used to improve the efficiency and effectiveness of data management.
Systems Analyst
Systems Analyst
A Systems Analyst is responsible for analyzing and designing computer systems. This course can help Systems Analysts build a strong foundation in SSIS, a tool that can be used to improve the efficiency and effectiveness of data management systems.
Database Architect
Database Architect
A Database Architect is responsible for designing and managing the structure of databases. This course can help Database Architects gain valuable experience with SSIS, a tool that can be used to automate many of the data processing and transformation tasks that are essential for effective database design and management.
ETL Developer
ETL Developer
An ETL Developer is responsible for designing and developing ETL (Extract, Transform, and Load) processes. This course provides foundational knowledge of how to use SSIS, a leading ETL tool, to execute these tasks.
Data Integration Specialist
Data Integration Specialist
A Data Integration Specialist is responsible for integrating data from multiple sources into a single, unified view. This course can help Data Integration Specialists build a strong foundation in SSIS, a tool that can be used to automate many of the data processing and transformation tasks that are essential for effective data integration.
Data Management Consultant
Data Management Consultant
A Data Management Consultant is responsible for helping organizations improve their data management practices. This course can help Data Management Consultants gain valuable experience with SSIS, a tool that can be used to improve the efficiency and effectiveness of data management.
Business Analyst
Business Analyst
A Business Analyst is responsible for analyzing business needs and developing solutions to meet those needs. This course can help Business Analysts gain valuable experience with SSIS, a tool that can be used to automate many of the data processing and transformation tasks that are essential for effective business analysis.
Data Warehouse Architect
Data Warehouse Architect
A Data Warehouse Architect is responsible for designing and managing data warehouses. This course can help Data Warehouse Architects gain valuable experience with SSIS, a tool that can be used to automate many of the data processing and transformation tasks that are essential for effective data warehousing.
Data Governance Specialist
Data Governance Specialist
A Data Governance Specialist is responsible for developing and implementing data governance policies and procedures. This course can help Data Governance Specialists gain valuable experience with SSIS, a tool that can be used to automate many of the data processing and transformation tasks that are essential for effective data governance.
For more career information including salaries, visit:
OpenCourser.com/course/0msa6d/extracting
Reading list
We've selected nine 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
Extracting and Transforming Data in SSIS.
Step-by-step guide to SQL Server Integration Services (SSIS) 2012. It provides a comprehensive overview of SSIS, from the basics of creating and managing packages to more advanced techniques like data transformations and error handling.
Save
Comprehensive guide to SQL Server Integration Services (SSIS) 2008. It provides a detailed overview of SSIS, from the basics of creating and managing packages to more advanced topics like data transformations and error handling.
Provides a comprehensive overview of the ETL (Extract, Transform, and Load) process. It covers everything from the basics of data extraction and transformation to advanced techniques like data mining and data warehousing.
Provides a set of design patterns for data integration. It covers a wide range of topics, from data extraction and transformation to data quality and data governance.
Comprehensive guide to data integration with Microsoft SQL Server. It covers everything from the basics of data extraction and transformation to advanced techniques like data mining and data warehousing.
Comprehensive guide to SQL Server 2008 Integration Services (SSIS). It provides a detailed overview of SSIS, from the basics of creating and managing packages to more advanced topics like data transformations and error handling.
Save
Comprehensive guide to SQL Server 2005 Integration Services (SSIS). It provides a detailed overview of SSIS, from the basics of creating and managing packages to more advanced topics like data transformations and error handling.
Provides a set of best practices for data integration. It covers a wide range of topics, from data extraction and transformation to data quality and data governance.
Comprehensive guide to data integration with Microsoft SQL Server. It covers everything from the basics of data extraction and transformation to advanced techniques like data mining and data warehousing.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/0msa6d/extracting
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
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 - 2025 OpenCourser