Database Management Systems provides comprehensive and up-to-date coverage of the fundamentals of database systems. Coherent explanations and practical examples have made this one of the leading texts in the field. The third edition continues in this tradition, enhancing it with more practical material. The new edition has been reorganized to allow more flexibility in the way the course is taught. Now, instructors can easily choose whether they would like to teach a course which emphasizes database application development or a course that emphasizes database systems issues. New overview chapters at the beginning of parts make it possible to skip other chapters in the part if you don't want the detail. More applications and examples have been added throughout the book, including SQL and Oracle examples. The applied flavor is further enhanced by the two new database applications chapters.
I never thought I'd enjoy learned about databases so much, let alone from a 900-page book. My only criticism is that the acronyms and abbreviations Ramakrishnan uses often usually hurt more than they help. BCNF, FD, IC? Sure, whatever. But expecting me to decrypt "SNLRWH" into the schema "sailor_id, name, ..."--actually I can't remember what "LNRWH" were supposed to be. Nor can I find where it was originally defined. Definitely made it hard to read.
This book is top notch. I read this book line by line with full pleasure and as someone who has skimmed through several books in this field, I'd recommend it to anyone who wants to learn design databases of various software projects through a self-paced, well-explained, non-boring, full-of-useful-examples and precise approach (from the requirements, on to the conceptual design, to the logical design, to the refinement, the physical implementation and the security of your data), this book should definitely be a serious one on your go-to list. Specially the second chapter which goes through drawing Entity Relationship (ER) diagrams, that are part of the conceptual design step -the most important step in modeling your data- is written amazingly. A 5 star undoubtedly.
This book is aimed to be a companion to undergraduate courses teachers the fundamentals of relational database management. It is dry, very complete and explicit. It offers tons of examples to practice on and its explanations are concrete and clear. I would not recommend this book to someone simply aiming to learn about databases and how to use them properly, the book delves into relational algebra a lot, which is a concept that I believe has more of an academic use than any real world use in industry. It does teach quite a lot about database and query optimization, although again, you could probably learn about it somewhere else on the internet for free.
As a theoretical book it is good to understand how an SGBD works and how to think in the relational model paradigm. However it does not teach how to work with a DBMS in specific not being a recommended book to learn how to work with postgres or mysql.
It fails on the fact that it does not teach the ER model.
Tough one for me. My professor in a graduate course made this optional as a supplement to class lecture. We didn't often connect the topics and he often used different techniques to teach logical operations concept. I did work through many of the exercises in Chapter 5 diligently to practice lots of SQL - database content on supporting website was very useful.
A very standard textbook for classes in DBMS. A very typical one. But it's a very good book for people who wants to know about database in general with some details in it, of course.
The book corresponds to a bible, essentials and depth of how old and cores of modern RDBMS are designed. Most suitable as a textbook with any relational databases related course.