Sign up
Forgot password?
FAQ: Login

Celko J. Analytics and OLAP in SQL

  • pdf file
  • size 2,57 MB
  • added by
  • info modified
Celko J. Analytics and OLAP in SQL
Morgan Kaufmann, 2006. — 205 p. — ISBN10: 0123695120, ISBN13: 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.
  • Sign up or login using form at top of the page to download this file.
  • Sign up

See also

Details

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 MB
  • added
  • info modified
Details

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 MB
  • added
  • info modified
Details

Celko J. SQL Puzzles and Answers

  • pdf
Second Edition. — Morgan Kaufmann, 2006. — 347 p. — ISBN10: 0-12-373596-3, ISBN13: 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 MB
  • added
  • info modified
Details

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...
  • 7,72 MB
  • added
  • info modified
Details

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...
  • 6,57 MB
  • added
  • info modified
Details

Nisbet R., Elder J., Miner G. Handbook of Statistical Analysis and Data Mining Applications

  • pdf
Academic Press, 2009. — 864 p. — ISBN: 0123747651. Robert Nisbet, Pacific Capital Bank Corporation, Santa Barbara, CA, USA John Elder, Elder Research, Inc. and the University of Virginia, Charlottesville, USA Gary Miner, StatSoft, Inc. , Tulsa, OK, USA Description The Handbook of Statistical Analysis and Data Mining Applications is a comprehensive professional reference book...
  • 41,49 MB
  • added
  • info modified
Up