sql-patterns

Dec
31
How to Model Data by Refactoring SQL - Level 2

How to Model Data by Refactoring SQL - Level 2

How to model data by refactoring SQL queries across multiple dbt models to make them easier to read, maintain and debug.
4 min read
Dec
11
Refactoring SQL - Level 1

Refactoring SQL - Level 1

How to decompose SQL queries to make them easier to read, easier to maintain and debug.
3 min read
Dec
11
How to Write Modular SQL

How to Write Modular SQL

In this post we're going to learn one of the most important patterns in SQL: Modularity.
6 min read
Dec
13
How to Calculate Monthly Active Users (MAU) with SQL

How to Calculate Monthly Active Users (MAU) with SQL

Calculate MAU using simple SQL
3 min read