Joe Celko's SQL for Smarties

Advanced SQL Programming

Joe Celko - Collection SQL Programming/Data Management

808 pages, parution le 29/11/2005 (3^eme édition)

Ajouter à une liste

Indisponible

Résumé

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 update 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.

L'auteur - Joe Celko

Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on the DBMS CompuServe Forum, his column in Intelligent Enterprise (which won several Reader's Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celko's SQL for Smarties: Advanced SQL Programming, Joe Celko's SQL Puzzles and Answers, and Joe Celko's Trees and Hierarchies in SQL for Smarties, all published by Morgan Kaufmann.

Sommaire

Introduction to the Third Edition
Database Design
Normalization
Numeric Data in SQL
Temporal Data Types in SQL
Character Data Types in SQL
NULLs: Missing Data in SQL
Multiple Column Data Elements
Table Operations
Comparison or Theta Operators
Valued Predicates
CASE Expressions
LIKE Predicate
BETWEEN and OVERLAPS Predicates
The [NOT] IN() Predicate
EXISTS() Predicate
Quantified Subquery Predicates
The SELECT Statement
VIEWS, Derived Tables, Materialized Tables, and Temporary Tables
Partitioning Data in Queries
Grouping Operations
Aggregate Functions
Auxiliary Tables
Statistics in SQL
Regions, Runs, Gaps, Sequences, and Series
Arrays in SQL
Set Operations
Subsets
Trees and Hierarchies in SQL
Temporal Queries
Graphs in SQL
OLAP in SQL
Transactions and Concurrency Control
Optimizing SQL
References
Index
About the Author

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Morgan Kaufmann
Auteur(s)	Joe Celko
Collection	SQL Programming/Data Management
Parution	29/11/2005
Édition	3^eme édition
Nb. de pages	808
Format	19 x 23,5
Couverture	Broché
Poids	1687g
Intérieur	Noir et Blanc
EAN13	9780123693792
ISBN13	978-0-12-369379-2