A friendly illustrated guide to designing and implementing your first database.
A well-constructed database is easy to understand, query, manage, and scale when your app needs to grow. In Grokking Relational Database Design you'll learn the basics of relational database design including how to name fields and tables, which data to store where, how to eliminate repetition, good practices for data collection and hygiene, and much more. You won't need a computer science degree or in-depth knowledge of programming—the book's practical examples and down-to-earth definitions are beginner-friendly.
In Grokking Relational Database Design, you'll learn how to:
- Query and create databases using Structured Query Language (SQL)
- Design databases from scratch
- Implement and optimize database designs
- Take advantage of generative AI when designing databases
Interested? You can watch one or two educational videos based on this book, or check out this book on Manning directly, and start reading now.
This book is publised by Manning Publications. The print, ebook, and audio versions are available on both Manning Publications and Amazon. There are 8 chapters in this book. The table of contents is as follows:
- Chapter 1 - Introduction to Database and SQL (code)
- Chapter 2 - Related Tables and More SQL (code)
- Chapter 3 - Overview of Database Design (No code)
- Chapter 4 - Entities and Attributes (code)
- Chapter 5 - Relationships (code)
- Chapter 6 - Normalization and Implementation (code)
- Chapter 7 - Security and Optimization (code)
- Chapter 8 - Database Design in the Age of Generative AI (code)
Qiang Hao (@structuredcs) and Michail Tsikerdekis (@tsikerdekis)