
Joe Celko's SQL for Smarties
Format: Paperback
ISBN13: 9780123820228
✨ Featured Offer
Overview
Joe Celkos SQL for Smarties: Advanced SQL Programming offers tips and techniques in advanced programming. This book is the fourth edition and it consists of 39 chapters, starting with a comparison between databases and file systems. It covers transactions and currency control, schema level objects, locating data and schema numbers, base tables, and auxiliary tables. Furthermore, procedural, semi-procedural, and declarative programming are explored in this book.
The book also presents the different normal forms in database normalization, including the first, second, third, fourth, fifth, elementary key, domain-key, and Boyce-Codd normal forms. It also offers practical hints for normalization and denormalization. The book discusses different data types, such as the numeric, temporal and character data types; the different predicates; and the simple and advanced SELECT statements. In addition, the book presents virtual tables, and it discusses data partitions in queries; grouping operations; simple aggregate functions; and descriptive statistics, matrices and graphs in SQL. The book concludes with a discussion about optimizing SQL. It will be of great value to SQL programmers.
| ISBN-13 | 9780123820228 |
|---|---|
| ISBN-10 | 0123820227 |
| Weight | 2.98 Pounds |
| Dimensions | 7.52 x 1.62 x 9.25 In |
| List Price | $68.95 |
| Edition | 4th Edition |
| Format | Paperback |
|---|---|
| Language | English |
| Pages | 816 pages |
| Publisher | Morgan Kaufmann |
| Published On | 2010-11-22 |
View All Offers
Sort by:
Seller details
Dallas, TX, USA
Free delivery by: 31 Mar 2026
Seller details
Santa Clarita, CA, USA
Free delivery by: 31 Mar 2026
Seller details
Franklin Lakes, NJ, USA
Free delivery by: 31 Mar 2026
Seller details
Santa Clarita, CA, USA
Free delivery by: 31 Mar 2026