Joe Celko's thinking in sets auxiliary, temporal, and virtual tables in SQL

Joe Celko has looked deep into the code of novice SQL programmers and found a consistent and troubling pattern. These programmers have not changed their approach from writing code for a procedural language, like C, to a declarative language, like SQL. As a result they are not fully using the power a...

Descripción completa

Detalles Bibliográficos
Autor principal: Celko, Joe (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Amsterdam ; Boston : Elsevier / Morgan Kaufmann c2008.
Edición:1st edition
Colección:The Morgan Kaufmann Series in Data Management Systems
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626933606719
Descripción
Sumario:Joe Celko has looked deep into the code of novice SQL programmers and found a consistent and troubling pattern. These programmers have not changed their approach from writing code for a procedural language, like C, to a declarative language, like SQL. As a result they are not fully using the power and capability inherent in SQL and that translates into writing more code than they need to write, more complex code than is needed, and ultimately lower productivity. Thinking in sets reveals the conceptual shift these programmers need to make. Through detailed examples and clear explanation
Notas:Includes index.
Descripción Física:1 online resource (383 p.)
ISBN:9781281172129
9786611172121
9780080557526