Categories
SQL 201

Conditional logic With the CASE expression

CASE is SQLs 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.

Categories
SQL 301

Why You Need SQL Window Functions (pt 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.

Categories
SQL 301

Why You Need SQL Window Functions (pt 1)

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

Categories
SQL 101

Bite-Sized Videos For Beginners

Each of these Videos For Beginners is just long enough to get you started, with room to dive into the topic when you feel ready.

Categories
AWS

Gently Down the Stream with AWS Kinesis

Gone are the days of batch processing, AWS Kinesis allows you to run analytics on the fly and shard streams for scalability

Categories
SQL 201

All About SQL Aggregate Functions

Time for some fun with SQL aggregate functions, and Mariah Carey

Categories
Business Intelligence Data Technology

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

Categories
SQL 201

6 Ways to Search With System Tables

Your database doesn’t just contain your data. It also contains data about your data.

Categories
AWS Data Technology Projects

The Great Migration: From SQL Server to AWS Aurora

This is a retrospective covering some of the learnings of ‘Project Aurora’. A nine-month project to migrate 60 users from SQL Server to AWS Aurora.