Ask HN: What's the fastest way to learn SQL?

3 points by shreyassood 2y ago ↗ HN

I recently joined a startup and I didn't realize how much I would need to be able to write off-the-cuff queries to debug stuff. I came from a massive company where running adhoc queries was basically a giant no-no and never really got familiar with SQL. Any tips on the best way to pick it up quickly so I can start being more productive at work?

6 comments

[ 3.6 ms ] story [ 15.1 ms ] thread

scrlk 2y ago ↗

https://sqlbolt.com/ is a good place to start.

screenoridesaga 2y ago ↗

OpenAI is a better SQL query writer than any developer I’ve worked with, and it’s not close.

PaulHoule 2y ago ↗

Kinda scary but maybe true. It reminds me of the place I worked at for a while that had built database-backed web sites for 10 years but I was the first person they hired who understood joins.

PaulHoule 2y ago ↗

I like the SQL course at https://www.hackerrank.com/ see also books by https://en.wikipedia.org/wiki/Joe_Celko to learn how to write really advanced queries.

thecrumb 2y ago ↗

Make friends with your DBA (assuming you have one)

newprint 2y ago ↗

This question been asked multiple times here, go through my history and you will find detailed answers.