This comprehensive textbook teaches the fundamentals of database design, modeling, systems, data storage, and the evolving world of data warehousing, governance and more. Written by experienced educators and experts in big data, analytics, data quality, and data integration, it provides an up to date approach to database management. This full color, illustrated text has a balanced theory practice focus, covering essential topics, from established database technologies to recent trends, like Big Data, NoSQL, and more. Fundamental concepts are supported by real world examples, query and code walkthroughs, and figures, making it perfect for introductory courses for advanced undergraduates and graduate students in information systems or computer science. These examples are further supported by an online playground with multiple learning environments, including MySQL, MongoDB, Neo4j Cypher, and tree structure visualization. This combined learning approach connects key concepts throughout the text to the important, practical tools to get started in database management.
We use this book to teach databases at our faculty - it also happens to be at the same university as the authors. I'm a bit torn on the book, as it is clear that a lot of thought and work went into this 600+ technical handbook. Yet, at the beginning, the authors claim this is geared towards both students (of course), and professionals to "brush up" on their DB/(No)SQL/whatever knowledge. Let's put this straight: as an academic textbook, it passes the test, because of the breath and nice mix between theory and practice. However, as a book for a practitioner to peek into, it fails miserably. The chapter on DB APIs talks about entity beans and JSPs, a technology that we as software devs abandoned in 2010, yet, in an academic 2018 book, it somehow is deemed relevant again. There is no mention of web-based noSQL dbs such as Pouch, nothing to mitigate JDBC's ugliness such as Jdbi, no JPA instead of JDO, no Redis, ... I get that you don't need to follow every latest trend, but come on, it's an expensive book from 2018. Furthermore, review question answers are absent. I just don't get why academics won't write something like this together with an industry expert... Instead, you're better off browsing the https://pragprog.com database section, such as "seven databases in seven weeks".