|
Frequently Bought Together
Customers Who Bought This Item Also Bought
by Celko
|
by Joe Celko
|
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) by Joe Celko |
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems) by Joe Celko |
Joe Celko's Analytics and OLAP in SQL (The Morgan Kaufmann Series in Data Management Systems) by Joe Celko |
Product details
Would you like to update product info or give feedback on images?
|
Product Description
Amazon.co.uk Review
Although Celko denies that the book is about database theory, he often alludes to theory to buttress his practical points. This title is not for novices, as the author points out. Instead its intended audience is SQL programmers with at least a year's experience. The book maintains a fine balance between technical discussion and practical explanation--picking hot topics and offering advice on a wide range of subjects.
The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. However, it does not focus on any commercial product but rather zeroes in on the SQL language. Celko covers all aspects of database design, optimisation and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalisation and how to optimise queries.
This insightful text is manna for all the day-to-day SQL coders banging their heads over the language's subtle challenges. --Stephen W.Plain
Topics covered:
Database design and normalisation, SQL data types, querying, grouping, set operations, optimisation, data scaling and encoding.
--This text refers to an out of print or unavailable edition of this title.
Product Description
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining, conversational style to teach you the best solutions to old and new challenges and to convey the way you need to think if you really want to get the most out of your SQL programming efforts.
Inside, logic- and set-based analyses replace the traditional, procedural approach to problem-solving, helping you make the conceptual leap that separates an SQL guru from the rest of the pack. As you catch on to Celko's approach, you'll devour what he has to say about some of SQL's toughest topics: how aggregate functions really work, the best way to work with NULLs, how and why to fake array structures, and much more.
This book gives special emphasis to SQL-92 and product-independent techniques that let you optimize performance or achieve highly specialized behavior, regardless of the RDBMS with which you work. If you're serious about SQL, you won't let SQL for Smarties out of your sight.
* Presents all-new war stories that give you insight into real-world SQL programming challenges.
* Continues to cover SQL-89 but focuses heavily on the SQL-92 standard.
* Offers still more undocumented tips for working around system deficiencies.
* Teaches scores of advanced techniques that can be used with any product, in any SQL environment.
* Offers expert advice from a noted SQL authority and award-winning columnist.
"THIS CHAPTER DISCUSSES the DDL (Data Definition Language), which is used to create a database schema, and it is related to the next chapter on the theory of database normalization." Read the first page
Concordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Do Customers Ultimately Buy After Viewing This Item?
 |
83% buy the item featured on this page: Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems) £34.99 |
 |
7% buy Learning SQL £20.14 |
 |
4% buy Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems) £17.68 |
 |
3% buy Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems)£21.24 |
Customer Reviews
|
Share your thoughts with other customers:
|
|||||||||||||
Most Helpful Customer Reviews
Share your thoughts with other customers: Create your own review
|
|
Listmania!
Look for similar items by category
- Books > Computing & Internet > Computer Science > Information Systems > Information Retrieval
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Networking & Security > Security > Cryptography & Encryption
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
Your Recent History
(What's this?)|
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. |
