B
The Example Tables
This appendix outlines the tables in this book and their use.
Writing SQL statements requires a good understanding of the underlying database design. If you don’t know what information is stored in what table, how tables are related to each other, and the actual breakdown of data within a row, it is impossible to write effective SQL.
You are strongly advised to actually try every example in every chapter in this book. All the chapters use a common set of data files. To assist you in better understanding the examples and to enable you to follow along with the chapters, this appendix describes the tables used, their relationships, and how to obtain them.
Understanding the Example Tables
The tables used throughout this book ...
Get MySQL Crash Course, 2nd 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.