Re:Ask HN: How to get better in advanced SQL
by alexpetralia on Wednesday February 13, 2019 @02:03AM
(#19151029)
One more vote for use-the-index-Luke. Clear, concise and comprehensive - I used this quite a bit when studying for interviews or optimizing database performance. Great resource!
Re:Ask HN: How to get better in advanced SQL
by frosted-flakes on Wednesday February 13, 2019 @02:37AM
(#19151184)
His book (SQL Performance Explained) is also very good. The book is not too long and not too dense. I'd buy it again (in fact, I probably will, because I left my copy with a former employer because they paid for it).
Re:Ask HN: How to get better in advanced SQL
by miluge on Wednesday February 13, 2019 @10:20AM
(#19153693)
I used your website to relearn SQL for work! I can't thank you enough for it and getting promoted.
Re:Ask HN: How to get better in advanced SQL
by wenc on Wednesday February 13, 2019 @09:12AM
(#19153185)
I was introduced to Markus' work by way of Wes McKinney's Twitter link [1].
This is deeper SQL-fu that many of us typically encounter. Highly recommend.
Re:Ask HN: How to get better in advanced SQL
by kakwa_ on Thursday February 14, 2019 @02:21AM
(#19160234)
It's a bit off topic since it's not a resource for learning, but:
http://tatiyants.com/pev/#/plans
(Postgres Explain Visualizer)
When dealing with query optimization in practice, it helps a lot since it enables a clear, convenient and synthetic view of an EXPLAIN (ANALYZE).
Just yesterday, it helped me improve a big analytic query from executing in 10 minutes to 5 seconds by just adding a small index.
Re:Ask HN: How to get better in advanced SQL
by tmm84 on Wednesday February 13, 2019 @11:15PM
(#19159566)
I love use the index luke. Some of the best query advice I can get when I have to get something done faster.
Personally, the most important part of getting advanced with SQL is being able to vizualize the DB in your mind and how the query should look. Also, sometimes bad design is at fault than a query. If the design is too complicated or wrong a query is gonna be slow in relation to the amount of data it has to go over.
https://use-the-index-luke.com/
You might also want to follow my other project:
https://modern-sql.com/