👋 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!
No posts
Comments
Nothing yet. Say the first thing.
Sign in to join the conversation.