civilian7

civilian7 / sql-tutorial

Public

현실적인 전자상거래 데이터베이스로 배우는 SQL 튜토리얼 (21 tables, 18 views, 111 exercises)

99
19
100% credibility
Found Apr 08, 2026 at 99 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Python
AI Summary

A tool that generates realistic e-commerce test databases with 21 tables, views, triggers, and multilingual tutorials for hands-on SQL learning from beginner to advanced levels.

How It Works

1
🔍 Discover SQL Fun

You find a helpful tool that creates a pretend online computer store full of realistic shopping data to practice SQL on.

2
📦 Get It Ready

Download the tool and prepare it on your computer – it only takes a minute to set up.

3
✨ Build Your Store Data

Choose small, medium, or large data in Korean or English, and create your own e-commerce database that feels just like a real shop.

4
Pick Your Lessons
🇰🇷
Korean Guide

Follow lessons and exercises in Korean with product searches, customer stories, and sales puzzles.

🇺🇸
English Guide

Dive into the same lessons in English, practicing queries on orders, reviews, and business insights.

5
🧠 Practice Real Queries

Connect to your database and try SQL on customers, orders, inventory – see patterns like busy shopping days emerge.

🎓 Master SQL Skills

You've practiced every key SQL trick from basics to advanced analytics, ready for real jobs or projects!

Sign up to see the full architecture

4 more

Sign Up Free

Star Growth

See how this repo grew from 99 to 99 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is sql-tutorial?

This GitHub SQL tutorial generates a realistic e-commerce SQLite database mimicking a computer store, complete with 21 tables tracking customers, orders, inventory, and more, plus 18 views for analytics like RFM segmentation and monthly sales. Run `python generate.py --size medium` to spin up 2M rows of data in seconds, with Korean or English locales and sizes from quick tests to perf benchmarks. It ships with interactive MkDocs docs featuring 21 lessons and 200+ exercises on everything from SELECT basics to window functions and CTEs.

Why is it gaining traction?

Unlike toy datasets, it packs production-like patterns: 10-year growth curves, seasonal peaks, Pareto customer splits, and data integrity checks—no orders before signups or discontinued product sales. Developers dig the bilingual tutorials covering joins in sql tables, pl sql tutorial github equivalents via MySQL/PostgreSQL procs, and sql github interview questions prep, all queryable instantly. Views visualize sql tables count, hierarchies, and KPIs, making sql tables visualization and sql tables list queries a breeze.

Who should use this?

Junior devs grinding sql github practice for interviews or sql github portfolio projects. Data analysts needing sql github notes on real-world joins, subqueries, and optimizations without spinning up prod DBs. Bootcamp grads tackling sql tutorial darmstadt-style advanced topics like recursive CTEs on hierarchical categories or RFM on customer tables.

Verdict

Grab it for structured SQL practice—99 stars and 1.0% credibility score reflect its youth, but thorough docs and bilingual support make it a solid sql github repo starter. Author welcomes PRs to polish edges like sql tablespace handling.

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.