 |
|
| JOE CELKO'S ANALYTICS AND OLAP IN SQL
| |
| | |
|
|
 To order this title, and for more information, click here
By
Joe Celko, Independent Consultant & Columnist for Intelligent Enterprise, USA
Description
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.
This book is not an in-depth look at particular subjects, but an
overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face?if they want to grow.
Audience
Virtually everyone who has bought and liked a book by Joe Celko (and there are over 75,000 of those people) and the many tens of thousands
more who have been helped by his advice in magazine columns or on newsgroups are part of the market for this book. Mostly the market
includes experienced SQL programmers who have worked with OLTP systems who need to learn techniques--and even some tricks--that they
can use in an OLAP situation.
Contents
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
| Bibliographic details |
Paperback, 208 pages, publication date: JUL-2006
ISBN-13: 978-0-12-369512-3
ISBN-10: 0-12-369512-0
Imprint: MORGAN KAUFFMAN
|
| Price and Ordering |
Price:
EUR 38.95
USD 43.95
GBP 25.99
|  |
Books and book related electronic products are priced in US dollars (USD), euro (EUR), and Great Britain Pounds (GBP). USD prices apply to the Americas and Asia Pacific. EUR prices apply in Europe and the Middle East. GBP prices apply to the UK and all other countries.
|
See also information about conditions of sale & ordering procedures, and links to our regional sales offices.
|
077/762
Last update: 27 Sep 2008
|
|
| |
| | |
|
|
| |
