Sign up
Forgot password?
FAQ: Login

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

  • pdf file
  • size 7,72 MB
  • added by
  • info modified
Celko J. Thinking in Sets. Auxiliary, Temporal, and Virtual Tables in SQL
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 Code.
Using Procedure and Function Calls.
Numbering Rows.
Keeping Computed Data.
Triggers for Constraints.
Procedural and Data Driven Solutions.
  • Sign up or login using form at top of the page to download this file.
  • Sign up

See also

Details

Celko J. Analytics and OLAP in SQL

  • pdf
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...
  • 2,57 MB
  • added
  • info modified
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 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, each one an island...
  • 4,33 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 Programming Style

  • pdf
Morgan Kaufmann, 2005. — 237 p. — ISBN: 0-12-088797-5. Names and Data Elements. Fonts, Punctuation, and Spacing. Data Declaration Language. Scales and Measurements. Data Encoding Schemes. Coding Choices. How to Use VIEWS. How to Write Stored Procedures. Heuristics. Thinking in SQL.
  • 1,70 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
Up