• Duración:
    6 semanas
  • Dedicación:
    2–4 horas por semana
  • Precio:

    GRATIS
    Add a Verified Certificate for $99 USD

  • Institución
  • Tema:
  • Nivel:
    Intermediate
  • Idioma:
    English
  • Transcripción de video:
    English

Prerrequisitos

A familiarity with Basic SQL Query and Transactional statements (select, insert, update, delete). Ability to write and execute statements using SQL Server Management Studio. A basic understanding of the Business Intelligence process.

Sobre este curso

Microsoft SQL Server Integration Services (SSIS) features graphical tools and wizards for:

  • building and debugging packages
  • tasks for performing workflow functions
  • executing SQL statements
  • data sources and destinations for extracting and loading data
  • transformations for cleaning, aggregating, merging, and copying data

In this computer science course, you'll extract data from a wide variety of data sources, such as files and relational data sources, perform data integration and transformation solutions, and load data into single or multiple destinations. You will solve complex business problems using best practices and troubleshooting techniques.

Lo que aprenderás

You’ll learn design principles and solutions for:

  • Deciding on full or incremental loading
  • Isolating ETL data
  • Creating an ETL script
  • ETL abstraction layers
  • The design environment
  • Control flows
  • Data sources
  • Data transformations
  • Data destinations
  • Precedence constraints
  • Connection managers
  • Execute SQL tasks
  • Progress/execution results
  • Resetting destination database
  • Data flows
  • Data flow paths
  • Error output paths
  • Configuring data sources and destinations
  • Executing SSIS packages
  • Deploying SSIS packages
0 | Module 0 - Start Here
  • Welcome to DAT217x: Implementing ETL with SQL Server Integration Services (SSIS)
  • Setting Up Your Lab Environment in Azure
1 | Module 1 - ETL Processing
  • ETL Overview
  • ETL Tools
  • Data Sources and Destinations
  • Creating Example Databases
  • Module Assessment
  • Module Summary
2 | Module 2 - ETL with SQL Programming
  • ETL Scripts
  • Transformations
  • Implementing ETL with SQL Objects
  • Lab | Programming an ETL Process with SQL
  • Module Assessment
  • Module Summary
3 | Module 3 - ETL Processing with SSIS
  • Creating SSIS Projects
  • Programming SSIS Packages
  • Execute SQL Tasks
  • Implementing SSIS Packages
  • Lab | Creating an ETL Process with SSIS
  • Module Assessment
  • Module Summary
4 | Module 4 - SSIS Data Flows
  • Creating Data Flows
  • Data Flow Transformations
  • Performance Options
  • Lab | Creating an SSIS ETL Package Using Data Flow Tasks
  • Module Assessment
  • Module Summary
5 | Module 5 - Deployment and Troubleshooting
  • Error Handling
  • Deployment
  • Module Assessment
  • Module Summary
6 | Module 6 - Final
  • Final Assessment
  • Bonus Video
  • Post-Course Survey

Conoce a tus instructores

Randal Root
Lecturer
University of Washington
Cari Mason
Content Developer
Microsoft
Joey Chemis
Data Scientist and Software Engineer
Microsoft

Obtén un Certificado Verificado para destacar los conocimientos y las habilidades que adquieras $99.00

Ver un modelo de certificado de edX en PDF
  • Oficial y verificado

    Obtén un certificado con la firma del instructor y el logotipo de la institución para demostrar tus logros y aumentar las posibilidades de conseguir trabajo

  • Fácil de compartir

    Agrega el certificado a tu currículum o publícalo directamente en LinkedIn

  • Incentivo comprobado

    El certificado te da un motivo más para completar el curso

  • Apoya nuestra labor

    edX, una organización sin fines de lucro, se sustenta con los certificados verificados para financiar la educación gratuita para todo el mundo