SQL Database Projects

Design a complete normalized database for an e-commerce platform (customers, products, orders, payments, reviews). Write complex SQL queries for sales analytics, inventory reports, and customer behavior analysis.

Build and query an HR database with employee, department, payroll, and attendance tables. Write window function queries for salary rankings, department statistics, and attrition analysis with optimization using indexes.

Create a complete set of stored procedures, functions, and triggers for a banking database: account creation, fund transfer with transaction control, audit logging triggers, and monthly statement generation procedures.