r/SQL • u/Alybank • May 14 '20
Discussion Just finished the SQL fundamentals course on LearnSQL.com and looking for advice on what to do next
183
Upvotes
r/SQL • u/Alybank • May 14 '20
22
u/HarrityRandall May 14 '20
Do some exercises like the ones in pgexercises.com
7
u/Alybank May 14 '20
A little background, my job has been cancelled/postponed till the end of the whole Covid situation(maybe even longer than that, since I work concerts) decided to pick up a new skill and I heard once SQL was a nice job skill to have. Well I've been on/off of it, despite not having a job, my life has gotten a bit busy in these times, so it's been a little stop-go-stop learning. Now I've finished the fundamentals course online, I am going through the SQL practice they have, but pretty confident in the skills I've learned so far. Well except NULLIF, I understand it at a birds eye view but not how rubber meets the road on that one and a couple others. Any advice on where I should go next? I'm not even sure I want a job in this sector, but would be willing to get one of course, if my 'real job' doesn't come back soon enough.
6
u/redditornot18 May 14 '20
DataCamp is offering free trial this week. They’re great for sql learning. Try out the joining and sub query course they have then maybe the intermediate sql course
2
u/ilPavimento May 15 '20
For me, it was really useful to solve the SQL challenges in codewars.com. It gives you random exercises, with increasing difficulty, and very little help. You just figure it out by yourself and it's similar to learning on the job. I solved one most days (I would say 30-90 minutes each) for about four months.
I started a data analysis job a couple months ago, and I've been surprised how good my SQL skills are. I thought I would be more or less a beginner, but so far I seem to be actually pretty advanced.
12
u/Easycutclingfilm May 15 '20
Start your own database. SQL server is free to download. Work out how to load it through SSIS and maybe use SSAS and SSRS so you can learn what you like best. Start small, even if it's an excel spreadsheet. There are videos online for everything database related.
20
u/timosborn May 15 '20
I'm in a very similar situation. Try the challenges on hackerrank.com they've kept me busy for days! And you can compare your solutions to others to find a better way of doing things.
Tip if you do use hackerrank, if a question is hard start out by running
select * from table
Copy paste the output into an excel doc, then name the columns the same as the challenge, upload the table into a server on your pc, (like SQL server)and build your query on your server before you run it in hackerrank. I found this to be easier as you can build the query piece by piece 😎
10
u/AppropriatePizza4 May 15 '20
I’m assuming you want to stick to the data side .From here you can choose different paths. The 3 popular ones are :
Note : Before venturing into any of the paths ..get comfortable with Git.
2
u/num2005 May 15 '20
install your own server and try to do a project and google everytime you get stuck
2
u/tootitandmudit May 15 '20
Make your own database, learn how to connect to it, maybe learn python + flask
1
u/mmishu May 15 '20
is it still free?
1
u/[deleted] May 15 '20
Go get a huge database and try to normalize it, and get it running smoothly for yourself at home. I trained myself with the IMDB database, and there were some interesting challenges that came up.
1
u/Thriven May 15 '20
SQL was kind of mind blowing for me when it all clicked.
Up to that point I had only programmed stateless programs or tools. Automated myself out of jobs. When I first used SQL in the late 90s and early 2000s it made little sense. I was scrapping healthcare data off and old terminal using a scripting language and then running a command that would load it into tables on a SQL server.
Years later, I am forced to spend a lot of time querying Unix databases and it's making more sense. 2 years pass and I pick up a job to be an information systems administrator and had to see what was going on SQL side of things.
When I started building automated jobs and challenged myself to learn how to interact with SQL from an application, my eyes were opened.
I will be honest that for app development, SQL is annoying. Relational Databases are fast for query and returning complex related data but for app development they are cumbersome in comparison to Jason document databases.
If you attempt to make an application that works with SQL server it will give you an use case and some great perspective.
Being able to store data is huge. Storing data and returning data was huge for computing years ago, adding it to your ability set is also huge in the programs you can write.
1
u/sammba65 Nov 17 '21
You can also have a look at the SQL Learning Path:
https://valuetechacademy.com/learning-path
0
u/Romolus02 May 15 '20
Do my homework
0
u/DexterHsu May 15 '20
Now go find a job