Udemy – Data integration with SSIS – SQL Server Integration Services 2024-2

Apr 18, 2025 - 19:43

0 0

Data integration with SSIS – SQL Server Integration Services course. This comprehensive course teaches the essential skills to work with SQL Server Integration Services (SSIS). Designed by a Microsoft Certified Consultant with over 15 years of hands-on experience, this course provides a complete learning path from the basics to advanced SSIS techniques. Participants will experience everything from initial installation and setup to developing real-world data integration projects.

What you will learn:

Installing SQL Server and SSIS
Checking and running SQL Server services on Windows
Installing Visual Studio and SSIS projects
Install SSMS
Creating SSIS projects and solutions with Visual Studio
Building your first SSIS package from scratch
Learn to connect to SQL Server databases
Import and export CSV, Excel files, and XML documents
Managing errors in the data integration process
Compress and decompress Windows files and folders with SSIS
Import and export multiple files simultaneously with dynamic SSIS packages
Learn best practices for data integration using files
Installing SSAS
Developing a Simple Tabular Model
Install Power BI
Developing a simple Power BI report with charts
Installing SSAS projects on Visual Studio
Understand high-level concepts of ETL and business intelligence

This course is suitable for people who:

Are new to SSIS or want to better understand how it works
Have some experience in SQL Server or T-SQL (this knowledge is helpful but not essential)
Want to start learning from scratch or are familiar with previous versions of SSIS
Beginner or professional developers, data engineers, and consultants who want to quickly learn SSIS principles and best practices