Panier
Livraison gratuite
Nous sommes Neutres au Carbone

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

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

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


€33.00
État - Très bon état
Disponible en seulement 1 exemplaire(s)

Résumé

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 Résumé

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 Avis

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

À propos de 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.

Sommaire

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

Informations supplémentaires

GOR004338382
9780123693792
0123693799
Joe Celko's SQL for Smarties: Advanced SQL Programming Joe Celko (Independent Consultant, Austin, Texas)
Occasion - Très bon état
Broché
Elsevier Science & Technology
20050823
840
N/A
La photo du livre est présentée à titre d'illustration uniquement. La reliure, la couverture ou l'édition réelle peuvent varier.
Il s'agit d'un livre d'occasion - par conséquent, il a été lu par quelqu'un d'autre et il présente des signes d'usure et d'utilisation antérieure. Dans l'ensemble, nous nous attendons à ce qu'il soit en très bon état, mais si vous n'êtes pas entièrement satisfait, veuillez prendre contact avec nous.