Microsoft SQL Server Integration Services (SSIS) Training from Udemy

Now is your chance to learn Microsoft SQL Server Integration Services (SSIS) with this extensive course that will give you the confidence and skills to use this Business Intelligence tool. It will be the golden ticket to your success in this industry. You will learn the basics about the development tools and what they are capable of, clear instruction on how to handle various issues that you might face when designing your packages and how to overcome them. By the end of this course you will understand many basic concepts and how to perform data integration and transformation. This course also includes the process of cleansing data and how to get the end result after applying different transformations. It also gives some real world scenarios that you might face and what salary to expect from working as an SSIS/ETL developer.

By taking this course you will learn about:

Creating an Integration Services Project
Basic SQL Server Data Tools features
Creating Integration Services Tasks
Creating connections to and from an Integration Services Package
Writing data to a SQL Server database
Executing a package from SQL Server Data Tools
Creating a Foreach Loop and map Variables
Controlling Data Flow for multiple Flat Files
Changing a Flat File Connection using Expressions
Changing command-line application arguments using Expressions
Change Data Capture(CDC) database objects
Preparing data for CDC and performing Incremental loading
Most Familiar Data Transformations concepts

What's inside

Learning objectives

Helps to obtain a job as etl developer
You can able to perform basic etl(extract transform load) tasks at your work
Gateway to obtain microsoft business intelligence certifications

You can analyze data and do marketing more effectively for a particular application
Build reports for any category of data

Helps to obtain a job as etl developer
You can able to perform basic etl(extract transform load) tasks at your work
Gateway to obtain microsoft business intelligence certifications
You can analyze data and do marketing more effectively for a particular application
Build reports for any category of data

Syllabus

Introduction to SSIS

Please find an attachment at resources section which can help you in understanding Introduction of SSIS

Creating a Package and Processing of Flat Files

Please find an attachment at resources section which can help you in understanding steps of creating this package

Incremental Loading

Configuring the Change Data Capture and see the details of configuration in attached document

This video covers on how to use pre-configured CDC to perform Incremental Loading

Excel Handling

Part-I deals on how to handle Excel Connection manager driver settings which is a necessary step in loading of excel files. Go through the attached resource document

Part-II deals about loading of excel files after fixing Excel Connection Manager driver issues and displaying results after successful execution

Data Transformations

Union ALL

LookUp

Sorting

Re-directing Unmatched rows

Please download the attachment from resource section. It defines each step of creation

Derived Column

Conditional Split

Students will learn as how to re-direct and handle error rows at run time.

Configuring DFT Error Output and Redirecting bad data

Loading error records into a table with specific error description(Script Task)

Error Handling by using Event Handlers

Students will learn on how to deploy a package on to SQL Server

Deploying a package using SSDT and executing it on SQL Server

Deploying a package using command-line and executing it on File System

Conclusion

Resume Tips

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Covers basic SSIS and ETL concepts, which are foundational in data analysis

Teaches advanced concepts like Change Data Capture and Error Handling, which are highly sought after in the industry

Provides real-world scenarios and examples, making it applicable to practical work situations

Offers guidance on resume writing, which is crucial for job seekers in the field

Led by Intelligence Guru, a reputable provider of quality online courses

Requires prior knowledge of SQL and data integration concepts, which may limit accessibility for beginners

Reviews summary

Ssis framework training guide

Learners say this course provides a solid overview and a practical guide to SSIS in a brief timeframe. Students have remarked that keeping the learning content more concise would be helpful.

Offers a strong foundation to SSIS

"course provides a solid overview of SSIS"

Reduce the volume of learning content

"keeping the learning content more concise would be helpful"

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 Microsoft SQL Server Integration Services (SSIS) Training with these activities:

Intro to Microsoft SQL Server Integration Services (SSIS)

Show steps

Refresh your foundational knowledge in SQL Server Integration Services, including the development tools and their capabilities.

Browse courses on SSIS

Show steps

Review the course syllabus to gain an understanding of the key concepts and modules covered.
Go through the course materials, including videos, readings, and assignments, to reinforce your understanding of SSIS.
Practice creating simple SSIS packages using the provided resources and examples.

Review the basics of SQL

Show steps

Ensure you have a strong foundation in SQL, which is essential for understanding SSIS.

Browse courses on SQL

Show steps

Review online tutorials or documentation on SQL basics.
Practice writing SQL queries.

Attend SSIS User Group Meeting

Show steps

Participate in an SSIS user group meeting to connect with other professionals, exchange knowledge, and stay updated on industry trends.

Browse courses on Networking

Show steps

Research and identify local or online SSIS user groups.
Attend a meeting and introduce yourself.
Engage in discussions, ask questions, and share your experiences with other members.

Eight other activities

Expand to see all activities and additional details

Show all 11 activities

Join a study group or participate in online forums to discuss SSIS

Show steps

Connect with other students and professionals to share knowledge, ask questions, and get feedback on your work.

Browse courses on SSIS

Show steps

Find a study group or online forum dedicated to SSIS.
Introduce yourself and ask questions.
Share your knowledge and help others.

Follow tutorials on how to use SSIS

Show steps

Reinforce your understanding of SSIS by following guided tutorials that provide step-by-step instructions for common tasks.

Browse courses on SSIS

Show steps

Search for SSIS tutorials online.
Choose a tutorial that covers a topic you're interested in.
Follow the instructions in the tutorial.
Try to complete the tutorial on your own.

Practice using the GUI of SQL Server Data Tools

Show steps

Get familiar with the layout and features of SQL Server Data Tools, the primary software tool used in this course.

Browse courses on SQL Server Data Tools

Show steps

Start SQL Server Data Tools.
Explore the different menus and toolbars.
Create a new integration services project.
Add a data source to the project.

Hands-on SSIS Package Development

Show steps

Engage in hands-on exercises to solidify your understanding of SSIS package development, including creating tasks, establishing connections, and transforming data.

Browse courses on ETL

Show steps

Set up your development environment and install the necessary tools for SSIS package development.
Create a new SSIS project and add various tasks, such as data sources, transformations, and destinations.
Configure the package properties, including execution options and error handling.
Debug and test your package to ensure it runs successfully and meets the desired outcomes.
Deploy your package to the Integration Services catalog to make it available for execution.

Build a data integration package that loads data from a flat file into a SQL Server database

Show steps

Apply the skills you've learned in the course to a practical project that demonstrates your ability to perform basic ETL tasks.

Browse courses on Data Integration

Show steps

Create a new SSIS project.
Add a data source to the project that points to a flat file.
Add a destination to the project that points to a SQL Server database.
Create a data flow task that transforms the data from the flat file.
Run the package and verify that the data is loaded into the SQL Server database.

Build a data integration package that performs incremental loading using Change Data Capture

Show steps

Challenge yourself with a more advanced project that demonstrates your ability to use Change Data Capture for incremental loading.

Browse courses on Change Data Capture

Show steps

Create a new SSIS project.
Enable Change Data Capture on the source table.
Add a data source to the project that points to the source table.
Add a destination to the project that points to a SQL Server database.
Create a data flow task that uses the Change Data Capture source.
Run the package and verify that the data is loaded into the SQL Server database.

Advanced SSIS Data Transformations

Show steps

Explore advanced data transformations using SSIS, such as conditional splitting, error handling, and custom scripting, to enhance your data processing capabilities.

Browse courses on Data Cleansing

Show steps

Review the documentation and examples on advanced SSIS data transformations.
Implement conditional splitting to route data based on specific conditions.
Configure error handling mechanisms to gracefully handle errors and ensure data integrity.
Utilize custom scripting components to extend the functionality of SSIS packages and perform complex data manipulations.

Participate in an SSIS Hackathon

Show steps

Challenge yourself by participating in an SSIS hackathon to showcase your skills, solve complex data integration problems, and network with other professionals.

Show steps

Find and register for an SSIS hackathon that aligns with your interests and skill level.
Form a team or work individually to develop an innovative SSIS solution to the given challenge.
Present your solution to a panel of judges and receive feedback.

Career center

Learners who complete Microsoft SQL Server Integration Services (SSIS) Training will develop knowledge and skills that may be useful to these careers:

Data Engineer

A Data Engineer is a professional who designs and manages data systems. Data Engineers use a variety of tools and technologies to ensure that data is accurate, consistent, and accessible. This course in Microsoft SQL Server Integration Services (SSIS) can help you build a strong foundation for a career as a Data Engineer. The course will teach you how to use SSIS to extract, transform, and load data from a variety of sources. You will also learn how to create data visualizations and reports.

See salaries and explore the career path for Data Engineer

ETL Developer

An ETL Developer is a professional who designs and develops ETL (Extract, Transform, Load) processes. ETL Developers use data integration tools to move data from one system to another. This course in Microsoft SQL Server Integration Services (SSIS) can help you build a strong foundation for a career as an ETL Developer. The course will teach you how to use SSIS to extract, transform, and load data from a variety of sources. You will also learn how to create data visualizations and reports.

See salaries and explore the career path for ETL Developer

Data Analyst

A Data Analyst is a professional who collects, processes, and analyzes large sets of data. Data Analysts use their findings to help businesses make informed decisions. This course in Microsoft SQL Server Integration Services (SSIS) can help you build a strong foundation for a career as a Data Analyst. The course will teach you how to use SSIS to extract, transform, and load data from a variety of sources. You will also learn how to create data visualizations and reports. These skills are in high demand in today's job market.

See salaries and explore the career path for Data Analyst

Business Intelligence Developer

A Business Intelligence Developer is a professional who designs and develops business intelligence solutions. Business Intelligence Developers use data to create reports, dashboards, and other visualizations that help businesses make better decisions. This course in Microsoft SQL Server Integration Services (SSIS) can help you build a strong foundation for a career as a Business Intelligence Developer. The course will teach you how to use SSIS to extract, transform, and load data from a variety of sources. You will also learn how to create data visualizations and reports.

See salaries and explore the career path for Business Intelligence Developer

Data Integration Specialist

A Data Integration Specialist is a professional who designs and implements data integration solutions. Data Integration Specialists use a variety of tools and technologies to move data from one system to another. This course in Microsoft SQL Server Integration Services (SSIS) can help you build a strong foundation for a career as a Data Integration Specialist. The course will teach you how to use SSIS to extract, transform, and load data from a variety of sources.

See salaries and explore the career path for Data Integration Specialist

Database Administrator

A Database Administrator is a professional who manages and maintains databases. Database Administrators ensure that databases are running smoothly and that data is safe and secure. This course in Microsoft SQL Server Integration Services (SSIS) can help you build a strong foundation for a career as a Database Administrator. The course will teach you how to use SSIS to extract, transform, and load data from a variety of sources. You will also learn how to create data visualizations and reports.

See salaries and explore the career path for Database Administrator

Data Scientist

A Data Scientist is a professional who uses data to solve business problems. Data Scientists use a variety of tools and techniques to analyze data and develop predictive models. This course in Microsoft SQL Server Integration Services (SSIS) can help you build a strong foundation for a career as a Data Scientist. The course will teach you how to use SSIS to extract, transform, and load data from a variety of sources. You will also learn how to create data visualizations and reports. While not essential, a Data Scientist will typically hold a master's or PhD degree.

See salaries and explore the career path for Data Scientist

Database Designer

A Database Designer is a professional who designs and develops databases. Database Designers use a variety of tools and techniques to create databases that meet the needs of users. This course in Microsoft SQL Server Integration Services (SSIS) may be useful for Database Designers who want to learn how to use SSIS to extract, transform, and load data from a variety of sources.

See salaries and explore the career path for Database Designer

Data Management Analyst

A Data Management Analyst is a professional who analyzes and manages data. Data Management Analysts use a variety of tools and techniques to ensure that data is accurate, consistent, and accessible. This course in Microsoft SQL Server Integration Services (SSIS) may be useful for Data Management Analysts who want to learn how to use SSIS to extract, transform, and load data from a variety of sources.

See salaries and explore the career path for Data Management Analyst

Business Analyst

A Business Analyst is a professional who analyzes and solves business problems. Business Analysts use a variety of tools and techniques to identify and solve business problems. This course in Microsoft SQL Server Integration Services (SSIS) may be useful for Business Analysts who want to learn how to use SSIS to extract, transform, and load data from a variety of sources.

See salaries and explore the career path for Business Analyst

Software Engineer

A Software Engineer is a professional who designs, develops, and maintains software applications. Software Engineers use a variety of programming languages and tools to create software that meets the needs of users. This course in Microsoft SQL Server Integration Services (SSIS) may be useful for Software Engineers who want to learn how to use SSIS to extract, transform, and load data from a variety of sources.

See salaries and explore the career path for Software Engineer

Data Warehouse Engineer

A Data Warehouse Engineer is a professional who designs and builds data warehouses. Data Warehouse Engineers use a variety of tools and technologies to create data warehouses that store and manage large amounts of data. This course in Microsoft SQL Server Integration Services (SSIS) may be useful for Data Warehouse Engineers who want to learn how to use SSIS to extract, transform, and load data from a variety of sources.

See salaries and explore the career path for Data Warehouse Engineer

Systems Analyst

A Systems Analyst is a professional who analyzes and designs computer systems. Systems Analysts use a variety of tools and techniques to identify and solve business problems. This course in Microsoft SQL Server Integration Services (SSIS) may be useful for Systems Analysts who want to learn how to use SSIS to extract, transform, and load data from a variety of sources.

See salaries and explore the career path for Systems Analyst

Computer Programmer

A Computer Programmer is a professional who writes and maintains computer code. Computer Programmers use a variety of programming languages and tools to develop software applications. This course in Microsoft SQL Server Integration Services (SSIS) may be useful for Computer Programmers who want to learn how to use SSIS to extract, transform, and load data from a variety of sources.

See salaries and explore the career path for Computer Programmer

Information Architect

An Information Architect is a professional who designs and manages information systems. Information Architects use a variety of tools and techniques to ensure that information is organized and accessible. This course in Microsoft SQL Server Integration Services (SSIS) may be useful for Information Architects who want to learn how to use SSIS to extract, transform, and load data from a variety of sources.

See salaries and explore the career path for Information Architect