No es necesario ningún dispositivo Kindle. Descárgate una de las apps de Kindle gratuitas para comenzar a leer libros Kindle en tu smartphone, tablet u ordenador.

  • Apple
  • Android
  • Windows Phone
  • Android

Obtén la app gratuita:

Precio lista ed. digital: EUR 62,86
Precio Kindle: EUR 37,06

Ahorra EUR 15,89 (30%)

IVA incluido (si corresponde)

Estas promociones se aplicarán a este artículo:

Algunas promociones pueden combinarse; otras no. Para más detalles, revisa los términos y condiciones de cada promoción.

Enviar a mi Kindle o a otro dispositivo

Enviar a mi Kindle o a otro dispositivo

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) de [Celko, Joe]
Anuncio de app de Kindle

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) 4 , Versión Kindle

Ver los 2 formatos y ediciones Ocultar otros formatos y ediciones
Precio Amazon
Nuevo desde Usado desde
Versión Kindle
"Vuelva a intentarlo"
EUR 37,06

Kindle Unlimited
Lee más de 1 millón de eBooks en cualquier dispositivo Kindle o en la aplicación gratuita Kindle. Pruébalo gratis durante 30 días

Descripción del producto


"If you work with SQL in any way, shape, or form, the most recent edition of Joe Celko’s SQL for Smarties needs to be on your bookshelf!"--Data Technology Today Blog

Descripción del producto

Joe Celkos SQL for Smarties: Advanced SQL Programming offers tips and techniques in advanced programming. This book is the fourth edition and it consists of 39 chapters, starting with a comparison between databases and file systems. It covers transactions and currency control, schema level objects, locating data and schema numbers, base tables, and auxiliary tables. Furthermore, procedural, semi-procedural, and declarative programming are explored in this book.

The book also presents the different normal forms in database normalization, including the first, second, third, fourth, fifth, elementary key, domain-key, and Boyce-Codd normal forms. It also offers practical hints for normalization and denormalization. The book discusses different data types, such as the numeric, temporal and character data types; the different predicates; and the simple and advanced SELECT statements. In addition, the book presents virtual tables, and it discusses data partitions in queries; grouping operations; simple aggregate functions; and descriptive statistics, matrices and graphs in SQL. The book concludes with a discussion about optimizing SQL. It will be of great value to SQL programmers.

  • Expert advice from a noted SQL authority and award-winning columnist who has given ten years service to the ANSI SQL standards committee
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL 92 or SQL 2008 environment
  • Offers tips for working around deficiencies and gives insight into real-world challenges

Detalles del producto

  • Formato: Versión Kindle
  • Tamaño del archivo: 2879 KB
  • Longitud de impresión: 817
  • Números de página - ISBN de origen: 0123820227
  • Editor: Morgan Kaufmann; Edición: 4 (22 de noviembre de 2010)
  • Vendido por: Amazon Media EU S.à r.l.
  • Idioma: Inglés
  • ASIN: B0050P497U
  • Texto a voz: Activado
  • X-Ray:
  • Word Wise: No activado
  • Tipografía mejorada: No activado
  • Valoración media de los clientes: Sé el primero en opinar sobre este producto
  • Clasificación en los más vendidos de Amazon: n.° 678.997 de Pago en Tienda Kindle (Ver el Top 100 de pago en Tienda Kindle)
  • ¿Quieres informarnos sobre un precio más bajo?

Opiniones de clientes

Todavía no hay opiniones de clientes en
5 estrellas
4 estrellas
3 estrellas
2 estrellas
1 estrella

Opiniones de clientes más útiles en (beta) (Puede incluir opiniones del Programa de Recompensas de Opiniones Iniciales) 4.0 de un máximo de 5 estrellas 22 opiniones
2 de 2 personas piensan que la opinión es útil
4.0 de un máximo de 5 estrellas Most definitely not for beginners 9 de mayo de 2014
Por Dog's Boy on the Sunny Southern OR Coast - Publicado en
Formato: Tapa blanda Compra verificada
The author spends a few pages early on whining about being dinged in reviews for earlier editions by people expecting a book more oriented toward those learning SQL. This is most definitely not that book.

In fact, you'd best be pretty familiar with the terminology of SQL, of data bases, and ideally somewhat familiar with competing dialects of SQL implementations. Until you are -- and you will be by the end of the book -- it can be hard to understand what he is communicating. He takes no prisoners.

Having plowed thru the book, I was a worthwhile purchase and did give me a few immediately useful tips I was able to use. (E.g., in addition to inclusion criteria in a WHERE statement, you can also include redundant exclusion criteria. Doing so sped up procession of a series of time consuming commands from a half hour to a few minutes.) And I better appreciate the many & complex ways SELECT statements can be configured and assembled.

Most of the book looks a specific problems or types of problems, and the methodologies to address them. From the pattern of approach you will learn to build your own solutions to your own problems. But again, the book is not intended as a tutorial on basic or even intermediate SQL. It is not a tutorial at all save for a study on each of a variety of common problems DBAs face.
5 de 5 personas piensan que la opinión es útil
3.0 de un máximo de 5 estrellas Great Content Horribly Written 9 de agosto de 2013
Por Robert - Publicado en
Formato: Versión Kindle Compra verificada
This book has some fantastic information in it on how to properly write SQL code, especially from the perspective of a programmer in a structured language. The major glaring problem with the book is its editing. There are typos everywhere, many of them in code examples, which breaks them. Additionally large portions of the text are copied from chapter to chapter, probably making up 5% of the book. This seems lazy and also makes the book more confusing as you get a nagging feeling of deja vu. With a good editor this book might be worth 5 stars. As it is the book is only 3, causing a lot of confusion and problems where there shouldn't be any.
2.0 de un máximo de 5 estrellas Not quite what the title suggests... 18 de abril de 2015
Por bookworm - Publicado en
Formato: Versión Kindle Compra verificada
In short, a dissapointment. There is way too much repetition, sometimes entire sections are repeated multiple times, way too much basics, and not enough advanced material too call this book "Advanced SQL Programming". I would classify essentially all but the last four or five chapters as a run through of basic SQL syntax and its constructs. Moreover, the type setting errors are annoying, for instance "*" being shown as ")" throughout.

For those looking for (most of) the "advanced" stuff in this book I would rather recommend "Transact-SQL Cookbook" by Aleš Spetic and Jonathan Gennick. The T-SQL in that book is as easy to translate to other dialects as Celkos ISO-standard SQL.
5.0 de un máximo de 5 estrellas highly recommended 3 de enero de 2013
Por jim - Publicado en
Formato: Tapa blanda Compra verificada
This is the second copy of this book I've bought after seeing one of our really smart DBAs copy. Excellent examples from a variety of types of queries and god textual annotation to back them up. You will want a copy on your shelf if you write any SQL queries beyond 'select * from my_table'
4.0 de un máximo de 5 estrellas Looks great, also looking at the SQL Cookbook. 24 de octubre de 2013
Por R. N. Smith - Publicado en
Formato: Tapa blanda Compra verificada
This one on first glance seems to be more technical than show-me-how with the Cookbook. Too soon to say yet.
click to open popover