4 ms·
Are there any good advanced SQL books out there?
by Boulth 7y ago
Are there any good advanced SQL books out there?
- Shish2k 7y agoAs someone who spent the past week working on database abstractions, I'm pretty sure this is impossible - you can find Basic SQL books, and you can find Advanced Postgres / Advanced MySQL / Advanced Oracle :P The basic book would pretty much just cover "select * from table". Everything beyond that, for instance "select * from table limit 10", is implementation-specific... (I'm not even exaggerating: https://en.wikibooks.org/wiki/SQL_Dialects_Reference/Select_queries/Limiting_results_of_select_query https://en.wikibooks.org/wiki/SQL_Dialects_Reference/Select_... )
- Boulth 7y agoThat's what I was afraid of but still asked if there is Advanced ANSI SQL book. Thanks!
- mark_h 7y agoProbably not what you're asking, but this book is fantastic: https://sql-performance-explained.com/ https://sql-performance-explained.com/ Edit: and topically, free for the weekend! https://twitter.com/MarkusWinand/status/1199982940471607297 https://twitter.com/MarkusWinand/status/1199982940471607297
- Boulth 7y agoNot what I were asking about but definitely something that I need. Thanks a lot for the reference and wow, lucky timing!
- purerandomness 7y agoI found Dimitri Fontaine's https://theartofpostgresql.com/ https://theartofpostgresql.com/ advanced. Learned lots of new tricks out of it.
- Boulth 7y agoLooks nice and it's on discount because of Black Friday. Thanks!