Currently in its 5th edition is Joe Celko’s SQL for Smarties, a primer on more advanced SQL development. This is one of the few books created solely for advanced programmers who want to push the boundaries of their SQL knowledge.

This book has been around for well over a decade and the newest update was published in 2014. It comes with over 850 pages of exercises and lessons based on common SQL situations.

Joe shares tips and best practices for each scenario explaining how to properly solve the problem and why it’s the best solution. You’ll learn about new syntax techniques but also get into database administration concepts like relational division and partitions in queries.

If you grab a copy of this book you’ll also get all the source code for free along with downloadable data sets for testing the exercises locally. This is by far the most comprehensive pro-level SQL book on the market and it’s sure to take your skills up a notch.

It’s hard to state exactly what sort of experience level you need for this. But I’ll generalize and say that if most of the other books in this list seem too easy or convoluted then Joe’s SQL for Smarties might be a perfect fit.

Joe Celko’s SQL for Smarties,Computer Books, Download Ebooks, Download PDF Books, eBooks, SQL Books