You learn what related tables are and how to query them.
You revisit table and data management.
You explore how to learn more SQL on your own.
What you need to know
To understand the SQL covered in this chapter, you need to know what databases and tables are, as well as the basics of SQL queries. If not, you may start by reading chapter 1.
As you read this chapter, you will find more code snippets. If you want to execute those code snippets or see their variations for different RDMBS, you will need to check the GitHub repository that accompanies this book (https://github.com/Neo-Hao/grokking-relational-database-design). You can find the scripts for this chapter in the chapter_02 folder and follow the instructions in the README.md file to run the scripts.
For example, the easiest approach is to use SQLite Online:
Visit SQLite Online (https://sqliteonline.com). Choose your target RDBMS to use on the left side bar, and click Click to Connect.
Click Import to load the script corresponding to your chosen RDBMS (e.g., mysql_db.sql.sql from the downloaded or cloned GitHub repository for MariaDB).