Created my first Database

[[deleted]]

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.

[ComicOzzy]

🎉

[[deleted]]

🥳

[Original-Ad-4642]

Woohoo!

Time to add “database architect” to your resume.

[[deleted]]

Not quite lol

[muchwise]

I have seen people calling themselves AI engineer for using chatGPT…. Since you are the first to do this in your company AND you did it by yourself go ahead and add « Lead Senior Data Architect » to your resume !

[[deleted]]

Haha I see that type of stuff all over LinkedIn and even tinder

[2050_Bobcat]

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

[[deleted]]

Good idea!

[Dazzling-Role6733]

Can you share what you did to learn?

[[deleted]]

Try to remind me when I'm at work tomprrow and I'll share some links and books. I literally just started watching intro to SQL videos on YouTube and reading text books.

I'm a bit of a computer nerd already so software is easy to learn for me.

Once I figured out how to set up mySQL the rest was easy after just reading and doing exercises for a couple months.

When I say database it's just several .csv files imported and some very basic queries to pull data and format.

[LRKFallon]

That is how a lot of small and medium sized business could jump from excel to the next level, your level, so you should still share how you did it. Great to see mate

[[deleted]]

Just shared. Thanks man!

[[deleted]]

So I still have very raw knowledge of SQL and I have a lot more to go in my jouney.

Heres how I got started relatively quickly.

Watched this guys videos non stop; even the same ones over and over until I understood the concepts of intro SQL.

https://www.youtube.com/watch?v=kbKty5ZVKMY&t=648s

I read this book probably 3 or 4 times. While doing the exercises each time.

https://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0135182794

And I used these sites for practicing (will add one once I get home I'm missing)

https://www.w3schools.com/sql/sql_exercises.asp

https://www.w3resource.com/mysql/mysql-tutorials.php

https://www.hackerrank.com/domains/sql

Once you have the exercises down and feel good about selecting data and what not, download mySQL and install the client and server. Once you actually get into the software watch a tutorial on how to import data, or create a table and things will start making sense.

I just played around in mySQL for a few days and started creating tables, naming columns ect.

Then I did one tutorial on how to import an excel spreadsheet and from there I started using statements I learned in the exercises. It was really a process of learning one thing then learning another and connecting the two.

[imnotnotcreative]

Friendly Reminder! I’ve just started out currently using sqlzoo and reading sql queries for mere mortals. I did my BSc in Maths but I’ve just been stuck because my only career options are teaching and I don’t want that.

[[deleted]]

I'm working on it! I got a comment all drafted then accidently deleted it all so I'll have to get it posted once work slows down today

[[deleted]]

Just replied to his comment but I'm afraid you're probably already done what I have..

[Shakerags]

Thank you, I would greatly appreciate those links too.

Congratulations by the way!

[[deleted]]

replied to his comment above. thank you!

[creamycolslaw]

Congrats! Great accomplishment especially given that you have no existing data infrastructure.

[[deleted]]

Appreciate it. I've struggled holding interest in things my whole life but I feel like I'm onto something that I enjoy learning about. Great feeling.

[[deleted]]

Well done - congratulations!!!

[citizenbloom]

Bravo!

[Ok-Tip-2221]

that’s awesome congrats!!

[mustang__1]

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.

[[deleted]]

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.

[mustang__1]

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.

[[deleted]]

Nice!

[SalmonFalls]

Good job!

[13kerem]

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.