Зарегистрироваться
Восстановить пароль
FAQ по входу

Celko J. Analytics and OLAP in SQL

  • Файл формата pdf
  • размером 2,57 МБ
  • Добавлен пользователем
  • Описание отредактировано
Celko J. Analytics and OLAP in SQL
Morgan Kaufmann, 2006. — 205 p. — ISBN-10 : 0123695120, ISBN-13: 978-0-12-369512-3.
Basic Reports and History.
Cross-Tabulations.
Dimension Tables.
Data Migration and Scrubbing.
MERGE Statement.
OLAP Basics.
GROUPING Operators.
OLAP Operators in SQL.
Sparseness in Cubes.
Data Quality.
Correlation.
Data Distributions.
Market-Basket Analysis.
Decision, Classification, and Regression Trees.
Computer-Intensive Analysis.
Relationship Analytics.
Database Architectures.
MDX from a SQL Viewpoint.
  • Чтобы скачать этот файл зарегистрируйтесь и/или войдите на сайт используя форму сверху.
  • Регистрация

Смотри также

Подробнее

Celko J. Joe Celko's Complete Guide to NoSQL: What Every SQL Professional Needs to Know about Non-Relational Databases

  • pdf
Morgan Kaufmann, 2013 2014. — 244 p. — ISBN: 9780124071926 Joe Celko's Complete Guide to NoSQL provides a complete overview of non-relational technologies so that you can become more nimble to meet the needs of your organization. As data continues to explode and grow more complex, SQL is becoming less useful for querying data and extracting meaning. In this new world of bigger...
  • 2,55 МБ
  • добавлен
  • описание отредактировано
Подробнее

Celko J. Joe Celko's Data, Measurements and Standards in SQL

  • pdf
Morgan Kaufmann, 2009. — 282 p. — ISBN: 0123747228, 978-0-12-374722-8 На англ. языке. Joe Celko has looked deep into the code of SQL programmers and found a consistent and troubling pattern - a frightening lack of consistency between their individual encoding schemes and those of the industries in which they operate. This translates into a series of incompatible databases,...
  • 4,33 МБ
  • добавлен
  • описание отредактировано
Подробнее

Celko J. Joe Celko's SQL for Smarties: Advanced SQL Programming

  • pdf
Morgan Kaufmann, 2015. — 852 p. — 5th ed. — ISBN: 0128007613, 9780128007617 SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches...
  • 5,66 МБ
  • добавлен
  • описание отредактировано
Подробнее

Celko J. SQL Puzzles and Answers

  • pdf
Second Edition. — Morgan Kaufmann, 2006. — 347 p. — ISBN-10 : 0-12-373596-3, ISBN-13: 978-0-12-373596-3. Contents (Puzzles): Fiscal Year Tables. Absentees. The Anesthesia Puzzle. Security Badges. Alpha Data. Hotel Reservations. Keeping A Portfolio. Scheduling Printers. Available Seats. Wages Of Sin. Work Orders. Claims Status. Teachers. Telephone. Find The Last Two Salaries....
  • 4,07 МБ
  • добавлен
  • описание отредактировано
Подробнее

Celko J. Thinking in Sets. Auxiliary, Temporal, and Virtual Tables in SQL

  • pdf
Morgan Kaufmann, 2008. — 383 p. — ISBN 978-0-12-374137-0. SQL Is Declarative, Not Procedural. Hardware, Data Volume, and Maintaining Databases. Data Access and Records. Lookup Tables. Auxiliary Tables. Views. Virtual Tables. Complicated Functions via Tables. Temporal Tables. Scrubbing Data with Non-1NF Tables. Thinking in SQL. Group Characteristics. Turning Specifi cations into...
  • 7,72 МБ
  • добавлен
  • описание отредактировано
Подробнее

Kimball R., Ross M. The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

  • pdf
Wiley, 2013. — 600 p. — 3rd ed. — ISBN: 1118530802, 9781118530801 The most authoritative and comprehensive guide to dimensional modeling, from its originators—fully updated Ralph Kimball introduced the industry to the techniques of dimensional modeling in the first edition of The Data Warehouse Toolkit (1996). Since then, dimensional modeling has become the most widely accepted...
  • 6,57 МБ
  • добавлен
  • описание отредактировано
Наверх