LearnSQL is a beginner-friendly, interactive SQL documentation website designed to make learning SQL simple, structured, and visual.
Built using React JS and Tailwind CSS, this project focuses on clarity, real examples, and easy navigation — perfect for anyone starting their SQL journey 🚀
| 🏠 Home Page | ℹ️ About Page |
|---|---|
 |
 |
| 📄 Cheatsheet Page | 🛠️ MySQL Installation Guide |
|---|---|
 |
 |
| 📘 Docs Intro Page | 🔗 Docs Page: SQL Joins |
|---|---|
 |
 |
The project is live and can be viewed here: LearnSQL
While learning SQL, I felt that beginners often struggle to:
- Understand concepts in the right order
- Connect theory with real queries
- Revise topics quickly before interviews or practice
So I built
LearnSQLto solve exactly that.
This website:
- Explains SQL step by step
- Uses clear explanations and structured flow
- Is made by a learner, for learners
- 📘 Beginner-friendly SQL documentation
- 🧭 Well-structured topic flow (from basics → advanced)
- 🖥️ Fully responsive (mobile, tablet, desktop)
- ⚡ Fast and clean UI using Tailwind CSS
- ⬆️ Scroll-to-top support
- 📄 Separate pages for Docs, Cheatsheet, About & Install Guides
- SQL Introduction
- DBMS
- MySQL
- Create Database
- Create Table
- SQL Datatypes
- SQL Keys
- SQL Constraints
- Cascading (Foreign Key)
- SQL SELECT
- WHERE Clause
- SQL Operators
- ORDER BY Clause
- LIMIT Clause
- Aggregate Functions
- GROUP BY Clause
- HAVING Clause
- Joins in SQL
- SQL Subqueries
- MySQL Views
- Practice Queries (Database)
- Practice Queries (Tables)
- More Practice Queries
- SQL Projects
- Useful Learning Links
-
🏠 Landing Page — Overview of LearnSQL
-
🛠️ MySQL Installation Guide
- Windows
- macOS
-
📄 SQL Cheatsheet — Quick revision for interviews & practice
-
ℹ️ About Page — Purpose and motivation behind LearnSQL
- ⚛️ React JS
- 🎨 Tailwind CSS
- 🗂️ React Router DOM
- ⚛️ React icons
This project was created while learning SQL from:
🎓 Apna College SQL One Shot Tutorial
The content is curated, simplified, and redesigned with my own understanding to help beginners learn faster.
# 1. Clone the repo
git clone https://github.com/TonyStark-19/LearnSQL.git
# 2. Move into the project folder
cd LearnSQL
# 3. Install dependencies
npm install
# 4. Start the development server
npm run dev
⚠️ Make sure you have Node.js and npm installed on your system.
To master SQL, theory isn't enough — practice is key! I recommend:
Contributions are always welcome! 🙌
If you’d like to improve LearnSQL:
- Fork the repository
- Make your changes
- Submit a Pull Request
Every contribution helps beginners learn better 💙
Please read the CONTRIBUTING.md before you start.
This project is made to help others while learning SQL.
If you find it useful:
- ⭐ Star the repository
- 🔗 Share it with fellow learners
- 💬 Give feedback or suggestions
Your support keeps me motivated to improve it further 🚀
Made with ❤️ by Aditya chandel