SQL for Data Engineers

What You Will Learn:

Introduction to Database Management and SQL

Get acquainted with Database Management Systems (DBMS) and the role of SQL in data engineering. Understand how relational databases store, manage, and process large volumes of data.

Practice with the Chinook Database and Tool Setup

You will start working with real data using the Chinook Database - an educational database that helps you master key SQL concepts. We will set up SQLite and DBeaver - necessary tools for managing databases and writing queries.

SQL Basics: DDL and DML

You will delve into the fundamental sections of SQL - Data Definition Language (DDL) and Data Manipulation Language (DML). Learn how to create, modify, and manage tables and records: insert, update, delete data.

Advanced Queries: SELECT, Grouping, and Joins

In the next stage, you will master advanced techniques for working with SELECT queries, aggregate functions, and JOINs. These skills are essential for working with multiple tables and extracting analytically valuable information.

Transaction Management and Data Integrity

You will study the Transaction Control Language (TCL) and understand how to maintain data integrity and reliability in working with DBMS.

Common Table Expressions and Subqueries

Learn to simplify complex SQL queries using CTE (Common Table Expressions) and subqueries, making your code more readable and maintainable.

Window Functions

In a separate four-part module, you will discover window functions: aggregate, ranking, and analytics. These allow you to perform calculations across rows with maximum flexibility.

Query Optimization and Indexing

At the end of the course, you will learn to optimize SQL queries and use indexes to improve performance. Special attention is given to practices in SQLite, but the principles apply to any relational DBMS.