News for hackers. Stuff that matters.

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

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 points | on HN )
Re:Ask HN: What's the fastest way to learn SQL? by PaulHoule on Tuesday April 02, 2024 @12:05PM (#39907334)
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.
Re:Ask HN: What's the fastest way to learn SQL? by scrlk on Tuesday April 02, 2024 @11:59AM (#39907258)
https://sqlbolt.com/ is a good place to start.
Re:Ask HN: What's the fastest way to learn SQL? by screenoridesaga on Tuesday April 02, 2024 @12:00PM (#39907270)
OpenAI is a better SQL query writer than any developer I’ve worked with, and it’s not close.
Re:Ask HN: What's the fastest way to learn SQL? by PaulHoule on Tuesday April 02, 2024 @12:06PM (#39907342)
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.
Re:Ask HN: What's the fastest way to learn SQL? by thecrumb on Tuesday April 02, 2024 @12:08PM (#39907376)
Make friends with your DBA (assuming you have one)
Re:Ask HN: What's the fastest way to learn SQL? by newprint on Tuesday April 02, 2024 @12:58PM (#39908028)
This question been asked multiple times here, go through my history and you will find detailed answers.