Böcker av Joe (Independent Consultant Celko

Demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles that you frequently face. This book presents a collection of SQL puzzles with a variety of solutions and explanations.

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? This title intends to change the way you think about the problems you solve with SQL programs. Focusing on three key table-based techniques, it reveals their power through detailed examples and explanations.

Provides an overview of non-relational technologies so that you can become more nimble to meet the needs of your organization. This book covers three areas that make today's new data different from the data of the past: velocity, volume and variety.

5th edition.

By collecting and detailing the diverse standards of myriad industries, and giving a declaration for the units that can be used in an SQL schema, this book enables readers to write and implement portable data that can interface to many external application systems, allowing readers to cross business boundaries and move up the career ladder.

Covers OLAP (On-Line Analytical Processing), extensions in SQL-99. This book presents an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face-if they want to grow. It teaches what SQL programmers need in order to make the transition from transactional systems (OLTP) into OLAP.

Provides heuristics, rules, tips, and tricks that intend to help readers improve their SQL programming style and proficiency, and format and write portable, readable, maintainable SQL code. This book enables readers to give their group a coding standard for internal use, to enable programmers to use a consistent style.