SQL project for beginners — Coffee Shop Data Analytics Case Study. Learn SQL with a real-world case study: 21 practical queries, data import, and analytics tasks you can add to your portfolio. In this video you will: • Create a SQL database and import CSV data • Run 21 SQL queries (from beginner to advanced) covering joins, aggregations, subqueries, window functions, CTEs, and ranking • Solve real coffee shop business problems (sales, inventory, staff shifts, KPIs) • Build a portfolio-ready project to show in interviews Source code & dataset: Why watch: This project teaches real-world SQL patterns hiring managers look for — not just theory. Follow along and pause to run the queries yourself. Video Chapters 00:00 Intro — What this project teaches 01:13 Creating tables & importing CSVs 03:07 Coffee shop database structure 05:20 Employee workload & shift queries 11:39 Date casting & weekly hours 13:48 Employees working over 25 hours 17:16 Ranking employees by work hours 21:27 Suggesting shift relocations 29:56 Detect overlapping shifts 38:38 Shifts with insufficient staff 40:59 Sales & revenue by hour 46:24 Monthly KPIs & SQL view 53:01 Most profitable product category 01:00:03 Customer order patterns & retention 01:06:12 Customers inactive in last 30 days 01:14:10 Pivot & unpivot order timing 01:24:49 Top 5 bestselling items & revenue 01:30:21 Pricing & demand recommendations 01:37:19 Best items & marketing focus 01:43:21 Ingredients low in inventory 01:50:26 Counting staff shifts (year to date) 01:56:17 Frequently ordered item chains 02:10:32 Customers with 10+ orders over 5+ days 02:16:38 Top selling item per time window 02:31:26 Shift with highest revenue & staff How to use the project: Clone the repo, run the SQL scripts, and add screenshots + a short write-up to your portfolio or resume. If you try this in your portfolio, comment “Added” and I’ll share a short script to explain it in interviews. #sqlprojects #datanalytics #dataanalyticsportfolio #dataanalystinterview #dataanalyticsproject #sqltutorial #dataanalytics #dataanalystproject Related keywords: data analyst portfolio project data analyst project data analysis project data analyst projects for resume data analyst sql project end to end project for data analyst sql project for data analyst project for beginners sql portfolio project data analyst sql project data analyst full project data analyst resume project sql project