Databases & SQL
15 projects
Hands-on projects for databases & sql.
- 1
Blog Database Schema
Design and build a relational database schema for a blog with posts, authors, and comments. Practice CREATE TABLE, foreign keys, and relationships.
Beginner ~15 min - 2
Inventory Management Queries
Build a set of SQL queries to manage product inventory: add products, update stock, and find low-stock items.
Beginner ~15 min - 3
User Authentication Schema
Design a secure user authentication database with unique emails, password hashes, and roles. Practice constraints and indexes.
Easy ~20 min - 4
Student Gradebook with Joins
Build a gradebook database and write JOIN queries to combine student, course, and grade data. Practice INNER and LEFT JOINs.
Easy ~20 min - 5
Sales Analytics Dashboard Queries
Build a set of aggregation and GROUP BY queries for a sales analytics dashboard. Practice COUNT, SUM, AVG, and HAVING.
Medium ~25 min - 6
E-commerce Order System
Design a complete e-commerce database with customers, products, orders, and order items. Practice complex relationships.
Medium ~25 min - 7
Safe Bank Transfer with Transactions
Build a bank transfer system using SQL transactions. Practice BEGIN, COMMIT, ROLLBACK, and ACID properties.
Medium ~20 min - 8
Normalized Library Catalog
Design a normalized library database with books, authors, publishers, and categories. Practice normalization to 3NF.
Medium ~25 min - 9
MongoDB Document Store
Build a MongoDB-style document store for a blog using flexible JSON documents. Practice NoSQL design patterns.
Easy ~15 min - 10
Database Migration Script
Write a set of database migration scripts that evolve a schema over time. Practice ALTER TABLE and versioned migrations.
Medium ~20 min - 11
Advanced JOINs and Subqueries
Master complex JOINs — self-joins, anti-joins, CROSS APPLY, and correlated subqueries. Practice the most powerful SQL query patterns.
Medium ~35 min - 12
Window Functions and CTEs
Master window functions (OVER, PARTITION BY, ROW_NUMBER, RANK) and Common Table Expressions (CTEs) for complex analytical queries.
Medium ~40 min - 13
Stored Procedures and Functions
Write stored procedures and user-defined functions. Practice encapsulating business logic in the database with parameters and return values.
Medium ~40 min - 14
Query Optimization and EXPLAIN
Learn to analyze query plans with EXPLAIN, identify bottlenecks, and optimize with indexes, rewritten queries, and denormalization.
Medium ~45 min - 15
E-Commerce Database Design
Design a complete normalized database schema for an e-commerce platform. An open-ended project covering normalization, relationships, constraints, and indexing strategy.
Medium ~60 min