Principles of Database Management

The Practical Guide to Storing, Managing and Analyzing Big and Small Data

Authors: Wilfried Lemahieu, Bart Baesens, Seppe vanden Broucke
Publisher: Cambridge University Press

This book covers the principles of database management. It starts by defining databases and the various steps of database design. A next part zooms into different types of database systems: pre-relational, relational, object-oriented, XML and no-SQL databases. Subsequent chapters discuss transaction management and physical data storage aspects. Data access and data integration in an x-tier environment are also extensively covered. The book concludes by discussing data warehousing, big data, and analytics. Throughout the book, we will include various examples and case studies to illustrate and clarify the concepts discussed. Every chapter will conclude with a set of self-study questions such that the book can be easily used as a textbook by colleague instructors. We will also extensively report on both our research and industry experience on the topic to further illustrate the practical impact of the concepts discussed.

→ Read more information and access more resources over at www.pdbmbook.com!

Video courses

Playlist of all videos:

• Chapter 1: Fundamental Concepts of Database Management
• Chapter 2: Architecture and Classification of DBMS
• Chapter 3: Conceptual Data Modeling using EER and UML
• Chapter 4: Organizational Aspects of Data Management
• Chapter 5: Legacy Databases
• Chapter 6: Relational Databases
• Chapter 7: SQL
• Chapter 8: Object Oriented Databases and Object Persistence
• Chapter 9: Extended Relational Databases
• Chapter 10: XML Databases
• Chapter 11: NoSQL Databases
• Chapter 12: Physical File Organization and Indexing
• Chapter 13: Physical Database Organization
• Chapter 14: Basics of Transaction Management
• Chapter 15: Database APIs
• Chapter 16: Data Distribution and Distributed Transaction Management
• Chapter 17: Data warehousing and Business Intelligence
• Chapter 18: Data Integration, Data Quality and Data Governance
• Chapter 19: Big Data

Older videos

Playlist of older video series:

• Chapter 1: Fundamental Concepts of Database Management
• Chapter 2: Architecture and Classification of DBMSs
• Chapter 3: Data Models: hierarchical + CODASYL model, ER model, EER model, relational model
• Chapter 4: Database Design: part 1, part 2, part 3
• Chapter 5: Data Languages in a Relational Environment, part 1, part 2, part 3, part 4

Youtube playlist of old, archived courses.