My Wish Lists Login / Join

Joe Celko's SQL Puzzles and Answers, Second Edition

By: Joe Celko

Write A Review

Paperback | 21 September 2006 | Edition Number 2

At a Glance

Paperback
346 Pages

Edition Type
Revised

Dimensions(cm)
23.5 x 19.05 x 1.83

Paperback

RRP $116.95

$91.75

22%OFF

or 4 interest-free payments of $22.94 with

In Stock and Ships next day

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

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Business Applications

Puzzle
Fiscal Year Tables Puzzle
absentees Puzzle
The Anesthesia Puzzle Puzzle
Security Badges Puzzle
Alpha Data Puzzle
Hotel Reservations Puzzle
Keeping A Portfolio Puzzle
Scheduling Printers Puzzle
Available Seats Puzzle Puzzle
Wages Of Sin: Puzzle
Work Order Puzzle
Claims Status Puzzle
Teachers Puzzle
Telephone Puzzle
Find The Last Two Salaries Puzzle
Mechanics Puzzle
Employment Agency Puzzle
Junk Mail Puzzle
Top Salesmen Puzzle
Test Results Puzzle
Airplanes And Pilots Puzzle
Landlord Puzzle
Magazine Puzzle
One In Ten Puzzle
Milestone Puzzle
Dataflow Diagrams Puzzle
Finding Equal Sets Puzzle
Calculate The Sine Function Puzzle
Find The Mode Computation Puzzle
Average Sales wait Puzzle
Buying All The Products Puzzle
Computing Taxes Puzzle
Computing Depreciation Puzzle
Consultant Billing Puzzle
Requisitions Puzzle
Double Duty Puzzle
Moving Average Puzzle
Journal Updating Puzzle
Insurance Losses Puzzle
Permutations: Puzzle
Budgeting Puzzle
Counting Fish Puzzle
Graduation Puzzle
Pairs Of Styles Puzzle
Pepperoni Pizza Puzzle
Sales Promotions Puzzle
Blocks Of Seats Puzzle
Un-grouping Puzzle
Widget Count Puzzle
Two Of Three Puzzle
Budget Versus Actual Puzzle
Personnel Problem Puzzle
Collapsing A Table By Columns Puzzle
Potential Duplicates Puzzle
Playing The Ponies Puzzle
Hotel Room Numbers Puzzle
Gaps - 1 Puzzle
Gaps - 2 Puzzle
Merging Time Periods Puzzle
Barcodes Puzzle
Sorting A String Puzzle
Report Formatting Puzzle
Contiguous Groupings Puzzle
Boxes Puzzle
Age Ranges For Products Puzzle
Four Consecutive Absences Puzzle
Stable Marriages Problem Puzzle
Catching The Next Bus Puzzle
Lifo-fifo Inventory Puzzle
Stock Trends Puzzle
Calculations Puzzle
Scheduling Service Calls Puzzle
A Little Data Scrubbing Puzzle
Derived Tables Or Not? Puzzle
Finding A Pub
Table of Contents provided by Publisher. All Rights Reserved.

Joe Celko's SQL Puzzles and Answers, Second Edition

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Business Applications

Microsoft 365 in easy steps

In Easy Steps

Statistics and Data Handling for Biologists

A Student's Guide

Statistics and Data Handling for Biologists

A Student's Guide

Microsoft 365 Excel For Dummies

For Dummies (Computer/Tech)

Data Science and Social Research III

Epistemology, Methods, Technology, Applications, and Relation to Artificial Intelligence

Sutskever''s List

Foundational Ideas of Modern AI

Database Systems

14th Edition - Design, Implementation, & Management

Microsoft 365 Excel All-in-One For Dummies

Excel for Dummies

SPSS Statistics

5th Edition - A Practical Guide

MYOB For Dummies

9th Edition

Discovering Statistics Using JASP

Soccer Analytics with Machine Learning

Learning Predictive Modeling Techniques with Sports Data

The Value of People Analytics

Using HR Data to Drive Business Results

Microsoft Teams For Dummies

For Dummies (Computer/Tech)

Python for Excel

A Modern Environment for Automation and Data Analysis

Statistics Using Stata

3rd Edition - An Integrative Approach

Hands-On Programming with R

Write Your Own Functions and Simulations

Building Microservices

Designing Fine-Grained Systems 2nd Edition

SharePoint For Dummies

Sharepoint for Dummies

Between You and AI

Unlock the Power of Human Skills to Thrive in an AI-Driven World

Microsoft 365 Word For Professionals For Dummies

For Dummies (Computer/Tech)

Statistical Analysis with R For Dummies

For Dummies (Computer/Tech)

Understanding Statistics in Psychology with SPSS

8th Edition

Ethics in Information Technology

6th edition

This product is categorised by