by Joe Celko
|
by Celko
|
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 |
See buying choices for this item to see if it's one of the millions that are eligible for Amazon Prime.
|
Customers Viewing This Page May Be Interested in These Sponsored Links(What is this?) |
Customers Who Bought This Item Also Bought
Product details
Would you like to update product info or give feedback on images?
|
Product Description
Amazon.co.uk Review
In the SQL database community, Joe Celko is a well-known columnist and purveyor of valuable insights. In Joe Celko's SQL for Smarties: Advanced SQL Programming, he picks up where basic SQL training and experience leaves many database professionals and offers tips, techniques and explanations that help readers extend their capabilities to top-tier SQL programming.
In the SQL database community, Joe Celko is a well-known columnist and purveyor of valuable insights. In Joe Celko's SQL for Smarties: Advanced SQL Programming, he picks up where basic SQL training and experience leaves many database professionals and offers tips, techniques and explanations that help readers extend their capabilities to top-tier SQL programming.
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.
Book Description
Get the most from your database applications through clever SQL programming Joe Celko shares his most useful tips and tricks for advanced SQL programming to help the working programmer gain performance and work around system deficiencies. Addressing real problems that people building real applications face, Joe provides new and creative solutions. A noted consultant, lecturer, and columnist for DBMS and Database Programming & Design magazines, Joe uses entertaining anecdotes and "war stories" to provide real-world insight into SQL programming and warn about potential problems. Become an expert programmer This is the first advanced SQL book available that provides a comprehensive presentation of the techniques necessary to help you progress from a casual user of SQL to an expert programmer. Joe uses an informal, conversational writing style to explain why a particular trick works, so the working programmer can apply it directly to his or her own programming needs. Relying primarily on the SQL-89 features that are now supported by commercial RDBMSs, he also includes an extensive discussion of SQL-92, with information on how it's being implemented in current and future database products. The tips and techniques presented here are not product specific, so they allow programmers to maximize any system's performance.
See all Product Description
Inside This Book
(Learn More)
Browse and search another edition of this book.
Browse and search another edition of this book.
First Sentence
"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
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
"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
Explore More
Concordance
Browse Sample PagesConcordance
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?
 |
77% buy the item featured on this page: Joe Celko's SQL for Smarties: Advanced SQL Programming |
 |
7% buy Learning SQL £24.29 |
 |
6% buy Joe Celko's SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems)£35.15 |
 |
5% buy SQL Hacks £15.99 |
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 > Databases > Applications > SQL
- Books > Computing & Internet > Databases > SQL
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.
The Body Shop |
More From Joe Celko
Joe Celko's Thinking in Sets... Perfectly intelligent programmers often struggle when forced to work...
Read more
|
Up to 50% off Dental Care |
Treat Someone
With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is). |
|||||||
| |||||
Your Recent History
(What's this?)|
You have no recently viewed items or searches.
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. Look to the right column to find helpful suggestions for your shopping session. |
Continue Shopping: Top Sellers
| ||||
Amazon Home | |
| International Sites: United States | Germany | France | Japan | Canada | China | |
| Business Programs: Sell on Amazon | Fulfilment by Amazon | Join Associates | Join Advantage | |
| Customer Service | Help | View Basket | Your Account | |
| About Amazon.co.uk | Careers at Amazon | |
| Conditions of Use & Sale | Privacy Notice © 1996-2009, Amazon.com, Inc. and its affiliates |