← All blog series

SQL for Finance

Eight-episode series teaching SQL to finance and accounting professionals using SQLite and the AtlasParts dataset. The bridge from Excel and Power BI into the language the rest of the data team speaks.

8 posts

0
SQL for Finance: The Finance Reporting Query Library (Capstone)

SQL for Finance: The Finance Reporting Query Library (Capstone)

Celest Kim•Video•Quiz available
1
SQL for Finance: Dates and Reporting Patterns: strftime, Fiscal Years, and AP Aging

SQL for Finance: Dates and Reporting Patterns: strftime, Fiscal Years, and AP Aging

Celest Kim•Video•Quiz available
2
SQL for Finance: Window Functions: When Aggregates Shouldn't Collapse Your Rows

SQL for Finance: Window Functions: When Aggregates Shouldn't Collapse Your Rows

Celest Kim•Video•Quiz available
3
SQL for Finance: Subqueries and CTEs: Stop Writing One Giant Query

SQL for Finance: Subqueries and CTEs: Stop Writing One Giant Query

Celest Kim•Video•Quiz available
4
SQL for Finance: JOINs in Depth: Putting the Tables Back Together

SQL for Finance: JOINs in Depth: Putting the Tables Back Together

Celest Kim•Video•Quiz available
5
SQL for Finance: Aggregations and GROUP BY: The Pivot Table, Replaced

SQL for Finance: Aggregations and GROUP BY: The Pivot Table, Replaced

Celest Kim•Video•Quiz available
6
SQL for Finance: Filter, Sort, Pick: WHERE, ORDER BY, LIMIT in SQLite

SQL for Finance: Filter, Sort, Pick: WHERE, ORDER BY, LIMIT in SQLite

Celest Kim•Video•Quiz available
7
SQL for Finance: Why SQL When You Have Excel: SQLite, AtlasParts, First Query

SQL for Finance: Why SQL When You Have Excel: SQLite, AtlasParts, First Query

Celest Kim•Video•Quiz available