SQL aggregate functions and Mariah Carey
Aggregate functions bring your data to life.
They allow you to take a standard table and use a function or two to build metrics and answer questions about the data.
Category: Data Analysis & SQL
Entity-relationship diagrams
On first glance, Entity Relationship Diagrams may look like a spaghetti mess. This post hopes to demystify how they fit together with Sonic the Hedgehog
Search with system tables
Your database doesn’t just contain your data. It also contains data about your data.
A database is like a dance class
As I was having a hard time switching off from work this week, I thought: a ballet lesson would be a great way to discuss database concepts.
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.
Speed up SQL queries with indexes
Your query is running slow, have you checked your indexes?
