• Duración:
    1 semanas
  • Dedicación:
    4–5 horas por semana
  • Precio:

    GRATIS
    Agregar un Certificado Verificado por $99 USD

  • Institución
  • Tema:
  • Nivel:
    Intermediate
  • Idioma:
    English
  • Transcripción de video:
    English
  • Tipo de curso:
    A tu ritmo

Programas asociados:

Sobre este curso

Omitir Sobre este curso

This course builds on your existing SQL knowledge to learn about additional techniques that are key to Data Engineers.

You will learn how to create and use views to simplify and control access to underlying tables. You will learn about the advantages provided by stored procedures and how to write and run them. You will discover the importance of ACID transactions to maintain the integrity of your data and how to use them in your code. Finally, you will learn how to use different types of joins to accurately retrieve related data from multiple tables.

PRE-REQUISITE: This course is intended as a follow on to SQL for Data Science course from IBM. Please ensure that you have either completed that course prior to starting this one, or have foundational/intermediate knowledge of SQL and are familiar with creating tables, performing select statements, filtering, sorting and grouping data, and working with nested queries and multiple tables.

Lo que aprenderás

Omitir Lo que aprenderás

In this course you will learn about:

  • Creating and using views
  • Creating and executing stored procedures
  • Working with ACID transactions
  • Using different types of JOIN operators

Plan de estudios

Omitir Plan de estudios

Module 1 – Additional SQL

  • Using Views

  • Stored Procedures

  • Transactions

  • JOINs

Conoce a tus instructores

Rav Ahuja
AI and Data Science Program Director
IBM

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

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