Beginner Level5 Tables
Banking Database SQL Tutorial
Bank system with branches, customers, accounts, transactions, and loans
🎯 What you'll practice: Customer records, Account balances, Transaction history, Loan tracking using real-world database scenarios.
📊 Database Tables
branches
Core banking data table
customers
Core banking data table
accounts
Core banking data table
transactions
Core banking data table
loans
Core banking data table
🔍 Common Query Patterns
Customers with Branch Name
List customers and their branch using a JOIN
SELECT c.first_name, c.last_name, b.branch_name
FROM customers c
JOIN branches b ON c.branch_id = b.branch_id
ORDER BY c.last_name;Total Balance by Account Type
Sum balances grouped by account type
SELECT account_type,
SUM(balance) as total_balance
FROM accounts
GROUP BY account_type
ORDER BY account_type;🚀 Ready to Practice?
Start practicing SQL queries with the banking database database. All tables are loaded and ready to use!