We may earn an affiliate commission when you visit our partners.
Stacia Misner Varga
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.
Read more
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.
Read more
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/8qr7fo/integration
Here's a deal for you
We found an offer that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
What's inside
Syllabus
Course Overview
Control Flow Tasks
Data Flow Sources and Destinations
Data Flow Transformations
Read more
Syllabus
Course Overview
Control Flow Tasks
Data Flow Sources and Destinations
Data Flow Transformations
Read more
Integration Services for Business Intelligence Solutions
Scripts
Debugging SSIS Packages
Package Reliability
Good to know
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
Save this course
Save Integration Services Fundamentals Part 2 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 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.
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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 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.
Statistician
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.
Data Architect
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.
Software Engineer
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.
Data Analyst
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.
Database Administrator
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.
Data Engineer
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.
Business Intelligence Developer
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.
Data Scientist
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.
Business Intelligence Analyst
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.
Data Integration 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.
For more career information including salaries, visit:
OpenCourser.com/course/8qr7fo/integration
Reading list
We've selected three 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
Integration Services Fundamentals Part 2.
Provides a practical guide to using Integration Services in real-world scenarios. It valuable resource for those who want to learn how to use Integration Services to solve real-world problems.
Provides a comprehensive overview of data integration with SQL Server, including SSIS. It valuable resource for anyone who wants to learn more about data integration with SQL Server or who is looking for a reference guide.
Provides a collection of best practices for using SSIS. It valuable resource for anyone who wants to learn more about SSIS or who is looking for ways to improve their SSIS development skills.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/8qr7fo/integration
Share
Similar courses
Here are nine courses similar to
Integration Services Fundamentals Part 2.
Mastering ETL: Data Cleansing with SQL Server Integration Services
OpenCourser.com/course/21f5kn/mastering
Mastering ETL: Data Cleansing with SQL Server Integration...
Most relevant
Microsoft SQL Server Integration Services (SSIS) Training
OpenCourser.com/course/cfg6tq/microsoft
Microsoft SQL Server Integration Services (SSIS) Training
Most relevant
Mastering SQL Server 2016 Integration Services (SSIS)-Part 1
OpenCourser.com/course/a6c5a6/mastering
Mastering SQL Server 2016 Integration Services (SSIS)...
Microsoft Azure Solutions Architect: Design Data Integration
OpenCourser.com/course/56j33d/microsoft
Microsoft Azure Solutions Architect: Design Data...
Designing SSIS Integration Solutions
OpenCourser.com/course/pjo9qy/designing
Designing SSIS Integration Solutions
Getting Started with R in the Microsoft Data Platform
OpenCourser.com/course/19h838/getting
Getting Started with R in the Microsoft Data Platform
Azure Logic Apps: Fundamentals
OpenCourser.com/course/e8jzvc/azure
Azure Logic Apps: Fundamentals
Aruba Cloud Basics
OpenCourser.com/course/9au8as/aruba
Aruba Cloud Basics
Microsoft Azure DevOps Engineer: Inspecting and Identifying Code Dependencies
OpenCourser.com/course/5e5cdo/microsoft
Microsoft Azure DevOps Engineer: Inspecting and...
Time
235 hours
Level
Introductory
Via
Pluralsight
Instructor
Stacia Misner Varga
Language
English
Good to know
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
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