Skip to content
🗄️

Databases & SQL

15 projects

Hands-on projects for databases & sql.

  1. 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. 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. 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. 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. 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. 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. 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. 8

    Normalized Library Catalog

    Design a normalized library database with books, authors, publishers, and categories. Practice normalization to 3NF.

    Medium ~25 min
  9. 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. 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. 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. 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. 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. 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. 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