Joe Celko's SQL for Smarties
Morgan Kaufmann Publishers In (Verlag)
978-0-12-369379-2 (ISBN)
- Titel erscheint in neuer Auflage
- Artikel merken
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, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics.
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.
Chapter 1: Database Design
Chapter 2: Normalization
Chapter 3: Numeric Data in SQL
Chapter 4: Temporal Data Types in SQL
Chapter 5: Character Data Types in SQL
Chapter 6: NULLs
Chapter 7: Multiple Column Data Elements
Chapter 8: Table Operations
Chapter 9: Comparison or Theta Operators
Chapter 10: Valued Predicates
Chapter 11: CASE Expressions
Chapter 12: LIKE Predicate
Chapter 13: Between and Overlaps Predicates
Chapter 14: The [NOT] IN() predicate
Chapter 15: EXISTS() predicate
Chapter 16: Quantified Subquery Predicates
Chapter 17: The SELECT Statement
Chapter 18: VIEWs, Derived Tables, Materialized Tables, and Temporary Tables
Chapter 19: Partitioning Data in Queries
Chapter 20: Grouping Operations
Chapter 21: Aggregate Functions
Chapter 22: Auxiliary Tables
Chapter 23: Statistics in SQL
Chapter 24: Regions, Runs, Gaps, Sequences, and Series
Chapter 25: Arrays in SQL
Chapter 26: Set Operations
Chapter 27: Subsets
Chapter 28: Trees and Hierarchies in SQL
Chapter 29: Temporal Queries
Chapter 30: Graphs in SQL
Chapter 31: OLAP in SQL
Chapter 32: Transactions and Concurrency Control
Chapter 33: Optimizing SQL
References
General References
Logic
Mathematical Techniques
Random Numbers
Scales and Measurements
Missing Values
Regular Expressions
Graph Theory
Introductory SQL Books
Optimizing Queries
Temporal Data and the Year 2000 Problem
SQL Programming Techniques
Classics
Forum
Updatable VIEWs
Theory, Normalization, and Advanced Database Topics
Books on SQL-92 and SQL-99
Standards and Related Groups
Web Sites Related to SQL
Statistics
Temporal Databases
Index
About the Author
| Erscheint lt. Verlag | 23.8.2005 |
|---|---|
| Reihe/Serie | The Morgan Kaufmann Series in Data Management Systems |
| Verlagsort | San Francisco |
| Sprache | englisch |
| Maße | 191 x 235 mm |
| Gewicht | 1665 g |
| Themenwelt | Informatik ► Datenbanken ► SQL Language |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| ISBN-10 | 0-12-369379-9 / 0123693799 |
| ISBN-13 | 978-0-12-369379-2 / 9780123693792 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
