Warenkorb
Kostenloser Versand
Unsere Operationen sind klimaneutral

Joe Celko's SQL for Smarties Joe Celko (Independent Consultant, Austin, Texas)

Joe Celko's SQL for Smarties von Joe Celko (Independent Consultant, Austin, Texas)

Joe Celko's SQL for Smarties Joe Celko (Independent Consultant, Austin, Texas)


12.50
Zustand - Sehr Gut
Nur noch 1

Zusammenfassung

Offers solutions to 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. This edition teaches various advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment.

Joe Celko's SQL for Smarties Zusammenfassung

Joe Celko's SQL for Smarties: Advanced SQL Programming Joe Celko (Independent Consultant, Austin, Texas)

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's SQL for Smarties Bewertungen

This book is a classic, and this revision will merely solidify its position. --Rudy Limeback SQL for Smarties is a well-known and highly regarded text in the industry and a new edition of the book will be sought by database practitioners regardless of the DBMS they use. --Craig Mullins, BMC Software

Über Joe Celko (Independent Consultant, Austin, Texas)

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.

Inhaltsverzeichnis

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

Zusätzliche Informationen

GOR004338382
9780123693792
0123693799
Joe Celko's SQL for Smarties: Advanced SQL Programming Joe Celko (Independent Consultant, Austin, Texas)
Gebraucht - Sehr Gut
Broschiert
Elsevier Science & Technology
20050823
840
N/A
Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.
Dies ist ein gebrauchtes Buch. Es wurde schon einmal gelesen und weist von der früheren Nutzung Gebrauchsspuren auf. Wir gehen davon aus, dass es im Großen und Ganzen in einem sehr guten Zustand ist. Sollten Sie jedoch nicht vollständig zufrieden sein, setzen Sie sich bitte mit uns in Verbindung.