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 episodes
0
The Finance Reporting Query Library (Capstone) | SQL for Finance Ep8
The Finance Reporting Query Library (Capstone) | SQL for Finance Ep8
Watch Blog
1
Dates and Reporting Patterns: strftime, Fiscal Years, and AP Aging | SQL for Finance Ep7
Dates and Reporting Patterns: strftime, Fiscal Years, and AP Aging | SQL for Finance Ep7
Watch Blog
2
Window Functions: When Aggregates Shouldn't Collapse Your Rows | SQL for Finance Ep6
Window Functions: When Aggregates Shouldn't Collapse Your Rows | SQL for Finance Ep6
Watch Blog
3
Subqueries and CTEs: Stop Writing One Giant Query | SQL for Finance Ep5
Subqueries and CTEs: Stop Writing One Giant Query | SQL for Finance Ep5
Watch Blog
4
JOINs in Depth: Putting the Tables Back Together | SQL for Finance Ep4
JOINs in Depth: Putting the Tables Back Together | SQL for Finance Ep4
Watch Blog
5
Aggregations and GROUP BY: The Pivot Table, Replaced | SQL for Finance Ep3
Aggregations and GROUP BY: The Pivot Table, Replaced | SQL for Finance Ep3
Watch Blog
6
Filter, Sort, Pick: WHERE, ORDER BY, LIMIT in SQLite | SQL for Finance Ep2
Filter, Sort, Pick: WHERE, ORDER BY, LIMIT in SQLite | SQL for Finance Ep2
Watch Blog
7
Why SQL When You Have Excel: SQLite, AtlasParts, First Query | SQL for Finance Ep1
Why SQL When You Have Excel: SQLite, AtlasParts, First Query | SQL for Finance Ep1
Watch Blog