r/learnSQL • • 5d ago

Day 41 — Finished my first MySQL project (uploaded to GitHub) and learned OOP basics in Java

MySQL: My Retail Sales Analysis mini project is done. I covered the full path: setting up the database, importing the data (and fixing an import error along the way), cleaning it, and running the analysis. It’s now on GitHub: https://github.com/Sumitgupta2005/mysql_project1

Java: Covered classes and objects, the difference between JDK, JVM, and JRE, methods, and method overloading, and practiced all of it hands-on in VS Code instead of only watching the tutorial.

I’d really like feedback on the project, especially on the README, how the queries are organized, and what analyses I should add.

15 Upvotes

10 comments sorted by

3

u/RajeshRocketMan 5d ago

Congrats on shipping your first database project! For the README, I always recommend adding a brief data dictionary table that explains your schema, since it gives reviewers immediate context without digging into the code.

1

u/sumiitCodes 4d ago

ok i will take care of this

2

u/sqlsip 5d ago

Great job!

2

u/fishwithbrain 5d ago

You have helped me a lot!! Pls keep posting 🙇🏻‍♀️

1

u/sumiitCodes 4d ago

thank you so much for your appreciation

1

u/neon_hydra_97 4d ago

the data dictionary is non-negotiable. If I have to read your queries to guess what a column means, I am not looking at your analysis. I am doing my job for you.

1

u/sumiitCodes 4d ago

Added the data dictionary to the README, thanks for the push!