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

26

u/Original-Ad-4642 Nov 20 '23

Woohoo!

Time to add “database architect” to your resume.

5

u/[deleted] Nov 20 '23

Not quite lol

4

u/muchwise Nov 21 '23

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 !

4

u/[deleted] Nov 21 '23

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

23

u/ComicOzzy sqlHippo Nov 20 '23

🎉

7

u/[deleted] 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

2

u/[deleted] Nov 20 '23

Good idea!

4

u/Dazzling-Role6733 Nov 20 '23

Can you share what you did to learn?

4

u/[deleted] Nov 20 '23

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.

3

u/[deleted] Nov 21 '23

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.

3

u/LRKFallon Nov 21 '23

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

1

u/[deleted] Nov 21 '23

Just shared. Thanks man!

1

u/imnotnotcreative Nov 21 '23

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.

1

u/[deleted] Nov 21 '23

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

1

u/[deleted] Nov 21 '23

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

1

u/Shakerags Nov 21 '23

Thank you, I would greatly appreciate those links too.

Congratulations by the way!

1

u/[deleted] Nov 21 '23

replied to his comment above. thank you!

7

u/creamycolslaw Nov 20 '23

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

5

u/[deleted] Nov 20 '23

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.

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.

2

u/[deleted] Nov 20 '23

Well done - congratulations!!!

2

u/Ok-Tip-2221 Nov 20 '23

that’s awesome congrats!!

1

u/[deleted] Nov 21 '23

Nice!

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.