Joe Celko's Sql Puzzles | And Answers
is a classic in database literature, widely regarded as a premiere collection of "brainteasers" for database professionals. It compiles challenges from Celko’s former magazine columns to help programmers move beyond procedural thinking and master set-based SQL logic. Key Features
: The solutions generally adhere to ANSI/ISO standard SQL, making them applicable across platforms like Oracle, SQL Server, and Sybase. Why You Should Read It (Pros) Joe Celko's SQL Puzzles and Answers
: Joe Celko's deep involvement in the SQL standards committee (SQL-89, SQL-92) gives the book high credibility among "SQL gurus". is a classic in database literature, widely regarded
: The book presents 75 distinct puzzles based on real-world scenarios, such as tracking employee absenteeism or managing printer loads. Why You Should Read It (Pros) : Joe
: For most puzzles, Celko provides several ways to reach the answer, comparing different techniques and explaining the thought process behind an "SQL mindset".
: Reviewers at ThriftBooks and SQLAuthority highlight it as an excellent resource for "leveling up" mid-to-senior developers by exposing them to complex, non-obvious query patterns.
Thanks, Dumbsum, for this terrific step-by-step illustrated guide and the associated files! I picked up a used Fire HD 8.9 LTE earlier this year and was unimpressed by the stock operating system but too inexperienced (and chicken) to try rooting it and flashing a different ROM. The discussion threads I found at https://forum.xda-developers.com/kindle-fire-hd weren’t streamlined (dumbed-down) enough for me to take the plunge, but now, with your generous help, I’ve been able to gain root access and test drive a couple of different ROMs. I’m currently using LineageOS (lineage-14.1-20170718-UNOFFICIAL-jem.zip) with Open GApps 7.1 ARM nano; the things that work seem to be working well (but there’s no Bluetooth, GPS, or native camera support). Since discovering your guide and successfully installing replacement ROMs, I’ve been searching for the elusive LiquidSmooth ROMs for the Amazon jem but sadly I’ve com up empty. I’ll keep searching and checking back here — maybe someone will make some archived LiquidSmooth ROMs available soon. Thanks again for your very helpful guide!
Thanks Bill! Hope you will share with others when needed. If you come up with anything new please let me know. I’ll update the site accordingly 🙂