SQL

SQL Joins, CTEs, and Window Functions Explained

The second half of Chapter 4 in Data Engineering for Beginners by Chisom Nwokwu (ISBN 9781394325412) is where SQL goes from “filter a table” to “actually analyze data across tables.” This is the part that makes SQL feel like a real data engineering skill.

Database Fundamentals: SQL vs NoSQL and Why ACID Still Matters

Book: Data Engineering for Beginners
Author: Chisom Nwokwu
ISBN: 9781394325412

Chapter 3 zooms in on storage. After the life cycle overview, Nwokwu focuses on databases, the tool data engineers spend a huge amount of time with. This chapter is dense but practical. It covers what databases are, how relational and NoSQL systems differ, and how to pick the right one for your project.

SQL Basics: SELECT, WHERE, and Aggregate Functions

This is Part 1 of Chapter 4. Part 2 covers joins and advanced queries.

Chapter 4 is where Nwokwu puts SQL in your hands. No more theory. You write queries, you get results, you learn by doing. If Chapter 3 was about understanding what databases are, this chapter is about talking to them.