Joe Celko's SQL Puzzles and Answers
By Joe Celko
4/5
()
About this ebook
Joe Celko's SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations.
Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems.
This book is recommended for database programmers with a good knowledge of SQL.
- A great collection of tricky SQL puzzles with a variety of solutions and explanations
- Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems
- New edition features: Many new puzzles added!, Dozens of new solutions to puzzles, and using features in SQL-99, Code is edited to conform to SQL STYLE rules, New chapter on temporal query puzzles, New chapter on common misconceptions about SQL and RDBMS that leads to problems
Joe Celko
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
Read more from Joe Celko
Joe Celko's SQL for Smarties: Advanced SQL Programming Rating: 3 out of 5 stars3/5Joe Celko's SQL Programming Style Rating: 4 out of 5 stars4/5Joe Celko's Trees and Hierarchies in SQL for Smarties Rating: 0 out of 5 stars0 ratingsJoe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL Rating: 3 out of 5 stars3/5Joe Celko's Analytics and OLAP in SQL Rating: 4 out of 5 stars4/5Joe Celko's Data, Measurements and Standards in SQL Rating: 0 out of 5 stars0 ratings
Related to Joe Celko's SQL Puzzles and Answers
Related ebooks
Joe Celko's Analytics and OLAP in SQL Rating: 4 out of 5 stars4/5Relational Database Design Clearly Explained Rating: 5 out of 5 stars5/5SQL: Practical Guide for Developers Rating: 2 out of 5 stars2/5SQL Clearly Explained Rating: 5 out of 5 stars5/5Fuzzy Modeling and Genetic Algorithms for Data Mining and Exploration Rating: 5 out of 5 stars5/5C# Interview Questions, Answers, and Explanations: C Sharp Certification Review Rating: 5 out of 5 stars5/5Data Mining: Practical Machine Learning Tools and Techniques Rating: 4 out of 5 stars4/5Graph Databases in Action: Examples in Gremlin Rating: 0 out of 5 stars0 ratingsJoe Celko's Data, Measurements and Standards in SQL Rating: 0 out of 5 stars0 ratingsPractical SQL Rating: 4 out of 5 stars4/5Microsoft Tabular Modeling Cookbook Rating: 0 out of 5 stars0 ratingsPhysical Database Design: The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More Rating: 5 out of 5 stars5/5Tabular Modeling with SQL Server 2016 Analysis Services Cookbook Rating: 4 out of 5 stars4/5Database Design: Know It All Rating: 5 out of 5 stars5/5100+ SQL Queries T-SQL for Microsoft SQL Server Rating: 4 out of 5 stars4/5Database Modeling and Design: Logical Design Rating: 0 out of 5 stars0 ratingsMDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition Rating: 0 out of 5 stars0 ratingsSQL Server: Tips and Tricks - 2 Rating: 4 out of 5 stars4/5Relational Database Design and Implementation Rating: 5 out of 5 stars5/5SQL Server 2016 Developer's Guide Rating: 0 out of 5 stars0 ratingsLearning PostgreSQL Rating: 1 out of 5 stars1/5SQL in 30 Pages Rating: 4 out of 5 stars4/5PostgreSQL for Data Architects Rating: 0 out of 5 stars0 ratingsSQL Server 2017 Integration Services Cookbook Rating: 0 out of 5 stars0 ratingsDatabase Design and SQL for DB2 Rating: 5 out of 5 stars5/5MySQL A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsLearn T-SQL Querying: A guide to developing efficient and elegant T-SQL code Rating: 0 out of 5 stars0 ratingsRelational Database Design and Implementation: Clearly Explained Rating: 0 out of 5 stars0 ratingsSQL Server: Tips and Tricks - 1 Rating: 5 out of 5 stars5/5PowerShell for SQL Server Essentials Rating: 0 out of 5 stars0 ratings
Programming For You
Python: For Beginners A Crash Course Guide To Learn Python in 1 Week Rating: 4 out of 5 stars4/5Python Programming : How to Code Python Fast In Just 24 Hours With 7 Simple Steps Rating: 4 out of 5 stars4/5HTML & CSS: Learn the Fundaments in 7 Days Rating: 4 out of 5 stars4/5Java for Beginners: A Crash Course to Learn Java Programming in 1 Week Rating: 5 out of 5 stars5/5SQL: For Beginners: Your Guide To Easily Learn SQL Programming in 7 Days Rating: 5 out of 5 stars5/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5Coding All-in-One For Dummies Rating: 4 out of 5 stars4/5Python Machine Learning By Example Rating: 4 out of 5 stars4/5101 Amazing Nintendo NES Facts: Includes facts about the Famicom Rating: 4 out of 5 stars4/5Pokemon Go: Guide + 20 Tips and Tricks You Must Read Hints, Tricks, Tips, Secrets, Android, iOS Rating: 5 out of 5 stars5/5Linux: Learn in 24 Hours Rating: 5 out of 5 stars5/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5SQL All-in-One For Dummies Rating: 3 out of 5 stars3/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5PYTHON: Practical Python Programming For Beginners & Experts With Hands-on Project Rating: 5 out of 5 stars5/5Modern C++ for Absolute Beginners: A Friendly Introduction to C++ Programming Language and C++11 to C++20 Standards Rating: 0 out of 5 stars0 ratingsPython Projects for Beginners: A Ten-Week Bootcamp Approach to Python Programming Rating: 0 out of 5 stars0 ratings
Reviews for Joe Celko's SQL Puzzles and Answers
14 ratings0 reviews