SQL Server Integración Servicios (55321)

Curso Disponible presencial o en Línea

Duración: 35 horas.

¡Quiero saber más sobre el curso de SQL Server Integración Servicios (55321)!

¿Qué aprenderás en el curso de SQL Server Integración Servicios (55321)?

bases de datos que necesitan cumplir un rol de desarrollador de Inteligencia de Negocios. Deberán centrarse en el trabajo práctico creando soluciones de BI, incluida la implementación de Data Warehouse, ETL y limpieza de datos.

Descripción

Este curso de cinco días dirigido por un instructor está dirigido a profesionales de TI que necesitan aprender a usar SSIS para crear, implementar, mantener y proteger proyectos y paquetes de Integration Services, y para usar SSIS para extraer, transformar y cargar datos hacia y desde SQL Server.

Este curso es similar al curso retirado 20767-C: Implementación de un almacén de datos SQL, pero se centra más en la creación de paquetes, en lugar de en todo el diseño e implementación del almacén de datos.

Cree paquetes SSIS sofisticados para extraer, transformar y cargar datos
Utilice contenedores para controlar de manera eficiente las tareas y transacciones repetitivas
Configurar paquetes para que se adapten dinámicamente a los cambios del entorno
Usar los servicios de calidad de datos para limpiar los datos
Solucionar correctamente los paquetes
Crear y administrar el catálogo de SSIS
Implementar, configurar y programar paquetes
Proteger el catálogo de SSIS

El conocimiento práctico de los trabajos de T-SQL y del Agente SQL Server es útil, pero no obligatorio.
Conocimientos básicos del sistema operativo Microsoft Windows y su funcionalidad principal.
Conocimiento práctico de bases de datos relacionales.
Algo de experiencia con el diseño de bases de datos.

This module explains the purpose of SSIS and teaches how to use the Import/Export Wizard to exchange data between data structures.

Import/Export Wizard
Exporting Data with the Wizard
Common Import Concerns
Quality Checking Imported/Exported Data

Use the Import/Export Wizard from SSMS

Export data with the wizard.
Import data with the wizared.
Do a quality check on imported and exported data.

In this module, students learn to work with SQL Server Data Tools (SSDT) to design and deploy reports.

Working with SQL Server Data Tools
Understanding Solutions and Projects
Working with the Visual Studio Interface

Import and run a package in SSDT-BI

Work with SQL Server Data Tools.
Understand solutions and projects.
Work with the Visual Studio interface.

The Control Flow tab of the SSIS Designer is used to organize the general flow of your package execution. The control flow of a package includes different element types, such as tasks, containers, and precedence constraints. Each of these element types has a set of properties that you will use to define and manage individual instances of these elements. In this module, students learn to add containers or tasks from the SSIS Toolbox to the Control Flow Designer.

Working with Tasks
Understanding Precedence Constraints
Annotating Packages
Grouping Tasks
Package and Task Properties
Connection Managers
Favorite Tasks

Precedence Constraints and Execute SQL Task

Understand the control flow.
Work with tasks.
Understand precedence constraints.
Annotate packages.
Group tasks.
Work with package and task properties.
Work with connection managers.

Microsoft has organized the tasks in the Common section of the SSIS Toolbox alphabetically. This module will touch on the functionality of each of these tasks, and provide Try It exercises for the tasks that are most commonly seen in classes and companies.

Analysis Services Processing
Data Profiling Task
Execute Package Task
Execute Process Task
Expression Task
File System Task
FTP Task
Hadoop Task
Script Task Introduction
Send Mail Task
Web Service Task
XML Task

Create a package to copy a file and send an email message on completion
Create a package to perform data profiling and then review the results
Create a master package and test the execution flow of the child packages

Work with Analysis Services processing.
Insert tasks in bulk.
Use the Data Profiling task.
Use the Execute Package task.
Use the Execute Process task.
Use the Expression task.
Use the File System task.
Use the FTP task.
Use the Hadoop tasks.
Use the Script task Introduction.
Use the Send Mail task.
Use the Web Service task.
Use the XML task.

In this module, students will learn to work with data flow sources and destinations.

The Data Flow Task
The Data Flow SSIS Toolbox
Working with Data Sources
SSIS Data Sources
Working with Data Destinations
SSIS Data Destinations

Working with Data Sources and Destinations

Use the Data Flow Task.
Use the Data Flow SSIS Toolbox.
Work with Data Sources.
Work with Data Destinations.
Understand SSIS Data Destinations.

In this module, students learn about transformations, which allow you to modify data in the data flow pipeline.

Transformations
Configuring Transformations

Working with Derived Column Transformations
Working with Lookup Transformations

Working with Derived Column Transformations
Working with Lookup Transformations

In this module, students will learn to make SSIS packages dynamic.

Features for Making Packages Dynamic
Package Parameters
Project Parameters
Variables
SQL Parameters
Expressions in Tasks
Expressions in Connection Managers
After Deployment
How It All Fits Together

Making a Package Dynamic

Understand the features for making packages dynamic.
Use package parameters.
Use project parameters.
Use variables.
Use sql parameters.
Use expressions in tasks.
Use expressions in connection managers.
Understand how it all fits together.

In this module, students learn to use containers, which provide a way to organize tasks that need to be managed together as a group.

Sequence Containers
For Loop Containers
Foreach Loop Containers

Use a Foreach Loop container to send a custom email to the names found in a database view

Work with containers.
Sequence containers.
Use For Loop containers.
Use Foreach Loop containers.

This module puts together common troubleshooting methods along with some of the reliability features for SSIS all in one place.

Understanding MaximumErrorCount
Breakpoints
Redirecting Error Rows
Logging
Event Handlers
Using Checkpoints
Transactions

Creating a Script Task to Merge Error Messages
Configure a package to use transactions

Understand MaximumErrorCount.
Work with breakpoints.
Redirect Error Rows.
Use Logging.
Use Event Handlers.
Use Checkpoints.
Use Transactions.

The project deployment model provides the framework for new functionality such as the SSIS catalog, environments, project level parameters and project level connection managers. This module explains how to deploy projects to the SSIS catalog.

The SSIS Catalog
Deploying Projects
Working with Environments
Executing Packages in SSMS
Executing Packages from the Command Line
Deployment Model Differences

Deploying a Project to the SSIS Catalog
Manually executing a Package

Understand SSIS deployment and the SSIS catalog.
Deploy Projects.
Work with Environments.
Execute packages in SSMS.
Execute packages from the command line.

In this module, students will learn to install, upgrade, and administer SSIS.

Installing SSIS
Upgrading SSIS
Managing the SSIS Catalog
Viewing Built-in SSIS Reports
Managing SSIS Logging and Operation Histories
Automating Package Execution

Automating Package Execution

To install SSIS.
To upgrade SSIS.
To manage the SSIS catalog.
To view built-in SSIS reports.
To manage SSIS logging and operation histories.
To automate package execution.

In addition to the standard SQL Server database and instance permissions that can be configured like any other database, the SSIS catalog has special pre-defined database roles and additional permissions that can be assigned for the management and execution of SSIS packages. In this module, students learn to work with roles and permissions to secure the SSIS catalog.

Principals
Securables
Grantable Permissions
Granting Permissions
Configuring Proxy Accounts

Securing the SSIS Catalog

Understand principals.
Understand securables
Grant Permissions.
Configure proxy accounts.

Preguntas frecuentes

El precio de los cursos de Excel varía según el nivel. Preguntanos y con gusto te asesoramos.

Para darte mayor información por favor llámanos al 4422150021 o dejanos un WhatsApp 4421817545

Del Mesón 186-Int 12, Col del Prado, 76030 Santiago de Querétaro, Qro.

Estamos junto al edificio de Telmex de Tecnológico a una cuadra de Zaragoza. Puedes estacionarte junto al edificio Tec100 / Nippo en una explanada grande, es una opción muy económica.

Es correcto, al finalizar el curso se entrega una constancia certificada por Executrain, que te ayudará a demostrar tus habilidades.

Claro, en Executrain contamos con más de 30 años de experiencia brindando servicios de capacitación y consultoría a empresas en el Bajío. Puedes buscarnos en Google como Executrain Querétaro para consultar las recomendaciones de los alumnos.

SI claro, solo envía tu constancia de situación fiscal y con gusto te facturamos.

Te ofrecemos una gran cantidad de opciones de certificación, tanto la capacitación como los exámenes pues somos Centro VUE.

Cursos relacionados

Disponible online o presencial