Hour 5

Understanding the Basics of Relational (SQL) Database Design

What You’ll Learn in This Hour:

  • ▶   Database design’s relation to SQL

  • ▶   The general database design process

  • ▶   Basic design techniques with the BIRDS database

  • ▶   Database life cycle basics

In this hour, you learn the basics of designing a relational database. This is not by any means a database design book; however, you should understand not only the key elements of a relational database, but also what goes into design. This is because the design process is all about the data and the relationships with the data. The same is true when using SQL: The design process ties directly into how data is used. Here you learn the basics of design while reinforcing the foundation ...

Get SQL in 24 Hours, Sams Teach Yourself, 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial