Introducing the Sample Database

The bookbiz database is not a real-world database but simply a learning tool. Its primary purpose is to provide you with a small collection of interesting data to manipulate as you study SQL syntax and semantics.

The bookbiz database is about a fictitious publishing company that has three subsidiary publishing lines. The database stores information that editors, administrators, and executives might want about books, their authors, their editors, and the company's financial arrangements. This database can produce many kinds of reports summarizing current sales, comparing different book lines, discovering which editors work with which authors, and so on. In real life, the database would probably support many other ...

Get Practical SQL Handbook, The: Using SQL Variants, Fourth 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.