Conditional logic with the CASE expression
CASE is SQL’s answer to other programming languages IF-ELSE statement. If you need to test a condition and return a value CASE is the expression you need.
Showing 17 Result(s)
Why you need SQL Window Functions (part 2)
SQL Server Window Functions are incredibly powerful and allow us to access a total from another row and bucket data to show top performers.
Why you need SQL Window Functions (part 1)
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.
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.
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
Pearl Jam, Nirvana and beautiful data visualisations
This is the story of the Seattle music scene of the 90s, Throwback Thursday, and some beautiful data visualisations.
