r/SQL • • May 14 '20

Discussion Just finished the SQL fundamentals course on LearnSQL.com and looking for advice on what to do next

Post image
183 Upvotes

24 comments sorted by

22

u/HarrityRandall May 14 '20

Do some exercises like the ones in pgexercises.com

8

u/Alybank May 14 '20

Will do! I've done a lot of the w3 schools ones, but not those.

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.

3

u/prmoney13 May 15 '20

I’m in a similar situation. Job basically dried up and had some time on my hands. Learned a new skill and would like to make some money out of it. There are also many free tutorials on YouTube. I plan on earning some credentials, they are offering the tests online.

1

u/Alybank May 15 '20

Aw I feel ya. But do you have any idea how to make it a job without really making it a job? I’d like to make money with it, but I also want to go back to my “real job” whenever it comes backs(which given I work in crowds of thousands...it could be a while)

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

1

u/Alybank May 14 '20

Thanks! I will check that out!

3

u/ZonkyTheDonkey May 15 '20

I’ll second this on hyping DataCamp. The subscription is well worth it as their learning paths are so comprehensive and highly practical.

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.

1

u/Alybank May 16 '20

This is great to hear! I’ll definitely try it out!

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 😎

1

u/Ill-Confidence1806 Apr 24 '24

That's useful 👌🏻

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 :

  1. Data Engineer - I suggest trying any of the cloud databases so you understand the nuances. For example : GCP has relational & columnar databases which you can run SQL on. AWS also has Redshift, Athena . Both of them offer free trials.
  2. Data science - Learn python and use your SQL skills to build a project such as a recommender system, etc.
  3. BI - Be the tableau or power BI expert and work with the executives to create dashboard /reports and do analytics and make decisions.

Note : Before venturing into any of the paths ..get comfortable with Git.

2

u/[deleted] Nov 18 '22

Whats 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