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

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

  • Файл формата pdf
  • размером 7,72 МБ
  • Добавлен пользователем
  • Описание отредактировано
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.
  • Чтобы скачать этот файл зарегистрируйтесь и/или войдите на сайт используя форму сверху.
  • Регистрация

Смотри также

Подробнее

Celko J. Analytics and OLAP in SQL

  • pdf
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...
  • 2,57 МБ
  • добавлен
  • описание отредактировано
Подробнее

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. Joe Celko's Trees and Hierarchies in SQL for Smarties

  • pdf
2nd Edition. — Morgan Kaufmann, 2012. — 278 p. — ISBN: 978-0-12-387733-8. На англ. языке. The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database...
  • 3,92 МБ
  • добавлен
  • описание отредактировано
Подробнее

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 МБ
  • добавлен
  • описание отредактировано
Подробнее

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 МБ
  • добавлен
  • описание отредактировано
Наверх