Ir al contenido principal

SQL Concepts for Data Engineers

In this short course you will learn additional SQL concepts such as views, stored procedures, transactions and joins.

SQL Concepts for Data Engineers

Hay una sesión disponible:

After a course session ends, it will be archivado.
Comienza el Jul 23
1 semanas estimadas
4–5 horas por semana
A tu ritmo
Avanza a tu ritmo
Gratis
Cambio opcional de categoría disponible

Sobre este curso

Omitir Sobre este curso

Please Note: Learners who successfully complete this IBM course can earn a skill badge — a detailed, verifiable and digital credential that profiles the knowledge and skills you’ve acquired in this course. Enroll to learn more, complete the course and claim your badge!

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.

Premios

SQL Concepts for Data Engineers

De un vistazo

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

Acerca de los instructores

¿Te interesa este curso para tu negocio o equipo?

Capacita a tus empleados en los temas más solicitados con edX para Negocios.