SystemCraft™ Companion Guide
SQL Essentials Companion Guide
Query, Join, and Shape Data with Confidence
What you'll learn
- Clear explanations of joins, grouping, and subqueries
- A consistent sample schema used across every example
- Transaction safety habits for UPDATE and DELETE
- Scenario-based troubleshooting for the errors every SQL user hits
- A printable one-page cheat sheet for your desk
Table of contents
- 01
Getting Started
What a relational database actually is, and the anatomy of a SELECT statement
- 02
Filtering and Sorting
Narrowing down and ordering the rows you get back — the WHERE and ORDER BY clauses in depth
- 03
Joins
Combining data that lives in more than one table — the core skill of real SQL work
- 04
Aggregation and Grouping
Turning many rows into summarized answers — aggregate functions, GROUP BY, and HAVING
- 05
Modifying Data
INSERT, UPDATE, DELETE, and the transaction safety net around all three
- 06
Schema Design and Keys
How tables, keys, and constraints fit together, and why data gets split across tables in the first place
- 07
Subqueries, CTEs & Views
Breaking complex problems into readable pieces — subqueries, common table expressions, and views
- 08
Quick Reference
Syntax, function, and clause lookup tables for daily SQL use
- 09
Troubleshooting
Scenario-based fixes for the errors and gotchas every SQL user eventually hits
Who this is for
A practical, no-fluff reference for developers who want to write real queries with confidence, not copy-paste from search results.
Other guides in the series
Command Line Essentials
Navigate, Automate, and Troubleshoot with Confidence
A practical, no-fluff reference for developers who want to actually understand the terminal, not just paste commands they found online.
Git & GitHub
From First Commit to Confident Collaboration
A practical, no-fluff reference built for developers who want to actually understand Git, not just memorize commands.
JavaScript Essentials
From First Script to Confident Async
A practical, no-fluff reference for developers who want to actually understand JavaScript, not just copy snippets from search results.
Python Essentials
From First Script to Confident Code
A practical, no-fluff reference built for developers who want to actually understand Python, not just copy syntax.
VS Code Essentials
Edit, Debug, and Ship Faster
A practical, no-fluff reference for developers who want to stop clicking around and start actually using their editor.