March 2025
Beginner
280 pages
6h 5m
English
Overview
A friendly illustrated guide to designing and implementing your first database.
Grokking Relational Database Design makes the principles of designing relational databases approachable and engaging. Everything in this book is reinforced by hands-on exercises and examples.
In Grokking Relational Database Design, you’ll learn how to:
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.
About the Technology
Almost every business uses a relational database system. Whether you’re a software developer, an analyst creating reports and dashboards, or a business user just trying to pull the latest numbers, it pays to understand how a relational database operates. This friendly, easy-to-follow book guides you from square one through the basics of relational database design.
About the Book
Grokking Relational Database Design introduces the core skills you need to assemble and query tables using SQL. The clear explanations, intuitive illustrations, and hands-on projects make database theory come to life, even if you can’t tell a primary key from an inner join. As you go, you’ll design, implement, and optimize a database for an e-commerce application and explore how generative AI simplifies the mundane tasks of database designs.
What's Inside
About the Reader
For self-taught programmers, software engineers, data scientists, and business data users. No previous experience with relational databases assumed.
About the Authors
Dr. Qiang Hao and Dr. Michail Tsikerdekis are both professors of Computer Science at Western Washington University.
Quotes
If anyone is looking to improve their database design skills, they can’t go wrong with this book.
- Ben Brumm, DatabaseStar
Goes beyond SQL syntax and explores the core principles. An invaluable resource!
- William Jamir Silva, Adjust
Relational database design is best done right the first time. This book is a great help to achieve that!
- Maxim Volgin, KLM
Provides necessary notions to design and build databases that can stand the data challenges we face.
- Orlando Méndez, Experian
Grokking Relational Database Design makes the principles of designing relational databases approachable and engaging. Everything in this book is reinforced by hands-on exercises and examples.
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
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.
About the Technology
Almost every business uses a relational database system. Whether you’re a software developer, an analyst creating reports and dashboards, or a business user just trying to pull the latest numbers, it pays to understand how a relational database operates. This friendly, easy-to-follow book guides you from square one through the basics of relational database design.
About the Book
Grokking Relational Database Design introduces the core skills you need to assemble and query tables using SQL. The clear explanations, intuitive illustrations, and hands-on projects make database theory come to life, even if you can’t tell a primary key from an inner join. As you go, you’ll design, implement, and optimize a database for an e-commerce application and explore how generative AI simplifies the mundane tasks of database designs.
What's Inside
- Define entities and their relationships
- Minimize anomalies and redundancy
- Use SQL to implement your designs
- Security, scalability, and performance
About the Reader
For self-taught programmers, software engineers, data scientists, and business data users. No previous experience with relational databases assumed.
About the Authors
Dr. Qiang Hao and Dr. Michail Tsikerdekis are both professors of Computer Science at Western Washington University.
Quotes
If anyone is looking to improve their database design skills, they can’t go wrong with this book.
- Ben Brumm, DatabaseStar
Goes beyond SQL syntax and explores the core principles. An invaluable resource!
- William Jamir Silva, Adjust
Relational database design is best done right the first time. This book is a great help to achieve that!
- Maxim Volgin, KLM
Provides necessary notions to design and build databases that can stand the data challenges we face.
- Orlando Méndez, Experian
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.