Curso 55321 SQL Server Integration Services

  • Microsoft SQL Server

Curso 55321 SQL Server Integration Services

32 horas
Visão Geral

Curso 55321 SQL Server Integration Services SSIS. Este curso apresenta os conceitos, arquitetura, ferramentas e técnicas de desenvolvimento de soluções de integração, transformação e movimentação de dados utilizando o Microsoft SQL Server Integration Services (SSIS). O treinamento aborda a construção de processos ETL (Extract, Transform, Load), permitindo extrair dados de diferentes fontes, realizar transformações, aplicar regras de negócio e carregar informações em bancos de dados e ambientes analíticos.

Os participantes aprenderão a desenvolver, configurar, executar, monitorar e solucionar problemas em pacotes SSIS, utilizando o SQL Server Data Tools (SSDT), fluxos de controle, fluxos de dados, conexões, componentes de transformação e mecanismos de tratamento de erros. O curso também contempla parâmetros, variáveis, expressões, implantação de projetos, execução automatizada, logging e otimização de desempenho, preparando os profissionais para desenvolver pipelines de integração de dados confiáveis e escaláveis em ambientes corporativos.

Objetivo

Após realizar este curso 55321 SQL Server Integration Services SSIS, você será capaz de:

  • Compreender a arquitetura e os componentes do SQL Server Integration Services
  • Desenvolver pacotes ETL para extração, transformação e carregamento de dados
  • Configurar conexões com diferentes fontes e destinos de dados
  • Criar fluxos de controle e fluxos de dados
  • Implementar transformações e regras de negócio em pipelines de integração
  • Trabalhar com variáveis, parâmetros, expressões e configurações dinâmicas
  • Implementar tratamento de erros, logging e mecanismos de auditoria
  • Desenvolver processos de integração com múltiplas fontes de dados
  • Implantar e executar projetos SSIS no Integration Services Catalog
  • Automatizar processos ETL utilizando SQL Server Agent
  • Monitorar, diagnosticar e otimizar o desempenho de pacotes SSIS
  • Implementar boas práticas de desenvolvimento, manutenção e governança de processos ETL
Publico Alvo
  • Desenvolvedores SQL Server
  • Desenvolvedores e engenheiros de dados
  • Administradores de banco de dados (DBAs)
  • Analistas de Business Intelligence (BI)
  • Profissionais de ETL e integração de dados
  • Analistas de sistemas e desenvolvedores de aplicações
  • Especialistas em Data Warehouse
  • Profissionais responsáveis por processos de migração e integração de dados
Pre-Requisitos
  • Conhecimentos básicos de bancos de dados relacionais
  • Familiaridade com Microsoft SQL Server
  • Conhecimentos básicos de SQL e Transact-SQL (T-SQL)
  • Noções de modelagem e manipulação de dados
  • Conhecimentos básicos de lógica de programação são desejáveis
Materiais
Ingles/Portugues
Conteúdo Programatico

Module 1 – Introduction to SQL Server Integration Services

  1. Data integration concepts and ETL architecture
  2. Introduction to SQL Server Integration Services
  3. SSIS architecture and runtime components
  4. Integration Services projects and packages
  5. SQL Server Data Tools (SSDT) environment
  6. Visual Studio and SSIS development extensions
  7. Package execution and deployment models
  8. SSIS development lifecycle and best practices

Module 2 – SSIS Projects, Packages and Connections

  1. Creating and configuring SSIS projects
  2. Package structure and organization
  3. Connection Managers and connection configuration
  4. Connecting to SQL Server databases
  5. Flat File and Excel connections
  6. XML and other data source connections
  7. OLE DB and ADO.NET providers
  8. Connection expressions and dynamic configurations
  9. Package properties and execution settings

Module 3 – Control Flow and Workflow Management

  1. Control Flow architecture and components
  2. Tasks and containers in SSIS packages
  3. Execute SQL Task configuration
  4. Data Flow Task execution
  5. File System Task and file management
  6. Script Task fundamentals
  7. Sequence Containers and For Loop Containers
  8. Foreach Loop Containers
  9. Precedence Constraints and workflow conditions
  10. Event Handlers and package execution events

Module 4 – Data Flow and ETL Development

  1. Data Flow architecture and execution pipeline
  2. Sources, transformations and destinations
  3. OLE DB Source and Destination
  4. Flat File Source and Destination
  5. Excel Source and Destination
  6. Data Conversion and Derived Column transformations
  7. Conditional Split and Multicast transformations
  8. Lookup and Fuzzy Lookup transformations
  9. Aggregate, Sort and Merge Join transformations
  10. Union All and Merge transformations
  11. Slowly Changing Dimension (SCD) transformations
  12. Handling NULL values and data type conversions

Module 5 – Advanced Data Transformation and ETL Patterns

  1. Implementing complex data transformation workflows
  2. Data cleansing and standardization
  3. Data validation and quality controls
  4. Incremental data loading strategies
  5. Change Data Capture (CDC) integration concepts
  6. Lookup optimization and reference data management
  7. Handling duplicate records and data inconsistencies
  8. Implementing staging areas and intermediate processing
  9. Loading relational and dimensional data structures
  10. ETL orchestration and dependency management

Module 6 – Variables, Parameters and Expressions

  1. SSIS variables and variable scopes
  2. System and user-defined variables
  3. Project and package parameters
  4. Expressions and dynamic property configuration
  5. Property expressions and connection string management
  6. Environment variables and SSIS environments
  7. Dynamic file and database connections
  8. Reusable and parameterized ETL packages

Module 7 – Error Handling, Logging and Auditing

  1. SSIS error handling architecture
  2. Error outputs and redirection strategies
  3. Event handlers and exception management
  4. Logging providers and execution logging
  5. Data lineage and audit information
  6. Checkpoints and package restartability
  7. Transaction management and consistency
  8. Failure notifications and operational monitoring
  9. Troubleshooting package execution failures

Module 8 – Deployment, Scheduling and Administration

  1. SSIS deployment models
  2. Project Deployment Model
  3. Integration Services Catalog (SSISDB)
  4. Project and package deployment
  5. Environment configuration and parameter mapping
  6. Package execution using SQL Server Agent
  7. Command-line execution with DTExec
  8. Package execution using PowerShell
  9. Version control and release management
  10. SSIS administration and operational governance

Module 9 – Performance Optimization and Troubleshooting

  1. SSIS pipeline performance architecture
  2. Buffer management and memory optimization
  3. Data Flow performance tuning
  4. Fast Load and bulk insertion strategies
  5. Parallel execution and resource management
  6. Optimizing Lookup and Join operations
  7. Monitoring execution performance
  8. Identifying bottlenecks and resource constraints
  9. Troubleshooting package failures and connectivity issues
  10. Performance optimization best practices

Module 10 – Practical Labs and ETL Project Development

  1. Creating an SSIS project from scratch
  2. Extracting data from SQL Server and CSV files
  3. Transforming and validating data
  4. Implementing Lookup and Conditional Split operations
  5. Developing an incremental ETL loading process
  6. Implementing error handling and execution logging
  7. Configuring dynamic parameters and environments
  8. Deploying packages to SSISDB
  9. Scheduling ETL execution with SQL Server Agent
  10. Developing an end-to-end data integration project
TENHO INTERESSE

Cursos Relacionados

Curso Implementando um Data Warehouse SQL

32 horas

Curso MySQL para Iniciantes Administração de Banco de Dados

32 horas

Curso SQL Microsoft Database Fundamentals

16 horas

Curso Microsoft SQL 20761 Consultando Dados com o Transact-SQL

32 Horas

Curso Microsoft SQL 20762 Developing SQL Databases

40 Horas

Curso Microsoft SQL Server Analysis Services MSA

24 horas

Curso Analyzing Data with SQL Server Reporting Services

32 horas

Curso Aprendendo SQL Fundamentos e Prática com Bancos de Dados Relacionais

24 horas

Curso SQL Server 2019 for Developers

32 horas

Curso SQL Server Integration Services

32 horas