Publications

Joe Celko's Analytics and OLAP in SQL

Order now and receive 15% off PLUS free shipping (use offer code 84914)! Buy 3 or books and get 20% off (use offer code 84915). To order, visit http://books.elsevier.com/mk/?isbn=0123695120

Before SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQL's declarative, set-oriented programming. This book covers the next step in your growth. OLAP (On-Line Analytical Processing), Data Warehousing and Analytics involve seeing data in the aggregate and over time, not as single transactions. Once more it is time to unlearn what you were previously taught.

Table of Contents:
Introduction
1. Basic Reports & History
2. Crosstabs
3. Star and Snowflake Schemas
4. Data Migration
5. MERGE Statement
6. OLAP Basics
7. GROUPING Operators in SQL
8. OLAP Operators in SQL
9. Cubes
10. Data Quality
11. Correlation
12. Distributions
13. Market Baskets
14. Decision and Regression Trees
15. Computer Intensive Analysis
16. Relationship Analytics
17. Database Architectures

ISBN: 0123695120
July 2006
Paperback
206 Pages
List Price: $39.95