Celko J. SQL Programming Style

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...

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...

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, each one an island...

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...

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....

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...