Celko J. SQL Programming Style

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

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

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

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

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