Joe Celko's SQL for smarties : advanced SQL programming / Joe Celko.

Joe Celko's SQL for smarties : advanced SQL programming /

Show other versions (5)

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

Full description

Saved in:
Bibliographic Details
Main Author: Celko, Joe
Format: Electronic eBook
Language:English
Published: Amsterdam ; Boston : Morgan Kaufmann, ©2005.
Edition:3rd ed.
Series:Morgan Kaufmann series in data management systems.
Subjects:
SQL (Computer program language)
dissertations.
Academic theses.
Online Access: Full text (Wentworth users only)
Local Note:ProQuest Ebook Central
Table of Contents:
  • 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.

Similar Items