Книга: Joe Celko «Joe Celko's Analytics and OLAP in SQL»

Joe Celko's Analytics and OLAP in SQL

Before SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQLs declarative, set-oriented programming. This book covers the next step in your growth. OLAP (On-Line Analytical Processing), Data Warehousing and Analytics involve seeing data in the aggregate and over time, not as single transactions. Once more it is time to unlearn what you were previously taught. This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will faceif they want to grow. - Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums. - First book that teaches what SQL programmers need in order to successfully make...

Издательство: "Morgan Kaufmann" (2006)

ISBN: 9780123695123

Купить за 672.3 руб на Озоне

Joe Celko

Joe Celko is a relational database expert and author from Austin, Texas, United States. He has participated on the ANSI X3H2 Database Standards Committee, and helped write the SQL-89 and SQL-92 standards. He is the author of seven books, and over 800 published articles on SQL and other database topics.

He is credited with coining the term lasagna code and popularizing Michael J. Kamfonas' [http://www.kamfonas.com/id3.html] Nested Sets model for trees in SQL.

Joe is often found on the Microsoft newsgroup microsoft.public.sqlserver.programming where he champions standards based design and coding. His posts are often harshly received, due to their no nonsense, abrasive and degrading approach. His attention to not only offering solutions and advice, but insisting that SQL developers change their mindset from procedural programming methodology used since the days of tape based file systems to set based relational database specific thinking is a central theme of many of his posts there. Joe Celko the SQL Apprentice, a website not maintained by Celko, has been a collection of his answers in SQL newsgroups that he frequents.

Bibliography

* Joe Celko's Analytics and OLAP in SQL (Morgan-Kaufmann, 2006) ISBN 978-0-12-369512-3
* Joe Celko's Data and Databases (Morgan Kaufmann, 1999) ISBN 978-1-55860-432-2
* Joe Celko's SQL for Smarties (3rd Edition, Morgan-Kaufmann, 1995) ISBN 978-0-12-369379-2
* Joe Celko's SQL Programming Style ISBN 978-0-12-088797-2
* Joe Celko's SQL Puzzles and Answers (2nd edition, Morgan-Kaufmann 2006) ISBN 978-0-12-373596-6
* Joe Celko's Trees and Hierarchies (Morgan-Kaufmann, 2004) ISBN 978-1-55860-920-4
* Joe Celko’s Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL. (Morgan-Kaufmann, 2008) ISBN 978-0123741370

Translations to other languages also available for most of these titles

External links

* [http://www.celko.com/ Official Website]

Источник: Joe Celko

Другие книги схожей тематики:

АвторКнигаОписаниеГодЦенаТип книги
Joe CelkoJoe Celko's Analytics and OLAP in SQLBefore SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQLs declarative… — Morgan Kaufmann, Подробнее...2006
672.3бумажная книга

См. также в других словарях:

  • Joe Celko — is a relational database expert and author from Austin, Texas, United States. He has participated on the ANSI X3H2 Database Standards Committee, and helped write the SQL 89 and SQL 92 standards. He is the author of seven books, and over 800… …   Wikipedia

  • Joe Celko — ist ein Experte für Relationale Datenbanken aus Austin, Texas. Inhaltsverzeichnis 1 Leben 2 Werke (Auswahl) 3 Einzelnachweise 4 Weblinks …   Deutsch Wikipedia

  • Celko — Joe Celko ist ein Experte für Relationale Datenbanken aus Austin, Texas. Er war Mitglied im ANSI X3H2 Database Standards Committee und half mit, die SQL 89 und SQL 92 Normen zu entwerfen. Er ist Autor von sechs Büchern und über 700… …   Deutsch Wikipedia

Поделиться ссылкой на выделенное

Прямая ссылка:
Нажмите правой клавишей мыши и выберите «Копировать ссылку»