SQL Server Integration Services (SSIS) - ETL Avançado
Master data extraction, transformation, and loading (ETL) techniques. Learn to work with databases and files for efficient data management.
Course Content
SQL Server Integration Services (SSIS) - ETL Avançado is an all-levels Udemy course taught by Edmilson Alves dos Santos. It runs 23h 34m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 241 reviews, with 2,577 students enrolled. It is a paid course, last updated August 2025.
ETL with SSIS: Master Data Transformation & Integration
Learn to expertly transform, manipulate, and integrate data with this comprehensive course. Gain practical skills in ETL (Extract, Transform, Load) using SQL Server Integration Services (SSIS), empowering you to automate data processes in your company or academic projects.
What You'll Discover:
- SSIS for Business Intelligence: Understand how SSIS is a core BI tool within the Microsoft ecosystem and how to build robust Business Intelligence projects.
- Process Automation: Master the fundamentals of process automation and gain time-saving techniques for automating manual tasks.
- BI Process Overview: Develop a strong understanding of the tools and phases involved in a complete BI process.
- Hands-on Experience: Utilize freely available software (Developer version) to build a real-world BI environment, mirroring those used by leading companies.
- Environment Setup:
- Installation: Step-by-step guidance on installing necessary software.
- Database Design: Learn to create relational databases, including database modeling and data generation using T-SQL.
- Data Warehousing: Build a data warehouse architecture and model.
- Data Loading & Transformation:
- Data Stage Creation: Establish a staging area for data processing.
- Data Integration with SSIS: Load data from operational systems into the staging area using Integration Services.
- Data Transformation Techniques: Apply powerful data transformation methods within SSIS.
- Excel & SQL Server Analysis: Perform data analysis using Excel and SQL Server.
- Practical Projects:
- Real-World Scenarios: Apply your skills to practical projects with realistic data challenges.
- Downloadable Materials: Access all course materials for download.
- Data Modeling:
- Basic Data Modeling: Fundamentals of data modeling principles.
- SQL Power Architect: Learn to create database structures using SQL Power Architect.
- Advanced Diagram Configurations: Master advanced diagram configurations for database modeling.
- Relationship Modeling: Develop advanced table relationships and foreign keys.
- Associative Tables: Utilize associative tables for complex data modeling.
- Advanced SSIS Techniques:
- Data Blending & Joining: Combine data from multiple sources using various join types.
- Handling Different Data Sources: Work with data from Excel, CSV, TXT, and SQL Server.
- Error Handling: Implement robust error handling within SSIS packages.
- Multicast Replication: Replicate data to multiple destinations.
- SQL Commands in Excel: Execute SQL commands directly within Excel.
- Advanced SQL Queries: Master advanced SQL queries for data manipulation.
- Data Transformations: Apply techniques like aggregation, pivoting, unpivoting, and lookup functions.
- Slowly Changing Dimensions: Implement strategies for handling slowly changing dimensions.
- Sequence Containers: Utilize sequence containers for generating unique identifiers.
- Foreach Loop Containers: Process multiple files (Excel, TXT) within SSIS.
- Job Scheduling: Create and schedule SSIS jobs for automated execution.
- Project Completion: Build a complete BI project from start to finish.
Key Skills You'll Gain:
- SQL Server Integration Services (SSIS)
- ETL Processes
- Data Modeling
- Data Transformation
- Data Integration
- Process Automation
- Business Intelligence (BI)
- Data Warehousing
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.