Synopsis
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.
Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.
À propos de l?auteur
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.
Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.
Autres éditions populaires du même titre
Résultats de recherche pour SQL and Relational Theory: How to Write Accurate SQL...
Image d'archives
SQL and Relational Theory: How to Write Accurate SQL Code
Edité par
O'Reilly Media (edition 3), 2015
ISBN 10 : 1491941170
ISBN 13 : 9781491941171
Ancien ou d'occasion
Paperback
Vendeur : BooksRun, Philadelphia, PA, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : 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. N° de réf. du vendeur 1491941170-11-1
Acheter D'occasion
EUR 16,06
Frais de port :
Gratuit
Vers Etats-Unis
Quantité disponible : 1 disponible(s)
Image fournie par le vendeur
SQL and Relational Theory: How to Write Accurate SQL Code
Edité par
O'Reilly Media, 2015
ISBN 10 : 1491941170
ISBN 13 : 9781491941171
Ancien ou d'occasion
Couverture souple
Vendeur : -OnTimeBooks-, Phoenix, AZ, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : 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. N° de réf. du vendeur OTV.1491941170.G
Acheter D'occasion
EUR 17,40
Frais de port :
Gratuit
Vers Etats-Unis
Quantité disponible : 1 disponible(s)
Image fournie par le vendeur
SQL and Relational Theory: How to Write Accurate SQL Code
Edité par
O'Reilly Media, 2015
ISBN 10 : 1491941170
ISBN 13 : 9781491941171
Ancien ou d'occasion
Couverture souple
Vendeur : Coas Books, Las Cruces, NM, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : acceptable. Item has staining. Cover is worn. Paperback. 3rd Edition. N° de réf. du vendeur 55GSJ1001ENO_ns
Acheter D'occasion
EUR 14,64
Frais de port :
EUR 3,45
Vers Etats-Unis
Quantité disponible : 1 disponible(s)
Image fournie par le vendeur
SQL and Relational Theory : How to Write Accurate SQL Code
Edité par
O'Reilly Media, 2015
ISBN 10 : 1491941170
ISBN 13 : 9781491941171
Ancien ou d'occasion
Couverture souple
Vendeur : GreatBookPrices, Columbia, MD, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : As New. Unread book in perfect condition. N° de réf. du vendeur 24550040
Acheter D'occasion
EUR 31,35
Frais de port :
EUR 2,28
Vers Etats-Unis
Quantité disponible : 5 disponible(s)
Image d'archives
SQL and Relational Theory
Vendeur : PBShop.store UK, Fairford, GLOS, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
PAP. Etat : New. New Book. Shipped from UK. Established seller since 2000. N° de réf. du vendeur WO-9781491941171
Acheter neuf
EUR 31,08
Frais de port :
EUR 7,70
De Royaume-Uni vers Etats-Unis
Quantité disponible : 2 disponible(s)
Image fournie par le vendeur
SQL and Relational Theory : How to Write Accurate SQL Code
Vendeur : GreatBookPrices, Columbia, MD, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : New. N° de réf. du vendeur 24550040-n
Acheter neuf
EUR 37,59
Frais de port :
EUR 2,28
Vers Etats-Unis
Quantité disponible : 5 disponible(s)
Image d'archives
SQL and Relational Theory: How to Write Accurate SQL Code
Vendeur : Lucky's Textbooks, Dallas, TX, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : New. N° de réf. du vendeur ABLIING23Mar2716030177463
Acheter neuf
EUR 37,85
Frais de port :
EUR 3,45
Vers Etats-Unis
Quantité disponible : Plus de 20 disponibles
Image d'archives
SQL and Relational Theory: How to Write Accurate SQL Code
Vendeur : Best Price, Torrance, CA, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : New. SUPER FAST SHIPPING. N° de réf. du vendeur 9781491941171
Acheter neuf
EUR 33,82
Frais de port :
EUR 7,77
Vers Etats-Unis
Quantité disponible : 2 disponible(s)
Image fournie par le vendeur
SQL and Relational Theory, 3e
Vendeur : Rarewaves USA, OSWEGO, IL, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : 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. N° de réf. du vendeur LU-9781491941171
Acheter neuf
EUR 46,99
Frais de port :
Gratuit
Vers Etats-Unis
Quantité disponible : Plus de 20 disponibles
Image fournie par le vendeur
SQL and Relational Theory : How to Write Accurate SQL Code
Vendeur : GreatBookPricesUK, Woodford Green, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
Etat : New. N° de réf. du vendeur 24550040-n
Acheter neuf
EUR 31,07
Frais de port :
EUR 17,10
De Royaume-Uni vers Etats-Unis
Quantité disponible : 5 disponible(s)