Free Resource: The Complete SQL Cheat Sheet

A complete cheat sheet for SQL

👋 Hey, this is David. Welcome to the next edition of the Data Engineering With David newsletter. The plan for Data Engineering With David is to create the resource I wish I had when I was in grad school learning to be a Data Engineer.

---

Today, I’m excited to share with you a free resource I’ve built.

I put together a complete cheat sheet for the SQL language. This cheat sheet is full of example queries. It covers a huge range of SQL topics including:

• Basic querying

• Filtering with WHERE

• Filtering with logical operators

• String wildcards

• Ordering query results

• Grouping and aggregating data

• Filtering aggregated data with HAVING

• Using CASE WHEN to create if/then logic

• Finding unique values with DISTINCT

• Joining multiple tables

• Unioning data together

• Writing CTE's and subqueries

• Manipulating data

• Window functions

Interested? You can get a copy of the cheat sheet for free here:

Not already a subscriber? Stay in the loop and be the first to know the next time I give away more free resources!