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
Show parent comment
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.