Integration Services Fundamentals Part 2 from Pluralsight

This course is for business intelligence developers and database professionals responsible for moving, manipulating, and integrating data and assumes completion of the Integration Services Fundamentals Part 1 course.

If you need to move, manipulate, and integrate data across multiple platforms, you need to know how to use Integration Services effectively. In this course, Integration Services Fundamentals Part 2, you continue building on concepts introduced in the Integration Services Fundamentals Part 1 course and you’ll gain the ability to build packages that achieve your data integration goals. First, you’ll explore the control flow tasks and data flow components not covered in Part 1. Next, you’ll discover how to use scripting to perform operations not covered by the built-in components. Finally, you’ll learn how to debug packages and handle potential package execution problems. When you’re finished with this course, you’ll have the skills and knowledge of Integration Services needed to develop, manage, and maintain packages.

What's inside

Syllabus

Course Overview

Control Flow Tasks

Data Flow Sources and Destinations

Data Flow Transformations

Integration Services for Business Intelligence Solutions

Scripts

Debugging SSIS Packages

Package Reliability

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

This course is designed for business intelligence developers and database professionals who need to move, manipulate, and integrate data

Learners of this course should have already completed the Integration Services Fundamentals Part 1 course

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 Integration Services Fundamentals Part 2 with these activities:

Review Concepts of Data Integration

Show steps

Review basic concepts of data integration to refresh your understanding and prepare for advanced topics covered in this course.

Browse courses on Database Integration

Show steps

Summarize key data integration principles
Identify different types of data sources and their characteristics
Describe the process of data mapping and transformation

Review SQL syntax and concepts

Show steps

Brush up on the fundamentals of SQL to ensure a strong foundation for the course.

Browse courses on SQL

Show steps

Review SQL data types, operators, and functions.
Practice writing basic SELECT, INSERT, UPDATE, and DELETE queries.

Participate in Online Discussion Forums

Show steps

Engage with fellow learners in online forums to share knowledge, clarify concepts, and gain diverse perspectives.

Show steps

Join the course discussion forum
Ask questions and share insights
Participate in threaded discussions

Ten other activities

Expand to see all activities and additional details

Show all 13 activities

Explore SSIS tutorials on Pluralsight

Show steps

Supplement your learning with additional resources to enhance your understanding of SSIS concepts.

Show steps

Search for SSIS tutorials on Pluralsight.
Watch and follow along with the tutorials.

Practice Control Flow Tasks

Show steps

Engage in hands-on exercises to solidify your understanding of control flow tasks in Integration Services.

Browse courses on Data Flow

Show steps

Create a new Integration Services project
Add and configure various control flow tasks
Test and debug the control flow

Explore Data Flow Transformations

Show steps

Practice using different data flow transformations to cleanse, manipulate, and prepare data for integration.

Show steps

Import data from various sources
Apply data transformation tasks
Preview and validate the transformed data

Complete SSIS practice exercises

Show steps

Engage in hands-on practice to reinforce your understanding and skills in SSIS.

Show steps

Find online exercises or create your own data integration scenarios.
Develop and execute SSIS packages to solve the exercises.
Analyze the results and identify areas for improvement.

Start a personal project using SSIS

Show steps

Embark on a self-directed project to deepen your understanding and application of SSIS in a practical context.

Show steps

Define the scope and goals of your project.
Gather and prepare the necessary data.
Design and implement an SSIS solution.

Follow Tutorials on Scripting for Integration Services

Show steps

Supplement your learning by exploring tutorials and examples on how to use scripting to enhance your Integration Services packages.

Browse courses on Scripting

Show steps

Identify scenarios where scripting is necessary
Learn different scripting languages and techniques
Practice implementing scripts in your packages

Attend an SSIS workshop or conference

Show steps

Network with experts, learn about industry best practices, and gain valuable insights to enhance your SSIS knowledge.

Show steps

Research upcoming SSIS workshops or conferences.
Register and attend the event.
Actively engage with speakers and attendees.

Build a data integration package using SSIS

Show steps

Apply your knowledge and skills to create a practical solution for a real-world data integration challenge.

Show steps

Identify a data integration problem or opportunity.
Design and develop an SSIS package to address the problem.
Test and deploy the package to a production environment.

Mentor or assist other students with SSIS

Show steps

Strengthen your understanding by helping others, while reinforcing your own knowledge and gaining valuable experience.

Show steps

Identify opportunities to assist peers or junior members in the SSIS community.
Provide guidance and support on SSIS concepts and techniques.
Review and provide feedback on others' SSIS solutions.

Contribute to open-source SSIS projects

Show steps

Engage with the SSIS community and make tangible contributions to the open-source ecosystem.

Show steps

Find open-source SSIS projects on platforms like GitHub.
Identify areas where you can add value.
Create pull requests and collaborate with project maintainers.

Career center

Learners who complete Integration Services Fundamentals Part 2 will develop knowledge and skills that may be useful to these careers:

Data Integration Engineer

Data Integration Engineers build and maintain the infrastructure that supports data integration. They use their knowledge of data integration and analysis to help organizations get the most out of their data. The Integration Services Fundamentals Part 2 course can help you develop the skills necessary to succeed in this role. You will learn how to use Integration Services to move, manipulate, and integrate data, which is a key skill for Data Integration Engineers.

See salaries and explore the career path for Data Integration Engineer

Statistician

Statisticians use their knowledge of data integration and analysis to help organizations understand their data and make better decisions. They use a variety of tools and techniques to collect, analyze, and interpret data, which can be used to improve decision-making, develop new products, and identify new opportunities. The Integration Services Fundamentals Part 2 course can help you develop the skills necessary to succeed in this role. You will learn how to use Integration Services to move, manipulate, and integrate data, which is a key skill for Statisticians.

See salaries and explore the career path for Statistician

Data Architect

Data Architects design and build the data infrastructure that supports data analysis. They use their knowledge of data integration and analysis to help organizations get the most out of their data. The Integration Services Fundamentals Part 2 course can help you develop the skills necessary to succeed in this role. You will learn how to use Integration Services to move, manipulate, and integrate data, which is a key skill for Data Architects.

See salaries and explore the career path for Data Architect

Software Engineer

Software Engineers design, develop, and maintain software applications. They use their knowledge of data integration and analysis to help organizations get the most out of their data. The Integration Services Fundamentals Part 2 course can help you develop the skills necessary to succeed in this role. You will learn how to use Integration Services to move, manipulate, and integrate data, which is a key skill for Software Engineers.

See salaries and explore the career path for Software Engineer

Data Analyst

Data Analysts provide actionable insights to help businesses make better decisions. They use their knowledge of data integration and analysis to help organizations understand their data and make better use of it. The Integration Services Fundamentals Part 2 course can help you develop the skills necessary to succeed in this role. You will learn how to use Integration Services to move, manipulate, and integrate data, which is a key skill for Data Analysts.

See salaries and explore the career path for Data Analyst

Database Administrator

Database Administrators are responsible for managing and maintaining databases. They use their knowledge of data integration and analysis to help organizations get the most out of their data. The Integration Services Fundamentals Part 2 course can help you develop the skills necessary to succeed in this role. You will learn how to use Integration Services to move, manipulate, and integrate data, which is a key skill for Database Administrators.

See salaries and explore the career path for Database Administrator

Data Engineer

Data Engineers build and maintain the infrastructure that supports data analysis. They use their knowledge of data integration and analysis to help organizations get the most out of their data. The Integration Services Fundamentals Part 2 course can help you develop the skills necessary to succeed in this role. You will learn how to use Integration Services to move, manipulate, and integrate data, which is a key skill for Data Engineers.

See salaries and explore the career path for Data Engineer

Business Intelligence Developer

Business Intelligence Developers design and develop software solutions that help businesses track, analyze, and report on their data. They use their knowledge of data integration and analysis to help organizations make better decisions. The Integration Services Fundamentals Part 2 course can help you develop the skills necessary to succeed in this role. You will learn how to use Integration Services to move, manipulate, and integrate data, which is a key skill for Business Intelligence Developers.

See salaries and explore the career path for Business Intelligence Developer

Data Scientist

Data Scientists use their knowledge of data integration and analysis to help organizations solve complex problems. They use a variety of tools and techniques to extract insights from data, which can be used to improve decision-making, develop new products, and identify new opportunities. The Integration Services Fundamentals Part 2 course can help you develop the skills necessary to succeed in this role. You will learn how to use Integration Services to move, manipulate, and integrate data, which is a key skill for Data Scientists.

See salaries and explore the career path for Data Scientist

Business Intelligence Analyst

Business Intelligence Analysts use their knowledge of Integration Services to create data reports and dashboards. These reports and dashboards can be used by organizations to track key performance indicators and make informed decisions. This course will teach you the fundamentals of Integration Services, including how to use its data flow and control flow components to build data integration packages. With these skills, you will be well-prepared for a career as a Business Intelligence Analyst.

See salaries and explore the career path for Business Intelligence Analyst

Data Integration Analyst

Data Integration Analysts design and implement data integration solutions. They use their knowledge of Integration Services to move data from multiple sources into a single, unified data store. This data can then be used by organizations to improve decision-making and develop new products and services. This course will teach you the fundamentals of Integration Services, including how to use its data flow and control flow components to build data integration packages. With these skills, you will be well-prepared for a career as a Data Integration Analyst.

See salaries and explore the career path for Data Integration Analyst

Integration Services Fundamentals Part 2

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses