SQL window functions are incredibly powerful and allow us to see the rows in a table with a new column showing a running total, rank or moving average.
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.
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
Your database doesn’t just contain your data. It also contains data about your data.
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.
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.