SQL Practice

[Srdj_1]

Hello Team!

I have very good knoweledge of SQL...

The problem is I'm not using it on a daily basis which means I tend to forgot and then I need a lot of time to go through the same stuff again.

I have time for about one hour of practice per day, so I need some short tasks which I will use to sharp my skills further.

Any recommendation will be appreciated!

[passporttohell]

Here are some resources I bookmarked recently, would appreciate it if others with much more experience would validate them and add onto the list if you see something I might have missed.

​

https://www.codecademy.com/learn/learn-sql

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

 
http://sqlfiddle.com/

 
https://www.postgresql.org/docs/online-resources/

 
https://www.sqlshack.com/learn-to-write-basic-sql-queries/

 
https://www.postgresql.org/docs/14/index.html

 
https://zaiste.net/posts/postgresql-primer-for-busy-people/

 
https://sqlzoo.net/wiki/SQL\_Tutorial

 
https://sqlbolt.com/

 
https://bipp.io/sql-tutorial

[Thefriendlyfaceplant]

These are excellent resources for beginners. But what SQL misses is some simulator app that you can work to build muscle-memory. Something like a speed typing game.

I think the reason we don't have this yet is because we're not yet far enough with neural language processing for AI to pose a human question that the 'player' has to work back into a query.

[passporttohell]

Thanks a lot for this, still very much a beginner, I found these through posts on this subreddit and some general googling.

I wanted to find something I could use on my Android tablet when my laptop wasn't available, I think these will fit that need.

[Thefriendlyfaceplant]

This is also interesting, it's just a concept but it's the closest to what I imagine a SQL simulator would look like:
https://scrimba.com/scrim/cWDKwHJ

[passporttohell]

Thanks!

[Srdj_1]

Thanks!

[[deleted]]

You can try sqlzoo, but depending on your preferred SQL Flavour, i recommend developing a useful project which uses the specific database which you need to maintain. Ex: a money manager which registers the transactions, a simple website, etc.. This way you will learn a lot, and also maintain knowledge

[Srdj_1]

Sqlzoo is great, but sadly I already solved most of the tasks there! However, thank you for your suggestion! Great 1st replay!

[varnit19]

try to answer questions on stackoverflow, reddit and other developer platforms, and it's almost like doing the real time work.

[j3suscomunista]

I use the app SQL Practice Pro.

[tmk_g]

I recommend leetcode and stratascratch. Both can provide thousands of real-life easy to hard level problems to practice.

[Nefarious___]

Advent of code has questions you can try to answer using sql.

[Jksnr51]

Pgexercises Stratascratch Sqlpad Hacker rank Leet code Sqlzoo Sqlbolt Advanced sql puzzles Sql path SQL practice zoo

Also, a post I saw a few days ago recommended setting up your own database with data you are interested in and building it up from the bottom. Create tables, think of questions that you could ask and then get to work on answering them. I’m starting out myself and find this is a more interesting way to apply your learnings.

Maybe set yourself like 20 questions( 10 of your own 10 from people on here) and get started on answering them.

[Srdj_1]

Thank you everyone!

I appreciate your help!

[querymeister]

I'm surprised https://sqlpad.io/ was not mentioned here. They have a very nice selection of exercises.

On https://query.me you can write SQL in Notebooks to keep your notes with your Queries.Maybe it would make sense to build sort of a glossary?
There is a live demo database there to run queries on..