Skip to content

Pratham719/sql-practice

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

23 Commits
 
 
 
 
 
 

Repository files navigation

SQL Practice

Structured SQL practice using real-style business datasets and LeetCode problems. Written in MySQL/MariaDB via XAMPP + DBeaver.


Built — Employee dataset (basics → advanced multi-table analysis) · Coffee shop dataset (joins, revenue, grouping) · 21 Easy + 3 Medium LeetCode problems solved

🔄 Now — Expanding coffee shop into a full business case: product mix, peak hour revenue, staff cost vs. sales

🎯 Next — Window functions · CTEs · Analyst-level queries that answer real business questions


Stack: MySQL · MariaDB · XAMPP · DBeaver

About

SQL practice covering joins, subqueries, aggregations, window functions, and CTEs — includes a self-designed coffee shop business case using MySQL/MariaDB.

Topics

Resources

Stars

2 stars

Watchers

0 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors