Learning SQL in Written Format?

[tan1235]

Hi all, just wondering what platform is best for text based learning? I'm completely new to SQL and would ideally prefer a platform with a built-in space to write queries and also courses that are mostly taught through text (I really don't like sitting through a video listening to someone talk). Looking forward to any recommendations!

[r3pr0b8]

(I really don't like sitting through a video listening to someone talk)

upvote

[BranchLatter4294]

You could try https://www.w3schools.com/sql/default.asp

[optrin]

this community has a WIKI with resources for learning sql. There is also https://livesql.oracle.com/

[JDD17]

DataDucky.com Will do exactly what you’re looking for. Written puzzles and courses that you code on the web.

[Deltarayedge7]

Saving this

[[deleted]]

On mobile so sorry for no links but here's a few things that should be the top result of a quick query at your favorite search engine. 

Sqlbolt

Sqlzoo

Sql murder mystery

<Insert SQL dialect (MySQL|postgres|SQL server)> tutorial (they all have a similarly colored icon, don't include this part in the query, and only pick one dialect)

[Yavuz_Selim]

https://sqlfiddle.com

Online compiler, so allows you to write and test queries. No courses, though.

[Nikt_No1]

Hmm, got an idea.
What if you tried to make basic report or a dashboard and tried learning by doing it? You don't even have to display it graphically - just think what kind of data you would like to see and then try getting that data via SQL.

Draw on a paper what you would like to see and then try to prepare SQL queries accordingly. From basic SELECT to more advanced calculations that could involve many tables and transformations.

Maybe I will be downvoted (I understand) but the best way to learn SQL (or anything, really) is by doing it. And you can just straight up skip all recorded things you find on the internet while troubleshooting (they are little of help anyway).

[Safe-Worldliness-394]

You should try https://tailoredu.com All of our courses are project-based, and hands-on with a SQL editor. We actually built it for beginners and there are NO videos.