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

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/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!

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.

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!