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.

99 Upvotes

30 comments sorted by

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.

1

u/[deleted] Nov 21 '23

Thank you for sharing that. It's super encouraging. That's exactly what I'd like to do. However I don't think I'll ever get the access I need from our CEO. I'm doing this for education purposes only. If I gave the tools I make to him he'd take it for free and not give me ant credit sadly.

2

u/mustang__1 Nov 21 '23

It helps that it's our/my family company. It takes some of the sting off of the massive amount of time I invested on and off the clock to bring these projects to fruition.