We may earn an affiliate commission when you visit our partners.
Extracting and Transforming Data in SSIS
Emilio Melo
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.
Read more
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.
Read more
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:
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
Integrating Advanced Control Flow Operations
Transforming Data with Data Flow Operations
Piping Data with Data Flow Operations
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save Extracting and Transforming Data in SSIS to your list so you can find it easily later:
Save
Save
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
Here are nine courses similar to
Extracting and Transforming Data in SSIS.
Designing SSIS Integration Solutions
OpenCourser.com/course/pjo9qy/designing
Designing SSIS Integration Solutions
Most relevant
Mastering SQL Server 2016 Integration Services (SSIS)-Part 1
OpenCourser.com/course/a6c5a6/mastering
Mastering SQL Server 2016 Integration Services (SSIS)...
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
Extract, Transform & Load using Python
OpenCourser.com/course/1xfyzs/extract
Extract, Transform & Load using Python
Most relevant
Building ETL and Data Pipelines with Bash, Airflow and Kafka
OpenCourser.com/course/01t16b/building
Building ETL and Data Pipelines with Bash, Airflow and...
Most relevant
Data Engineering Capstone Project
OpenCourser.com/course/c936bx/data
Data Engineering Capstone Project
Most relevant
Building Batch Data Pipelines on Google Cloud
OpenCourser.com/course/ah5op6/building
Building Batch Data Pipelines on Google Cloud
Most relevant
Data Analytics and Databases on AWS
OpenCourser.com/course/97h4k2/data
Data Analytics and Databases on AWS
Most relevant
Microsoft SQL Server Integration Services (SSIS) Training
OpenCourser.com/course/cfg6tq/microsoft
Microsoft SQL Server Integration Services (SSIS) Training
Most relevant
Time
166 hours
Level
Intermediate
Via
Pluralsight
Instructor
Emilio Melo
Language
English
Good to know
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
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