EdX

SQL Concepts for Data Engineers (edX)

Offered by IBM,
SQL Concepts for Data Engineers (edX)

In this short course you will learn additional SQL concepts such as views, stored procedures, transactions and joins. This course builds on your existing SQL knowledge to learn about additional techniques that are key to Data Engineers.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

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.
This course is part of the following programs:

What you'll learn
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

Syllabus

Module 1 – Additional SQL

  • Using Views
  • Stored Procedures
  • Transactions
  • JOINs
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

SQL for Everyone (edX) EdX
Southern New Hampshire University,SNHUx

SQL for Everyone (edX)

Statistics & Data Analysis CS: Programming

This course introduces relational database concepts and helps you learn and apply foundational knowledge of SQL. The emphasis in this course is on hands-on and practical learning. Structured Query Language (SQL) is a standardized programming language used to manage relational databases and perform various operations on their data. This is the first course of a two-part series to introduce relational database concepts and help you learn and apply foundational knowledge of SQL.

Self Paced
Self-Paced
Databases SQL Relational Databases
Details
Building ETL and Data Pipelines with Bash, Airflow and Kafka (edX) EdX
IBM

Building ETL and Data Pipelines with Bash, Airflow and Kafka (edX)

Engineering Computer Science

This course provides you with practical skills to build and manage data pipelines and Extract, Transform, Load (ETL) processes using shell scripts, Airflow and Kafka. Well-designed and automated data pipelines and ETL processes are the foundation of a successful Business Intelligence platform. Defining your data workflows, pipelines and processes early in the platform design ensures the right raw data is collected, transformed and loaded into desired storage layers and available for processing and analysis as and when required.

Self Paced
Self-Paced
ETL Kafka Bash
Details
Introducción a SQL y bases de datos relacionales (edX) EdX
Universitat Politècnica de València,UPValenciaX

Introducción a SQL y bases de datos relacionales (edX)

CS: Software Engineering

Conoce las bases de datos relaciones y aprende SQL, el lenguaje estándar usado en el software empresarial que te permitirá consultarlas y extraer de ellas la información que necesites. El mayor activo de las empresas actuales son sus datos, datos que, mayoritariamente se alojan en bases de datos relacionales en línea. Prácticamente todos los sistemas de gestión de bases de datos relacionales utilizados en la actualidad utilizan SQL como herramienta para manipular y consultar los datos que contienen.

Self Paced
Self-Paced
Databases SQL Relational Databases
Details
Relational Database Basics (edX) EdX
IBM

Relational Database Basics (edX)

Statistics & Data Analysis

This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS). This course is an introduction to the world of relational databases. You will explore the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS), learn about relational database design, and understand how to transform source data into tables with clearly defined relationships.

Self Paced
Self-Paced
SQL MySQL PostgreSQL
Details
Structured Database Environments with SQL (edX) EdX
Southern New Hampshire University,SNHUx

Structured Database Environments with SQL (edX)

Statistics & Data Analysis

Discover Structured Query Language (SQL) programming basics in relation to database management and data manipulation. This course can provide you with an overview of topics like joins, database schemas, database design and importing data into a database. Develop the skills necessary to create structured database environments using a relational database management system (RDBMS), such as MySQL, that incorporates basic processing functionality and allows for data management, data manipulation and data analysis.

Self Paced
Self-Paced
SQL Data Analysis Database Management
Details