Database: Bookbiz Database

Here are additional materials to use with The Practical SQL Handbook, 4th ed, by Judith S Bowman, Sandra L Emerson, and Marcy Darnovsky.

Table Relations and SQL

• Bookbiz Tables - Relationship diagram and SQL to create tables.

Exercises

The book lacks exercises. Here are some that you may find useful.

• Bookbiz Query Exercises - Ch 4
• Bookbiz Query Exercises - Ch 4-5
• Bookbiz Query Exercises - Ch 6 GROUP BY
• Bookbiz Query Exercises 2 - Ch 6 GROUP BY
• Bookbiz Query Exercises- Ch 7 Inner Join