Rating:
Author: Joe Celko
ISBN : B0050P497U
New from $18.84
Format: PDF
You can download Free Joe Celko's SQL for Smarties: Advanced SQL Programming from with Mediafire Link Download Link
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 15 years later and in its fourth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fourth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today.
KEY FEATURES
- Expert advice from a noted SQL authority and award-winning columnist who has given ten years service to the ANSI SQL standards committee
- Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL 92 or SQL 2008 environment
- Offers tips for working around deficiencies and gives insight into real-world challenges
Direct download links available for Free Joe Celko's SQL for Smarties: Advanced SQL Programming
- File Size: 2808 KB
- Print Length: 816 pages
- Publisher: Morgan Kaufmann; 4 edition (November 22, 2010)
- Sold by: Amazon Digital Services, Inc.
- Language: English
- ASIN: B0050P497U
- Text-to-Speech: Enabled
X-Ray:
- Lending: Not Enabled
- Amazon Best Sellers Rank: #183,420 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
- #83
in Books > Computers & Technology > Databases > SQL
- #83
in Books > Computers & Technology > Databases > SQL
Free Joe Celko's SQL for Smarties: Advanced SQL Programming
This book attempts to go over some advanced topics in SQL programming. While it succeeds in showing these concepts, the main issue is that the implementations are too generic and don't work in every implementation of SQL. It would be nice to see a table or indication of some sort that shows if the topic discussed works in an individual implementation of SQL. As I read a section that sounded great, I would test it out in Microsoft SQL server only to find that it was not supported. It would be nice to know if what was discussed was available in any SQL implementation or if it was only part of the ANSI SQL XX standards. He talks to SQL-92 standards that he says are not implemented in many (or any!) database engine... That does not help.
For the items that are applicable, they are so specific, I can't image any time that I would need them. For example matrix multiplication and graph theory.
On the advanced topics, the real good ones are covered in more detail in his other books. I would recommend Joe Celko's Trees and Hierarchies which goes into more detail from the trees section in this book.
Overall, I'm glad I reviewed this book, but I would like to see a language specific version that provided working examples.
By King B
After Learning the Basics of SQL as well as the admin side of Oracle SQL, the knowledge of how far SQL has developed in terms of being a language that gets data from one person to another, is quite an amazing piece of work, and the glitz for most people who see the result is in the User Interface, since they never see the hard work that goes on underneath the main part of an SQL data machine.
This book takes you through Tables as entities, tables as relationships, and the idea of Rows versus records.In the "great Schema" of things, Transactions and concurrency control is explained and illustrated in detail.Coming from the detail of Schema level Objects to the various types of Tables and the language issues from the earliest SQL to the later XML forms, it is all illustrated in this book for those who wish to work with the Core Essential that is SQL.
By Santeria
-
Download Link 2