Mastering SQL Server 2016 Integration Services (SSIS)-Part 1 from Udemy

What's inside

Learning objectives

Learn data migration techniques
Learn how to work with various dataflow transformations
Learn how to work with various controlflow activities
Learn how to use configuration files
Learn how to make dynamic ssis packages
Learn how to do event handling
Learn how to work with wmi tasks

Learn how to use msmq to pass messages between packages
Learn how to improve the db performance by using maintenance plan tasks
Learn how to implement checkpoints
Learn how to work with various data sources and data destinations
Show more
Show less

Learn data migration techniques
Learn how to work with various dataflow transformations
Learn how to work with various controlflow activities
Learn how to use configuration files
Learn how to make dynamic ssis packages
Learn how to do event handling
Learn how to work with wmi tasks
Learn how to use msmq to pass messages between packages
Learn how to improve the db performance by using maintenance plan tasks
Learn how to implement checkpoints
Learn how to work with various data sources and data destinations
Show more
Show less

Syllabus

SSIS - The Big Picture

Course Introduction

Installing SQL Server 2022, SSMS

Installing Visual Studio 2022 Community Edition, Project Templates

Installing SQL Server 2016

Installing SSDT

Setting Up Sample Database

Overview of SQL Server Integration Services (SSIS)

COMPLETE COURSE EXERCISE FILES

Data Migration Techniques

Working with Import Export Wizard

Invoking Wizard From SSMS

Invoking Wizard From SSDT

Working with Data Flow Tasks - 1

Exporting Data From SQL Server To CSV File

Working with CharacterMap Transformation

Working with CopyColumn Transformation

Working with DerivedColumn Transformation

Working with PercentageSampling Transformation

Working with RowSampling Transformation

Working with Data Flow Tasks - 2

Working with Sort Transformation

Working with UnionAll Transformation

Working with Multicast Transformation

Working with ConditionalSplit Transformation

Working with Aggregate Transformation

Working with Data Flow Tasks - 3

Working with Audit Transformation

Working with ExportColumn Transformation

Working with ImportColumn Transformation

Working with Merge Transformation

Working with MergeJoin Transformation

Working with Data Flow Tasks - 4

Working with LookUp Transformation

Working with CacheTransform

Working with FuzzyLookUp Transformation

Working with FuzzyGrouping Transformation

Working with Data Flow Tasks - 5

Working with RowCount Transformation

Working with OLEDBCommand Transformation

Working with Pivot Transformation

Working with Unpivot Transformation

Working with Data Flow Tasks - 6

Working with TermExtract Transformation

Working with TermLookUp Transformation

Working with Control Flow - 1

Working with BulkInsert Task

Working with SequenceContainer Task

Working with ExecuteProcess Task

Working with ExecutePackage Task

Passing Parameters between Packages

Working with Control Flow - 2

Working with FileSystem Task

Working with WebService Task

Working with XML Task

Working with DataProfilingTask

Working with ControlFlow - 3

Working with TransferDatabase Task

Working with TransferSQLServerObjects Task

Working with TransferMasterStoredProcedures Task

Working with TransferJobs Task

Working with TransferLogins Task

Working with TransferErrorMessages Task

Working with Control Flow - 4

Working with For Loop Container in a Fixed Manner

Working with For Loop Container in a Variant Manner

Working with For Each File Enumerator

Working with For Each Item Enumerator

Working with For Each From Variable Enumerator

Working with For Each Node List Enumerator

Working with For Each SMO Enumerator

Working with For Each ADO Enumerator

Working with Configuration Types

Using Configuration Files

Using Configuration Tables

Creating Dynamic Packages

Creating Dynamic Connection Managers

Creating Dynamic Tasks

Event Handling Techniques

Using Precedence Constraints

Handling Events

Working with Log Providers

Working with Log Provider for Text Files

Working with Log Provider for XML Files

Working with Log Provider for Windows Event Log

Working with WMI Tasks

Working with WMIDataReader Task - 1

Working with WMIDataReader Task - 2

Working with WMIEventWatcher Task

Using Message Queuing Techniques

Sending and Receiving Messages with Message Queuing Task

Working with Maintenance Planning Tasks

Working with BackUpDatabase Task

Working with SQLServer Agent Job Task

Working with Execute T-SQL Task

Working with Update Statistics Task

Working with HistoryCleanUp Task

Working with ShrinkDatabase Task

Working with RebuildIndexes Task

Working with ReorganizeIndex Task

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops essential SSIS skills, which are core for data integration and transformation

Taught by instructors recognized for their SQL Server expertise

Covers a range of SSIS topics, from basic to advanced

Provides step-by-step walk-throughs and demos for hands-on learning

Suitable for beginners with no prior SSIS experience

Aligned with industry best practices and standards

Reviews summary

Very good sql-server course

Learners say this Mastering SQL Server 2016 Integration Services (SSIS) Part 1 course is very good and helpful. It covers many topics that learners were not familiar with. This course can help learners with automation tasks at work.

Course covers many helpful topics.

"Es un curso muy bueno, me ayudara mucho para poder desempeñar unas automatizaciones que estoy realizando en la empresa en la que estoy trabajando ya que abarca muchos temas los cuales yo no tenia conocimiento "

"Very Recommended :)"

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 Mastering SQL Server 2016 Integration Services (SSIS)-Part 1 with these activities:

Practice CRUD Operations

Show steps

Create, Read, Update, and Delete (CRUD) operations are the foundation of SSIS. Getting hands-on practice will help solidify your understanding.

Browse courses on Data Integration

Show steps

Create a new SSIS package
Add a data source
Add a data flow task
Add a destination
Execute the package

Create Sample ETL flows using SSIS

Show steps

Reinforces learning by building and running sample SSIS packages that demonstrate the techniques learned in the course.

Show steps

Design a simple data integration flow using SSIS
Create a new SSIS project and package
Add data sources and destinations
Use data flow transformations to transform data
Run the package and analyze the results

Build an SSIS Package

Show steps

Hands-on experience is crucial in mastering SSIS. Building a real-world package will help you apply the concepts learned in the course.

Browse courses on Data Integration

Show steps

Identify a business problem
Design the SSIS package
Implement the SSIS package
Deploy the SSIS package
Monitor the SSIS package

Two other activities

Expand to see all activities and additional details

Show all five activities

Write a blog post on a specific SSIS technique

Show steps

Expands understanding by requiring students to articulate and explain a specific SSIS technique in a written format.

Show steps

Choose a specific SSIS technique to focus on
Research and gather information about the technique
Write a detailed blog post explaining the technique
Include examples and code snippets to illustrate the technique
Publish the blog post and share it with others

Follow online tutorials to explore advanced SSIS features

Show steps

Extends learning beyond the course by exposing students to additional SSIS features and techniques.

Show steps

Identify online tutorials that cover advanced SSIS features
Follow the tutorials and complete the exercises
Experiment with the new features in your own SSIS projects
Share your learnings with other students or colleagues
Optional: Create a video tutorial or blog post to document your experience

Career center

Learners who complete Mastering SQL Server 2016 Integration Services (SSIS)-Part 1 will develop knowledge and skills that may be useful to these careers:

Data Integration Specialist

A Data Integration Specialist designs, develops, and maintains data integration solutions. This course provides a comprehensive overview of SSIS, the industry-leading tool for data integration. You will learn how to use SSIS to extract data from various sources, transform it to meet specific requirements, and load it into target databases. The course also covers advanced topics such as data profiling, error handling, and performance optimization, which are essential for building robust and efficient data integration solutions.

See salaries and explore the career path for Data Integration Specialist

ETL Developer

An ETL Developer is responsible for designing, developing, and maintaining data integration and transformation processes. This course provides a comprehensive overview of SSIS, the industry-leading tool for ETL development. You will learn how to use SSIS to extract data from various sources, transform it to meet specific requirements, and load it into target databases. The course also covers advanced topics such as data profiling, error handling, and performance optimization, which are essential for building robust and efficient ETL solutions.

See salaries and explore the career path for ETL Developer

Data Engineer

A Data Engineer designs, builds, and maintains data pipelines that power data-driven applications. This course provides a solid foundation in SSIS, a key technology for data integration and transformation. By mastering SSIS, you will develop the skills to build scalable and reliable data pipelines that can handle large volumes of data. The course also covers topics such as data quality management, data governance, and data security, which are critical for Data Engineers.

See salaries and explore the career path for Data Engineer

Data Warehouse Engineer

A Data Warehouse Engineer designs, develops, and maintains data warehouses. This course provides a comprehensive overview of SSIS, a key technology for data integration and transformation. By mastering SSIS, you will develop the skills to build scalable and reliable data warehouses that can handle large volumes of data. The course also covers topics such as data modeling, data quality management, and data security, which are critical for Data Warehouse Engineers.

See salaries and explore the career path for Data Warehouse Engineer

Data Management Consultant

A Data Management Consultant helps organizations manage and use their data effectively. This course provides a comprehensive overview of SSIS, a powerful tool for data integration and transformation. By mastering SSIS, you will develop the skills to help organizations build robust and efficient data management solutions. The course also covers topics such as data governance, data quality management, and data security, which are critical for Data Management Consultants.

See salaries and explore the career path for Data Management Consultant

Business Intelligence Analyst

A Business Intelligence Analyst analyzes data to identify trends and patterns that can help businesses make informed decisions. This course focuses on building SSIS packages that automate the extraction, transformation, and loading of data, which is essential for providing timely and accurate insights to stakeholders. The course also covers techniques for data cleansing, data profiling, and data visualization, which are key skills for Business Intelligence Analysts.

See salaries and explore the career path for Business Intelligence Analyst

Database Developer

A Database Developer designs and develops database systems. This course provides a comprehensive overview of SSIS, a powerful tool for data integration and transformation. By mastering SSIS, you will develop the skills to build robust and efficient database systems that can handle large volumes of data. The course also covers topics such as data modeling, data optimization, and data security, which are essential for Database Developers.

See salaries and explore the career path for Database Developer

Data Analyst

A Data Analyst is a professional who transforms raw data into meaningful insights, enabling organizations to make data-driven decisions. This course provides a comprehensive foundation in SQL Server Integration Services (SSIS), a powerful tool for data integration and transformation. By mastering SSIS, you will develop the skills to extract, transform, and load data efficiently, which is crucial for success as a Data Analyst.

See salaries and explore the career path for Data Analyst

Information Architect

An Information Architect designs and manages the structure and organization of information systems. This course may be useful for Information Architects who want to learn how to use SSIS for data integration and transformation tasks. The course covers topics such as data modeling, data governance, and data quality management, which are valuable skills for Information Architects.

See salaries and explore the career path for Information Architect

Database Administrator

A Database Administrator is responsible for managing and maintaining database systems. This course may be useful for Database Administrators who want to expand their skill set and learn how to use SSIS for data integration and transformation tasks. The course covers topics such as data migration, data cleansing, and data profiling, which are valuable skills for Database Administrators.

See salaries and explore the career path for Database Administrator

Data Scientist

A Data Scientist uses data to build models that can predict future outcomes or identify patterns. This course may be useful for Data Scientists who want to learn how to use SSIS for data integration and transformation tasks. The course covers topics such as data mining, machine learning, and data visualization, which are valuable skills for Data Scientists.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer designs, develops, and maintains software applications. This course may be useful for Software Engineers who want to learn how to use SSIS for data integration and transformation tasks. The course covers topics such as data modeling, data mapping, and data validation, which are valuable skills for Software Engineers.

See salaries and explore the career path for Software Engineer

Project Manager

A Project Manager plans, executes, and closes projects. This course may be useful for Project Managers who want to learn how to use SSIS for data integration and transformation tasks. The course covers topics such as project planning, risk management, and stakeholder management, which are valuable skills for Project Managers.

See salaries and explore the career path for Project Manager

Systems Analyst

A Systems Analyst analyzes business processes and develops solutions to improve efficiency. This course may be useful for Systems Analysts who want to learn how to use SSIS for data integration and transformation tasks. The course covers topics such as business process modeling, data analysis, and requirements gathering, which are valuable skills for Systems Analysts.

See salaries and explore the career path for Systems Analyst

Business Analyst

A Business Analyst analyzes business processes and identifies opportunities for improvement. This course may be useful for Business Analysts who want to learn how to use SSIS for data integration and transformation tasks. The course covers topics such as business process modeling, data analysis, and requirements gathering, which are valuable skills for Business Analysts.

See salaries and explore the career path for Business Analyst