fbpxl
Global - (+34) 91 414 89 50 | N. America - (800) 757 6543 contact@solidq.com

Formación privada

SQL Server Integration Services

Diseña, desarrolla, implementa y opera con SQL Server Integration Services (SSIS). En este curso aprenderás cómo crear y desarrollar nuevos proyectos y paquetes de SSIS, así como determinar cuándo utilizar el modo de proyecto frente a SSIS.

Entiende y aplica los conceptos de ETL (extracción, transformación y carga) en SSIS, incluyendo dimensiones y tablas de hechos, cargas de dimensión y cubos SAAS, y cómo administrar SSIS para la implementación del servidor y la ejecución de la producción.

Este curso está desarrollado internamente por SolidQ.

Beneficios

Crea y desarrolla nuevos paquetes de proyectos de SSIS.

Determina cuándo usar el modo de proyectos.
Carga dimensiones y cubos de SSAS.

Comprende y aplica conceptos de ETL en SSIS.

Aplica SSIS a la administración de archivos y datos.

Administra SSIS para la implementación del servidor y la ejecución de producción.

Modalidades del Curso

Formación Privada.

Esta modalidad permitirá a tu empresa poder contratar la formación de manera privada para que asista todo tu equipo.

Pre-requisitos

Es necesario contar con experiencia básica en soluciones de inteligencia de negocio y SQL Server. No se requiere experiencia previa con SQL Server SSIS.
Después del Curso
Diseñarás, desarrollarás, implementarás y operarás con SQL Server Integration Services (SSIS). En este curso aprenderás cómo crear y desarrollar nuevos proyectos y paquetes de SSIS, así como determinar cuándo utilizar el modo de proyecto frente a SSIS.

Contenido del Curso

Module 1. SSIS Overview and Core Features.
  • How SSIS fits into the corporate data network and infrastructure.

     

  • Introduction to data integration, BI, and dimensional modeling.
  • SSIS features overview.
  • SQL Server tools.

    Lab 01: SSIS Development Environment Introduction.

Module 2.vSSIS Control Flow Objects and Features.
  • Control flow and data flow.
  • principlesControl flow features.
  • Containers.
  • SSIS expression language.
  • Tasks and constraints.

     

    Lab 02: Preparing a DW.

Module 3. Applying Data Flow Transformations and Adapters.
  • Data flow introduction and design environment.
  • Connecting the data flow to sources and destinations.
  • Transformations and paths.

    Lab 03: Working with Data in the Data Flow.

  • Module 4. Working With and Importing Files.
  • File-handling requirements and management.
  • Working with binary data.
  • Excel and 64-bit considerations.
  • Third-party custom components.

    Lab 04: Importing and Processing FTP Sourced Files.

  • Module 5. Data Source Extraction and Destination Optimization.
  • Extraction optimization.
  • Incremental extraction and Change Data Capture.
  • Data loading optimization.

    Lab 05: Incremental Extraction and ODBC Sources.

  • Module 6. Data Quality and Cleansing.
  • Fuzzy operations.
  • Fuzzy Lookup.
  • Fuzzy Grouping.
  • Text mining.
  • Script component.
  • Data Quality Services.

    Lab 06: Comparing the Fuzzy Lookup and DQS Cleansing Transformations.

  • Module 7.Dimension ETL with SSIS.
  • Fact table ETL theory.
  • Fact loading concepts, columns and mappings.
  • Workflow, precedence and staging.
  • Identifying dimension surrogate keys.
  • Data preparation for fact tables.
  • Advanced concepts.

    Lab 07: Dimension Table ETL.

  • Module 8. Advanced Enterprise Information Management.
  • Script task and Script Component.
  • Text mining.
  • Advanced Analysis and SSIS.

    Lab 08: Fact ETL with SSIS.

  • Fact types and theory, Aspects of the fact table processing, Dimension lookups with the
  • Lookup transformation, Missing.
  • Dimension Members, Measures and
  • Calculations, Handling fact inserts and updates, Changing data grain, Processing.
  • Analysis Services Measure Group Partitions.

    Lab 08: Fact Table ETL.

  • Module 9: Processing Tabular and Multidimensional SSAS Objects in SSIS.
  • SSAS tabular and multidimensional.
  • Processing methods in SSIS.
  • Dynamic processing and partition creation.

    Lab 09: Analysis Services Processing.

  • Module 10. Project Deployment Model: Configuration, Deployment & Security.
  • Project Deployment Model.
  • SSIS catalog features.
  • Project and package connections.
  • Project and package parameters.
  • Project Deployment Wizard.
  • SSIS environments.
  • Security and encryption.

    Lab 10: SSIS Catalog Configurations and Project Deployment.

  • Module 11. Project Deployment Model: Execution and Reporting.
  • Project deployment model utilities
  • Package execution with T-SQL and DTExec
  • Server reporting and logging

    Lab 11: Executing Packages in the SSIS Catalog

  • Module 12.Package Deployment Model: Configuration and Deployment.
    • Package deployment model.

       

    • Package configurations.
    • Deploying packages.

      Lab 12: Working with Package Configurations.

    Module 13. Package Deployment Model: Execution, Security & Logging.
  • Package deployment model utilities.
  • Package execution.
  • Package security and encryption.
  • Package logging.

    Lab 13: Package Logging and Execution.

  • Module 14. Transactions and Restartability.
    • SSIS transactions.

       

    • SQL Server database snapshots.
    • Restartability with checkpoints.
    • Debugging with breakpoints.
    • Event Handlers.

      Lab 14: Working with Transactions and Checkpoints.

    Module 15.: Optimization and Scalability.
  • SQL code versus SSIS pipeline.
  • Data flow engine internals.
  • General optimization techniques.
  • Performance root-cause analysis.

    Lab 15: Identifying and Resolving SSIS Performance Issues.

  • Module 16. Solution Approach and Team Development.
  • Modular and parent package design.
  • Team development considerations.
  • Lab 16: Creating a Parent Package.
  • Contacta con Nosotros

    ¿Necesitas más información o un presupuesto para formación privada?