A database is like a dance class
This week I got to thinking, a ballet class is a good way to describe database concepts.
Tag: sql
SQL concepts from A to Z
This post covers the SQL concepts that pop up during training. If you need a refresher or have a junior analyst in your life who needs a resource to refer to, keep reading.
Resources for new analysts
Everything you need to get started with SQL and becoming a great data analyst.
Speed up SQL queries with indexes
Your query is running slow, have you checked your indexes?
SQL Joins without the Venn diagrams
Joining tables is the first big learning curve after getting your head around SQL basics.
Why I use SQL CTEs
CTEs are underrated compared to the subquery. Here’s why I prefer to use CTEs when building SQL queries.
