Sinossi
SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put that theory into practice. In this book, Chris Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it to your use of SQL.
This third edition has been revised, extended, and improved throughout. Topics whose treatment has been expanded include data types and domains, table comparisons, image relations, aggregate operators and summarization, view updating, and subqueries. A special feature of this edition is a new appendix on NoSQL and relational theory.
- Could you write an SQL query to find employees who have worked at least once in every programming department in the company? And be sure it's correct?
- Why is proper column naming so important?
- Nulls in the database cause wrong answers. Why? What you can do about it?
- How can image relations help you formulate complex SQL queries?
- SQL supports "quantified comparisons," but they're better avoided. Why? And how?
Database theory and practice have evolved considerably since Codd first defined the relational model, back in 1969. This book draws on decades of experience to present the most up to date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL can benefit from the insights it contains. The book is product independent.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Informazioni sull?autore
C.J. Date has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience.
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Altre edizioni note dello stesso titolo
Risultati della ricerca per SQL and Relational Theory, 3e
Immagini fornite dal venditore
SQL and Relational Theory: How to Write Accurate SQL Code
Da: -OnTimeBooks-, Phoenix, AZ, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: good. A copy that has been read, remains in good condition. All pages are intact, and the cover is intact. The spine and cover show signs of wear. Pages can include notes and highlighting and show signs of wear, and the copy can include "From the library of" labels or previous owner inscriptions. 100% GUARANTEE! Shipped with delivery confirmation, if you're not satisfied with purchase please return item for full refund. Ships via media mail. Codice articolo OTV.1491941170.G
Compra usato
EUR 16,39
Spese di spedizione:
GRATIS
In U.S.A.
Quantità: 1 disponibili
Foto dell'editore
SQL and Relational Theory: How to Write Accurate SQL Code
Editore:
O'Reilly Media (edition 3), 2015
ISBN 10: 1491941170
ISBN 13: 9781491941171
Antico o usato
Paperback
Da: BooksRun, Philadelphia, PA, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Good. 3. It's a preowned item in good condition and includes all the pages. It may have some general signs of wear and tear, such as markings, highlighting, slight damage to the cover, minimal wear to the binding, etc., but they will not affect the overall reading experience. Codice articolo 1491941170-11-1
Compra usato
EUR 17,68
Spese di spedizione:
GRATIS
In U.S.A.
Quantità: 1 disponibili
Foto dell'editore
SQL and Relational Theory: How to Write Accurate SQL Code
Da: Coas Books, Las Cruces, NM, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: Acceptable. Item has staining. Cover is worn. Paperback. 3rd Edition. Codice articolo 55GSJ1001ENO_ns
Compra usato
EUR 16,29
Spese di spedizione:
EUR 3,44
In U.S.A.
Quantità: 1 disponibili
Foto dell'editore
SQL and Relational Theory, 3e
Da: PBShop.store UK, Fairford, GLOS, Regno Unito
Valutazione del venditore 5 su 5 stelle
PAP. Condizione: New. New Book. Shipped from UK. Established seller since 2000. Codice articolo WO-9781491941171
Compra nuovo
EUR 31,01
Spese di spedizione:
EUR 7,69
Da: Regno Unito a: U.S.A.
Quantità: 1 disponibili
Immagini fornite dal venditore
SQL and Relational Theory : How to Write Accurate SQL Code
Da: GreatBookPrices, Columbia, MD, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: New. Codice articolo 24550040-n
Compra nuovo
EUR 37,77
Spese di spedizione:
EUR 2,28
In U.S.A.
Quantità: 5 disponibili
Foto dell'editore
SQL and Relational Theory: How to Write Accurate SQL Code
Da: Lucky's Textbooks, Dallas, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: New. Codice articolo ABLIING23Mar2716030177463
Compra nuovo
EUR 37,70
Spese di spedizione:
EUR 3,44
In U.S.A.
Quantità: Più di 20 disponibili
Foto dell'editore
SQL and Relational Theory: How to Write Accurate SQL Code
Da: California Books, Miami, FL, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: New. Codice articolo I-9781491941171
Compra nuovo
EUR 42,61
Spese di spedizione:
GRATIS
In U.S.A.
Quantità: Più di 20 disponibili
Immagini fornite dal venditore
SQL and Relational Theory : How to Write Accurate SQL Code
Da: GreatBookPrices, Columbia, MD, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: As New. Unread book in perfect condition. Codice articolo 24550040
Compra usato
EUR 43,21
Spese di spedizione:
EUR 2,28
In U.S.A.
Quantità: 5 disponibili
Immagini fornite dal venditore
SQL and Relational Theory, 3e
Da: Rarewaves USA, OSWEGO, IL, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: New. SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put that theory into practice. In this book, Chris Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it to your use of SQL. This third edition has been revised, extended, and improved throughout. Topics whose treatment has been expanded include data types and domains, table comparisons, image relations, aggregate operators and summarization, view updating, and subqueries. A special feature of this edition is a new appendix on NoSQL and relational theory. Could you write an SQL query to find employees who have worked at least once in every programming department in the company? And be sure it's correct? Why is proper column naming so important? Nulls in the database cause wrong answers. Why? What you can do about it? How can image relations help you formulate complex SQL queries? SQL supports "quantified comparisons," but they're better avoided. Why? And how? Database theory and practice have evolved considerably since Codd first defined the relational model, back in 1969.This book draws on decades of experience to present the most up to date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL can benefit from the insights it contains. The book is product independent. Codice articolo LU-9781491941171
Compra nuovo
EUR 46,81
Spese di spedizione:
GRATIS
In U.S.A.
Quantità: Più di 20 disponibili
Immagini fornite dal venditore
SQL and Relational Theory : How to Write Accurate SQL Code
Da: GreatBookPricesUK, Woodford Green, Regno Unito
Valutazione del venditore 5 su 5 stelle
Condizione: New. Codice articolo 24550040-n
Compra nuovo
EUR 31,00
Spese di spedizione:
EUR 17,06
Da: Regno Unito a: U.S.A.
Quantità: 5 disponibili