- Out-of-Stock
Joe Celko's Analytics and OLAP in SQL
ID: 173324
Joe Celko
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 seen in aggregate and over time, not as single transactions. Once more it is time to unlearn what was previously taught.
RDBMS programmers a map of the terra incognita they will have to grow.
* Expert advice from a known SQL authority and award-winning columnist, who has given these years of service to readers.
* First book that teaches what SQL programmers need in order to successfully transfer data from OLAP.
* Offers real-world insights and lots of practical examples.
* Covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software.
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
RDBMS programmers a map of the terra incognita they will have to grow.
* Expert advice from a known SQL authority and award-winning columnist, who has given these years of service to readers.
* First book that teaches what SQL programmers need in order to successfully transfer data from OLAP.
* Offers real-world insights and lots of practical examples.
* Covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software.
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
173324
Other products in the same category (16)
Roberto Verdone, Davide Dardari, Gianluca Mazzini, Andrea Conti
Delivery date unknown
No product available!
Adapter dedicated to Omnivision cameras. Allows you to connect an image sensor to the evaluation kit. ArduCAM B0012
Retired
No product available!
The 5V/2A wireless charging module is an advanced solution for contactless power transfer, utilizing magnetic-coupled resonance technology. It ensures high energy transfer efficiency (up to 90%) with minimal power consumption. The module\'s ability to be fully sealed makes it waterproof and dustproof, extending its lifespan and increasing usability. It is perfect for powering phones, portable devices, and DIY projects. DFRobot DFR0712
Retired
No product available!
No product available!
Printed circuit board and programmed clock system with a 55mm display set by means of GPS. AVT5522 / 2 A +
Retired
No product available!
No product available!
No product available!
Helicopter micro remote controlled, coaxial, 2.4Ghz, 4-channel, Dual-mode transmitter, RTF (HK17580)
Retired
No product available!
Pmod DPG1 is a module with a differential pressure sensor, based on the NXP MP3V5010DP system. The PCB also includes an analogue-digital ADCS7476 converter from Texas Instrument. The module allows to detect the pressure difference between two ports. The SPI interface is used for communication with the module. Digilent 410-333
Retired
No product available!
No product available!
No product available!
No product available!
Kit with Raspberry Pi computer built into the keyboard. Equipped with a power supply, mouse, HDMI cable and 16 GB microSD card. Raspberry Pi 400 Personal Computer Kits UK
Retired
No product available!
No product available!
The Sunon blower fan is a compact and efficient cooling system with low noise level, ideal for a variety of applications, ensuring the optimal operating temperature of components and long life
Retired
No product available!
No product available!
Joe Celko