Part 1. Get started

 

Welcome to the journey into relational database design! In this part, you’ll gain foundational skills in Structured Query Language (SQL) that are essential for designing efficient and effective databases. By mastering these basics, you’ll be prepared to tackle advanced database concepts with confidence. This part is the “laying the foundation before building the structure” phase. Whether you’re new to SQL or need a refresher, this section will guide you through the essentials.

Chapter 1 begins with the basics of SQL that you need for database design. Think of this chapter as your “Hello, World!” moment in database exploration; you’ll write your first SQL queries and begin interacting with data in meaningful ways.

Chapter 2 dives a bit deeper into SQL by focusing on expressing the relationships between tables. By the end, you’ll have everything you need to use SQL for database design.

Chapter 3 offers a bird’s-eye view of database design. You’ll explore the full process of good database design and what matters at each step.

Prepare your tool—a notepad, laptop, or database application—and settle into a focused space. Let’s dive into the exciting world of relational database design!