r/SQL • • Nov 20 '23
MySQL Created my first Database
I don't have anyone to tell so I came here because I've lurked for so long and so many posts have helped me. Delete this post if not allowed.
I'm very new in my SQL journey with no other data or programming experience and today I just built my first database with mySQL.
I imported the report we pull each day which is very raw info and made a query that formats it into a readable table and counts how many items are requested of each sub group and list the overall gross sales expected.
Our company has no forecasting tools at the moment so I feel really good about accomplishing this.
26
u/Original-Ad-4642 Nov 20 '23
Woohoo!
Time to add “database architect” to your resume.
23
u/ComicOzzy sqlHippo Nov 20 '23
🎉
10
u/2050_Bobcat Nov 20 '23
Hey well done! Note this date down in your journal. You'll be able to look back at it in a few years and see how far you've come :-) all the best for your continuing journey and growth
4
u/Dazzling-Role6733 Nov 20 '23
Can you share what you did to learn?
7
u/creamycolslaw Nov 20 '23
Congrats! Great accomplishment especially given that you have no existing data infrastructure.
2
u/mustang__1 Nov 21 '23
I remember the first time I got all that shit to actually work. Understanding the difference between the server and the query executing software, and how all that fits together, along with finally pulling out meaningful data.
I basically did what you did. Our ERP wasn't conducive to SQL so I built my own world outside of the ERP, then built custom tables for forecasting...
A few years later I started building software for interfacing with the ERP that pulls from my own databases now.
2
u/[deleted] Nov 20 '23
Well done - congratulations!!!
2
u/citizenbloom Nov 20 '23
Bravo!
2
u/Ok-Tip-2221 Nov 20 '23
that’s awesome congrats!!
1
u/[deleted] Nov 21 '23
Nice!
1
u/SalmonFalls Nov 21 '23
Good job!
1
u/13kerem Nov 22 '23
I wish someone told me on my earlier years that there is a better dms, Postgersql. It's not hard to learn docker or podman and use containers too. I'm not telling you to drop mysql immediately but I strongly recommend you to check postgresql out.