SQL Projects for Your Resume (2026)

Guided SQL projects on realistic business databases: hospital operations, product analytics, supply chain, finance and more. Each one is a question a data analyst is actually asked, answered with joins, CTEs and window functions.

30 projects: 5 beginner, 19 intermediate, 6 advanced. Every step is checked as you go, an AI mentor helps when you are stuck, and you finish with a verifiable certificate.

SQL projects

SQL from Zero: Answer a Bookshop's Questions from Its Database — Learn SQL from zero on a bookshop's database: SELECT, GROUP BY, joins, dates and RANK. Then direct your own AI through the same questions and catch what it gets wrong. (beginner · $1)
Data-Driven Decision Making: Excel and SQL for Business Analysts — Follow business analyst Renata Cruz as she uses Excel, pivot tables, and SQL to answer real Cobalt Bicycles questions - and catch the analysis mistakes that mislead decisions. (beginner · $1.25)
SQL Mastery: From Queries to Query Optimization — Master SQL from core queries to window functions, execution plans, and performance tuning through a real e-commerce analytics story. (intermediate · $1)
CTEs and Window Functions in SQL: Subscription Churn Metrics — Build a SaaS company's MRR, churn, MRR bridge and net revenue retention in SQL with CTEs and window functions. Then direct your own AI through the same job and catch its mistakes. (intermediate · $1.25)
Database Reliability Engineering — Follow a marketplace's Postgres team as a database outage forces them to build real SLOs, a tested backup strategy, and a fast, drilled failover process. (advanced · $2)
Data Engineering Capstone: Ingestion to Dashboard End to End — Follow a data engineer building a full pipeline for a growing retailer: extract sources, load a warehouse, transform clean models, orchestrate with alerts, and ship a BI dashboard. (advanced · $2.50)
Testing and CI/CD for Data Pipelines — Test dbt models and Python transforms, wire CI to run on every PR, and roll out pipeline schema changes safely with a real rollback plan. (intermediate · $1.50)
Amazon Redshift Fundamentals: Distribution Styles and Performance Tuning — Learn Redshift's architecture, distribution styles, sort keys, workload management, and vacuuming through a streaming company's fight against a slow, skewed cluster. (intermediate · $1.50)
Analytics Engineering Fundamentals: Modeling Data for BI Consumption — Learn to transform raw data into clean, trusted, BI-ready tables through staging, intermediate, and mart layers, with real SQL, semantic consistency, and dbt-style testing. (intermediate · $1.50)
BigQuery for Data Engineers: Partitioning, Clustering, and Query Optimization — Learn BigQuery's serverless architecture, partitioning, clustering, and query cost optimization through a logistics startup's real data-scaling story. (intermediate · $1.50)
Data Modeling Fundamentals: Star Schema, Snowflake Schema, and Normalization — Learn star schema, snowflake schema, and normalization through a furniture company's real data modeling journey, from 3NF to SCD Type 2. (intermediate · $1)
Database Design and Indexing for Analytics Workloads — Follow engineer Dara Okonkwo fixing a real Postgres analytics database: column types, composite and covering indexes, partitioning, materialized views, and diagnosing slow queries with EXPLAIN. (intermediate · $1.50)
dbt Fundamentals: Data Transformations as Code — Learn dbt through a real analytics engineering story: build models with ref()/source(), test data quality, generate docs and lineage, and write reusable macros in Jinja. (intermediate · $1.50)
ETL vs ELT: Building Your First Data Pipeline — Follow a first-time data engineer at a coffee company as she replaces manual CSV exports with an automated ELT pipeline: extraction, transformation, warehouse loading, and orchestration. (beginner · $1.50)
Real-Time Analytics: Streaming Data From Kafka Into a Warehouse Dashboard — Learn when real-time analytics beats batch, then stream Kafka events into a warehouse table and build a live, deduplicated dashboard with lag monitoring and outage recovery. (advanced · $2)
Snowflake Fundamentals: Warehousing, Scaling, and Cost Management — Learn Snowflake's architecture, warehouse scaling, efficient data loading, query performance, and cost governance through a real retailer's migration story. (intermediate · $1.50)
SQL for Finance: Accounts-Receivable Ageing and a Collections List — Build a distributor's receivables ageing, credit-hold list, call list and DSO in SQL. Then direct your own AI through the same job and catch its mistakes. (intermediate · $1.25)
SQL for HR: Attrition Analysis from an HR Database — Work out headcount, attrition by department and tenure, exit reasons, manager hot spots and a board-ready headcount bridge in SQL. Then direct your own AI through the same job and catch its mistakes. (intermediate · $1.25)
Apache Spark Fundamentals: Distributed Data Processing — Follow a growing logistics company's data analyst as she rebuilds a crashing pandas job in Apache Spark -- architecture, DataFrames, partitioning, shuffles, and performance tuning. (intermediate · $1.50)
Building a Metrics Layer for Self-Service Analytics — Learn to build a metrics layer so every team gets the same revenue and user numbers, no matter which BI tool they use. (advanced · $2)
Data Governance Fundamentals: Cataloging, Lineage, and Access Control — A data engineer builds a lightweight catalog, lineage impact checks, and access control for a growing e-commerce company -- real data governance, not compliance theater. (intermediate · $1.50)
Data Observability: Catching Silent Pipeline Failures Before Your CEO Does — Learn the five pillars of data observability, build real freshness, volume, schema, and anomaly monitoring, and design an incident response process for data pipeline failures. (intermediate · $1.50)
Data Quality Engineering: Validation and Testing with Great Expectations — Stop shipping silent data bugs. Learn Great Expectations to write validation suites, catch bad data before it spreads, and build quality reports stakeholders trust. (intermediate · $1.50)
Multi-Touch Attribution in SQL with Window Functions — Build first-touch, last-touch, linear and 40/20/40 attribution, ROAS and assists in SQL window functions. Then direct your own AI through the same job and catch its mistakes. (advanced · $2)
Production-Grade ELT: Airflow + dbt + a Cloud Warehouse End to End — A capstone project: orchestrate dbt transformations from Airflow, enforce data quality gates, handle safe incremental backfills, and monitor a production ELT pipeline end to end. (advanced · $2)
SQL for E-commerce: Funnel Conversion and Cohort Retention — Build a D2C brand's conversion funnel, new-versus-returning split, cohort retention grid and source scorecard in SQL. Then direct your own AI through the same job and catch its mistakes. (intermediate · $1.25)
Banking Secure Coding L1: Fix SQL Injection in a Login Query — Reproduce a prepared login bypass, bind query values and prove that valid banking logins still work. (beginner · $1)
SQL for Hospital Operations: Bed Occupancy, Length of Stay and Readmissions — Build a hospital's length of stay, ward occupancy, midnight census, 30-day readmission rate and department league table in SQL, then direct your own AI through the same job and catch its mistakes. (intermediate · $1.25)
SQL for Product Analytics: DAU, MAU, Stickiness and Feature Adoption in a Food-Delivery App — Measure a food-delivery app's active users, stickiness, feature adoption and first-order funnel from its events table in SQL, then direct your own AI and catch its mistakes. (beginner · $1)
SQL for Supply Chain: Supplier OTIF, Fill Rate and Days of Cover — Build an FMCG distributor's supplier fill rate, OTIF, stock-outs, days of cover, reorder alerts and slow movers in SQL, then direct your own AI and catch its mistakes. (intermediate · $1.25)

Practise SQL more

Free SQL playground: Write and run SQL against a sample database in your browser. No login.
SQL course: Learn SQL from your first SELECT to window functions, with a lab in every lesson.
Data analyst job simulation: A simulated analyst workday: real requests, real data, scored work.

Frequently asked questions

Which SQL projects are good for a data analyst resume?

Projects that answer a business question end to end: a KPI or retention analysis, a cohort or funnel report, a data quality check. Each project here starts from such a question and ends with queries and findings you can describe in an interview.

Do I need to install anything for these SQL projects?

Most projects run in labs inside your browser (SQL, Excel, Python, Power BI, Git and more). Cloud projects say up front when they use your own AWS account or a simulator instead.

How is a Bartman project different from a tutorial?

You do the work yourself, step by step. Each step is checked automatically, and an AI mentor helps when you are stuck, so you finish with work you can show rather than a video you watched.

Do I get a certificate?

Yes. Finishing a project earns a certificate with its own ID that anyone can verify on bartman.ai.

What is Bartman?

Bartman (bartman.ai) is a learning platform where you build real projects with an AI mentor, practise in free browser labs, take mock tests and practice exams, and run job simulations. It was founded in 2025 and is based in Hyderabad, India.