Introduction Chapter 1: Basic Reports & History Chapter 2: Crosstabs Chapter 3: Star and Snowflake Schemas Chapter 4: Data Migration Chapter 5: MERGE Statement Chapter 6: OLAP Basics Chapter 7: GROUPING Operators in SQL Chapter 8: OLAP Operators in SQL Chapter 9: Cubes Chapter 10: Data Quality Chapter 11: Correlation Chapter 12: Distributions Chapter 13: Market Baskets Chapter 14: Decision and Regression Trees Chapter 15: Computer Intensive Analysis Chapter 16: Relationship Analytics Chapter 17: Database Architectures
The first book that teaches what SQL programmers need in order to successfully make the transition from transactional systems (OLTP) into the world of OLAP.
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.