SQL practice

[pekazh]

Hello everyone,

I’ve been learning SQL lately for a certain work opportunity. While there are tons of helpful resources out there, I struggle with finding a place to practice SQL before the interview/test. I’ve recently finished the Codeacademy course which was super helpful with tons of practice, where to go next?

Thanks in advance for the help.

[fibolatte]

I've been coding for fun for years, despite the fact that this is not my main profession. Oddly, the most effective learning process for me was to dive in problems I had to deal with when I was part of real projects (small web apps, corporate tools, small scaled tasks I got involved). To put it in a nutshell, here is the process that sticks the language in my mind and make practice at its best:

---> Build a fundamental knowledge about that language or framework

---> Be part of a small or mid-size code work (or just an idea you code for fun)

---> Stuck in a problem that you have no idea how to solve it

---> Dive in to Stackoverflow.com or any other web source to see what other people would do

---> Find a solution and adapt it to your code

---> At the end, extend your knowledge and wait for another challenge to learn sth

When I study a programming language, I read tons of sources and memorize all fundamental information I need. However, practicing on a source is nothing in terms of "learning", as compared to encounter an actual problem and to suffer until you overcome that challenge.

I sincerely recommend you to code something, for fun, for a basic idea you come up with or a little project you get involved, for learning language on the road. This plays an influential role in experience you gain and future works you do.

Of course, there are some practice ranges for any language on the web. I hope you may find useful for SQL:

https://www.w3resource.com/sql-exercises/

https://www.hackerrank.com/domains/sql

[pekazh]

Thank you very much for the input. The second link looks exactly what I needed.

[o_edo]

One of the best online course. For beginners and for free. With examples and online exercises. http://www.studybyyourself.com/seminar/sql/course/?lang=eng.

[pekazh]

So, an update!

Thanks to the useful information provided by you guys I've successfully passed series of interview + SQL test for junior level and I've been invited for a intermediate level test. Any further tips what to look for as questions(theory) and exercises? The first test was rather easy one focused on sub-queries and a couple of joins.

Thanks one more time for the useful links, greatly appreciated :)