Joe Celko's SQL for Smarties: Advanced SQL Programming, 3 Edition

Joe Celko, "Joe Celko's SQL for Smarties: Advanced SQL Programming, 3 Edition"
Morgan Kaufmann | 2005 | ISBN: 0123693799 | 840 pages | File type: PDF | 6,3 mb
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 nevertheless alludes to theory often 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 explanationpicking hot topics and offering advice on a wide range of issues.

The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. It does not, however, focus on any commercial product; this guide zeroes in on the SQL language. Celko covers all aspects of database design, optimization, and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalization, and how to optimize 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 normalization, SQL data types, querying, grouping, set operations, optimization, data scaling, and encoding. This text refers to an out of print or unavailable edition of this title.

"This book is a classic, and this revision will merely solidify its position."
Rudy Limeback


[Fast Download] Joe Celko's SQL for Smarties: Advanced SQL Programming, 3 Edition

Related eBooks:
Implementing Splunk 7, Third Edition
What is ERP and Why We Use Oracle Applications R12 (EBS)
R Graphics Cookbook: Practical Recipes for Visualizing Data, 2nd Edition
Scaling Your SQL Server Application
A Guide to Db2 Performance for Application Developers: Code for Performance from the Beginning
Oracle Applications R12 (EBS) Fundamentals for Beginners
Data Security in Cloud Computing
MySQL, Second Edition
A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008
Oracle NoSQL Database: Real-Time Big Data Management for the Enterprise
Professional Microsoft SQL Server 2014 Administration
Advances in Databases and Information Systems
Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.