Joe Celko’s SQL For Smarties

Joe Celko’s SQL For Smarties : advanced SQL programming, fourth ed. / Joe Celko, Morgan Kaufmann, 2011

If you can get past the cute title, this book is good. It is for advanced programmers, and assumes you have ‘at least a year of actual experience’. 800 pages. Contents:

1 – Databases versus File Systems
2 – Transactions and Concurrency Control
3 – Schema Level Objects
4 – Locating Data and Special Numbers
5 – Base Tables and Related Elements
6 – Procedural, Semiprocedural, and Declarative Programming
7 – Procedural Constructs
8 – Auxiliary Tables
9 – Normalization
10 – Numeric Data Types
11 – Temporal Data Types
12 – Character Data Types
13 – NULLs: Missing Data in SQL
14 – Multiple Column Data Elements
15 – Table Operations
16 – Comparison or Theta Operators
17 – Valued Predicates
18 – CASE Expressions
19 – LIKE and SIMILAR TO Predicates
20 – BETWEEN and OVERLAPS Predicates
21 – The [NOT] IN() Predicate
22 – EXISTS() Predicate
23 – Quantified Subquery Predicates
24 – The Simple SELECT Statement
25 – Advanced SELECT Statements
26 – Virtual Tables: VIEWs, Derived Tables, CTEs, and MQTs
27 – Partitioning Data in Queries
28 – Grouping Operations,
29 – Simple Aggregate Functions
30 – Advanced Grouping, Windowed Aggregation, and OLAP in SQL
31 – Descriptive Statistics in SQL
32 – Subsequences, Regions, Runs, Gaps, and Islands
33 – Matrices in SQL
34 – Set Operations
35 – Subsets
36 – Trees and Hierarchies in SQL
37 – Graphs in SQL
38 – Temporal Queries
39 – Optimizing SQL

Get it here at OPL     Amazon Review

Carleton Library     University of Ottawa

Leave a Reply

Your email address will not be published. Required fields are marked *