JOE CELKO'S SQL FOR SMARTIES: ADVANCED SQL PROGRAMMING
ebook

JOE CELKO'S SQL FOR SMARTIES: ADVANCED SQL PROGRAMMING (ebook)

CELKO, JOE

$826.00
IVA incluido
Editorial:
MORGAN KAUFMANN
Materia
INFORMATICA
ISBN:
9780080460048
Páginas:
840
Formato:
PDF
Idioma:
Inglés
DRM
Si

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, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance.

In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics.

* 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.
* Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment.
* Offers tips for working around system deficiencies.
* Continues to use war stories--updated!--that give insights into real-world SQL programming challenges.

Otros libros del autor

  • JOE CELKO'S ANALYTICS AND OLAP IN SQL
    CELKO, JOE
    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 SQL’s 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 ove...

    $674.00

  • JOE CELKO'S SQL PUZZLES AND ANSWERS
    CELKO, JOE
    In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles—and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. Thes...

    $801.00

  • JOE CELKO'S THINKING IN SETS: AUXILIARY, TEMPORAL, AND VIRTUAL TABLES IN SQL: AUXILIARY, TEMPORAL, AND VIRTUAL TABLES IN SQL
    CELKO, JOE
    Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.This book will change the way you think about the ...

    $407.00

  • JOE CELKO'S SQL FOR SMARTIES: ADVANCED SQL PROGRAMMING
    CELKO, JOE
    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 programmers and practitioners to become SQL masters themselves! These are not ...

    $826.00

  • JOE CELKO'S TREES AND HIERARCHIES IN SQL FOR SMARTIES
    CELKO, JOE
    Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioner’s guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics i...

    $597.00