Capstone: Your Personal Budget Tracker
Explore how to apply CRUD operations in SQL to track personal budgets. Learn to formulate meaningful questions about spending habits, write queries to analyze categories and savings, and visualize results in an interactive dashboard using JSON and JavaScript. Gain practical skills for handling data, refining queries, and turning financial data into insightful reports.
We'll cover the following...
Ask a real question
Every great SQL project starts with a question, not with code. Imagine you’ve been logging your personal finances for a few months. Your table is called transactions, and it looks like this:
ID | Date | Category | Description | Amount | Type |
1 | 2025-01-03 | Rent | January Rent | 1200 | expense |
2 | 2025-01-05 | Salary | January Paycheck | 3500 | income |
3 | 2025-01-07 | Groceries | Supermarket | 85 | expense |
4 | 2025-01-10 | Transport | Monthly Metro Card | 110 | expense |
5 | 2025-01-11 | Dining | Lunch Out | 25 | expense |
Now ask yourself: What do I actually want to know about my spending habits?
For example:
Where does most of my monthly income go?
Which categories could I reduce?
How much ...