6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
Curso
En México
¿Necesitas un coach de formación?
Te ayudará a comparar y elegir el mejor curso para ti y a financiarlo en cómodas cuotas mensuales.
Descripción
-
Tipología
Taller intensivo
-
Lugar
México
-
Horas lectivas
7h
-
Duración
3 Días
-
Inicio
Fechas disponibles
Aprenda a implementar soluciones de Integration Services en una organización. El curso le ayudará a desarrollar, implementar y administrar paquetes de Integration Services así como a proteger sus datos de forma segura.
Sedes y fechas disponibles
Ubicación
Inicio
Inicio
Opiniones
Materias
- Podrá habilitar bases de datos modernas
- Solucionará la movilidad de grandes datos
- Logrará crear y optimizar bases de datos
- Analizará bases de datos con SQL
- Protegerá sus datos en la base
Programa académico
- Overview of SQL Server Integration Services
- Using Integration Services Tools
- (Level 200) Using the Import and Export Wizard
- (Level 200) Running an Integration Services Package
- Describe Integration Services solutions
- Use Integration Services tools
- Creating an Integration Services Solution
- Using Variables
- Building and Running a Solution
- (Level 200) Creating an Integration Services Project
- (Level 200) Implementing a Package
- (Level 200) Building and Running an Integration Services package
- Create a SQL Server Integration Services solution.
- Use variables.
- Build and run a solution.
- Control Flow Tasks
- Control Flow Precedent Constraints
- Control Flow Containers
- (Level 200) Creating a Simple Control Flow
- (Level 200) Configuring Precedence Constraints
- (Level 200) Using Containers
- Configure control flow tasks.
- Configure control flow precedence constraints.
- Configure control flow containers.
- Data Flow Sources and Destinations
- Basic Data Flow Transformations
- Advanced Data Flow Transformations
- Data Flow Paths
- (Level 200) Transferring Data
- (Level 200) Implementing Transformations
- (Level 200) Using Data Viewers
- (Level 200) Configuring Error Output
- Implement data flow sources and destinations.
- Implement basic data flow transformations.
- Implement advanced data flow transformations.
- Implement data flow paths.
- Overview of Integration Services Logging
- Enabling and Configuring Logging
- (Level 200) Configuring Logging
- (Level 200) Implementing Custom Logging
- Describe Integration Services logging.
- Implement Integration Services logging.
- Debugging a Package
- Implementing Error Handling
- (Level 300) Debugging a Package
- (Level 300) Implementing Error Handling
- (Level 300) Controlling Failure Behavior
- Debug an SSIS package.
- Implement error handling.
- Implementing Checkpoints
- Implementing Transactions
- (Level 200) Implementing Checkpoints in a Package
- (Level 300) Implementing Transactions in a Package
- (Level 300) Implementing a Native Transaction
- Implement checkpoints.
- Implement transactions.
- Package Configurations
- Deploying Packages
- (Level 200) Creating a Package Configuration
- (Level 200) Preparing a Package for Deployment
- (Level 200) Deploying a Package
- Implement package configurations.
- Deploy packages.
- Managing Packages
- Securing Packages
- (Level 200) Importing a Package
- (Level 200) Configuring and Monitoring a Package
- (Level 200) Scheduling a Package
- (Level 200) Securing a Package
- Manage packages.
- Secure packages.
- Exposure to enterprise data import and export scenarios.
- Experience navigating the Microsoft Windows Server environment.
- Experience with Microsoft SQL Server, including:
- SQL Server Agent.
- SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
- SQL Server System tables.
- SQL Server accounts (users and permissions).
- Visit the training and certification forum
- Visit our MCP newsgroups
- Visit the Microsoft Learning community
¿Necesitas un coach de formación?
Te ayudará a comparar y elegir el mejor curso para ti y a financiarlo en cómodas cuotas mensuales.
6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services