Joe Celko's SQL for Smarties: Advanced SQL Programming
- ISBN-10
- 0123820235
- ISBN-13
- 9780123820235
- Series
- Joe Celko's SQL for Smarties
- Category
- Computers
- Pages
- 816
- Language
- English
- Published
- 2010-11-22
- Publisher
- Elsevier
- Author
- Joe Celko
Description
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. 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
Get the book
Other editions
-
- 2014-12-16
- 852 pages
- Paperback
- Morgan Kaufmann
-
- 2000
- 553 pages
- Paperback
- Morgan Kaufmann
Similar books
-
Joe Celko's Trees and Hierarchies in SQL for Smarties
By Joe CelkoThe Second Edition of Joe Celko's Trees and Hierarchies in SQL for Smarties covers two new sets of extensions over three entirely new chapters and expounds upon the changes that have occurred in SQL standards since the previous edition's ...
-
Joe Celko's Trees and Hierarchies in SQL for Smarties
By Joe Celko... category="CHILDREN"> Harry Potter J K. Rowling 2005 29.99 XQuery Kick Start James McGovern ...
-
Joe Celko's SQL Programming Style
By Joe CelkoOr have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself? If even one answer is yes, then you need this book.
-
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
By Joe CelkoAdvanced SQL: 1999—Understanding ObjectRelational and Other Advanced Features Jim Melton Database Tuning. Principles, Experiments, and Troubleshooting Techniques Dennis Shasha and Philippe Bonnet SQL:1999–Understanding Relational ...
-
Joe Celko's Analytics and OLAP in SQL
By Joe CelkoAdvanced SQL: 1999—Understanding Object-Relational and Other Advanced Features Jim Melton Database Tuning: Principles, Experiments, and Troubleshooting Techniques Dennis Shasha and Philippe Bonnet SQL:1999—Understanding Relational ...
-
Joe Celko's Data and Databases: Concepts in Practice
By Joe CelkoThis text covers basic database concepts to provide a conceptual understanding of data and databases necessary for database design and development.
-
Joe Celko's SQL Puzzles and Answers
By Joe CelkoThis book is recommended for database programmers with a good knowledge of SQL.
-
Joe Celko’s Complete Guide to NoSQL: What Every SQL Professional Needs to Know about Non-Relational Databases
By Joe CelkoLearn where, when, and why the benefits of NoSQL outweigh those of SQL with Joe Celko's Complete Guide to NoSQL. This book covers three areas that make today's new data different from the data of the past: velocity, volume and variety.
-
Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design
By Terry HalpinEnglewood Cliffs, NJ: Prentice Hall. Kennedy, P. 1993. Preparing for the Twenty-First Century. London: Harper Collins. Kent, W. 1977. “Entities and Relationships in Information”. Proc. 1977 IFIP Working Conf. on Modelling in Data Base ...
-
SQL and Relational Theory: How to Write Accurate SQL Code
By C. DateJim Melton and Alan R. Simon: SQL:1999─Understanding Relational Components; Jim Melton: Advanced SQL:1999─Understanding Object-Relational and Other Advanced Features. San Francisco, Calif.: Morgan Kaufmann (2002 and 2003, ...