A query goes to a bar. He walks up to two tables and asks, “May I join you?”
Learn SQL: Here’s Your Beginner’s Roadmap
Have you asked yourself recently, “How do I get started learning SQL?” If you have, this is the place for you. Below are bite-sized lessons on the basic elements of SQL, as I learn them. Questions, comments requests? Let me know.
The start of my shared journey into SQL. This is my very first serious look into SQL and database management. Read now.
The fundamental actions and building blocks of working with SQL databases. Delete your first table?
One of the key common SQL database management tasks: restoring databases. Introducing more finesse and flexibility with database management.
We’re finally writing SQL queries and statements! Our first foray into SQL clauses and statements, the “Hello World” of SQL. Select your first step!
Data is messy, and often duplicated. The SELECT DISTINCT statement is an easy way to get back only the unique values. Learn more.
Segmentation rocks! SELECT WHERE is the first step in a journey of slicing through massive sluggishness of aggregate data sets to get phenomenal game-changing business insights.
Sometimes you need a quick validation of your work, without crashing the entire server. Maybe you only need the top [X] data points for a given question. The LIMIT statement is your friend here.
The next small step in the quest for segmentation is the BETWEEN statement. Say you need a list of lapsed customers from 2 weeks to 1 month ago. You don’t call Ghostbusters here, query with BETWEEN.
Large and complex data sets are a reality of data science. The LIKE statement employs pattern matching when you can’t remember what values you need to look up, or, when you just have plain messy or incomplete data.
Incrementing and innovating: emulating Excel’s pivot table functionality, at scale. Meet GROUP BY, our latest SQL Statement.
I know, we just did a skills test! But, it’s necessary to ensure we’re on the right path for SQL mastery. Get started.