Skip to content

A personal repo documenting my SQL learning journey through LeetCode SQL 50 problems, with solutions written in MySQL to strengthen my database and query-building skills.

Notifications You must be signed in to change notification settings

Anushka-Sharma-008/LeetcodeSQL50

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

2 Commits
Β 
Β 

Repository files navigation

πŸ—„οΈ LeetCode SQL 50 | Personal Learning Repository

A personal repository to track and document my SQL learning journey using LeetCode SQL problems.
This repo is a collection of .sql solution files for each question in the LeetCode SQL 50 series, written and tested using MySQL, helping me build a strong foundation in database querying and design.


πŸ“‚ Repository Structure

πŸ“ LeetCodeSQL50
└── πŸ“„ .sql Files # SQL script solutions for LeetCode SQL 50 problems
└── πŸ“„ README.md # Project documentation

✨ What's Inside

  • .sql scripts solving each LeetCode SQL problem (SQL50 series).
  • Each file is named with the problem number according to Leetcode.
  • Covers a variety of SQL concepts: SELECT queries, JOINs, aggregations, subqueries, etc.
  • Solutions are added and updated regularly as I complete new problems.

πŸ› οΈ Tools & Technologies

Tool/Platform Purpose
MySQL 🐬 Local database engine used for writing and running SQL
GitHub πŸ’» Version control & project hosting
LeetCode βš”οΈ Platform for hands-on SQL problem solving (SQL50 series)
YouTube πŸ“Ί Tutorials & walkthroughs to understand SQL concepts

πŸ“ˆ Learning Goals

  • Strengthen fundamentals in SQL and database concepts using practical problems.
  • Practice writing efficient SQL queries and handling different data scenarios.
  • Build a personal reference of solved SQL problems for interview preparation.
  • Track and reflect on my progress in learning SQL over time.

πŸš€ How to Use This Repo

  1. Clone the repo:
    git clone https://github.com/Anushka-Sharma-008/LeetCodeSQL50.git
  2. Navigate the files: Explore the .sql solution files for each problem.
  3. Run the SQL scripts: Open the .sql files in any SQL environment and execute them against the sample database schema provided by LeetCode.

🧠 Ideal For

  • Beginners learning SQL query writing and database fundamentals.
  • Students preparing for technical interviews that include SQL/database questions.
  • Anyone revising core SQL concepts through hands-on practice.

πŸ“Œ Notes

  • Solutions will be updated regularly as I complete more problems in the SQL50 series.
  • SQL code is written for clarity and learning, and may not cover every edge case or optimization.
  • Suggestions and feedback are welcome via GitHub Issues or Discussions.

πŸ™‹β€β™€οΈ Author

Anushka Sharma
🌐 LinkedIn β€’ 🐱 GitHub πŸŽ“ Currently learning Python, Data Science, and DSA


⭐ Show Your Support

If this repo helped you or you find it relatable:

  • ⭐ Star the repository
  • 🍴 Fork it and document your own journey
  • πŸ’¬ Drop a suggestion or comment!

About

A personal repo documenting my SQL learning journey through LeetCode SQL 50 problems, with solutions written in MySQL to strengthen my database and query-building skills.

Topics

Resources

Stars

Watchers

Forks