Joe Celko's SQL puzzles & answers / Joe Celko.
By: Celko, Joe
.
Material type: 
BookPublisher: San Francisco, CA : Morgan Kaufmann, 1997Description: xiv, 192 p. ; 23 cm. + pbk.ISBN: 1558604537 .Other title: SQL puzzles & answers | SQL puzzles and answers.Subject(s): SQL (Computer program language)DDC classification: 005.756 | Item type | Current library | Call number | Copy number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|---|
| General Lending | MTU Bishopstown Library Lending | 005.756 (Browse shelf(Opens below)) | 1 | Available | 00015586 | ||
| General Lending | MTU Bishopstown Library Lending | 005.756 (Browse shelf(Opens below)) | 1 | Available | 00015585 |
Enhanced descriptions from Syndetics:
Joe Celko challenges you with his trickiest puzzles and then helps you conquer them with a variety of solutions and explanations. The puzzles are a compilation from Joe's columns in DBMS and Database Programming & Design magazines. They include new, never-before-published puzzles plus new solutions and extra background for previously published puzzles. In his usual entertaining and informative style, Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective. Through the practical, enjoyable puzzles, he introduces immediately useful new techniques and applications for SQL programming, and shows the database programmer how to write and use non-procedural programs.
Includes index.
Defining Data -- Formatting Data -- Selecting Data -- Computing Things -- Grouping Data.
Table of contents provided by Syndetics
- Chapter 1 Defining Data
- Chapter 2 Formatting Data
- Chapter 3 Selecting Data
- Chapter 4 Computing Things
- Chapter 5 Grouping Data
Author notes provided by Syndetics
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.