SQL is the foundation for working with relational databases. If you plan to work in the field of Data Engineering, knowledge of SQL is not just a plus but a necessity. That's why we created this course: "SQL for Data Engineers". It will provide you with the essential skills for effective database management—from data extraction and analysis to executing complex queries and operations that you will encounter daily.
SQL for Data Engineers
1h 51m
English
Paid
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.
About the Author: Andreas Kretz
I am a senior data engineer and trainer, a tech enthusiast, and a father. For more than ten years, I have been passionate about Data Engineering. Initially, I became a self-taught data engineer and then led a team of data engineers at a large company. When I realized the great demand for education in this field, I followed my passion and founded my own Data Engineering Academy. Since then, I have helped over 2,000 students achieve their goals.
Watch Online 16 lessons
0:00
/ #1: Introduction
All Course Lessons (16)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Introduction Demo | 02:05 | |
| 2 | Database Management Systems & SQL | 03:50 | |
| 3 | The Chinook Database | 03:04 | |
| 4 | SQLite Installation | 07:03 | |
| 5 | Dbeaver Installation | 04:09 | |
| 6 | Data Types in SQLite | 06:16 | |
| 7 | DML & DDL | 15:07 | |
| 8 | Select Statements | 06:04 | |
| 9 | Grouping & Aggregation | 10:13 | |
| 10 | Joins | 10:06 | |
| 11 | TCP Transaction Control Language | 06:43 | |
| 12 | Common Table Expressions & Subqueries | 10:27 | |
| 13 | Window Functions 1: Concept & Syntax | 05:01 | |
| 14 | Window Functions 2: Aggregate Functions | 07:25 | |
| 15 | Window Functions 3: Ranking Functions | 06:06 | |
| 16 | Window Functions 4: Analytical Functions | 07:21 |
Unlock unlimited learning
Get instant access to all 15 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionBooks
Read Book SQL for Data Engineers
| # | Title |
|---|---|
| 1 | SQL_For_Data_Engineers_Cheat_Sheet |
| 2 | Query Optimization |
| 3 | Indexing best practices |