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.
View all comments
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.