Appendix A. Creating the Sample Database
Most of the examples in this book use the sample database books; see “The Sample Database” in Chapter 2. To follow along with the examples, you'll need to create books in your DBMS.
This appendix describes how to create books, build its tables, and populate those tables with data. All the files that you'll need are available for download at this book's companion web site, www.peachpit.com/vqs/sql2. The files are compressed into a single Zip archive. To expand this file, use a decompression utility such as WinZip (Windows; www.winzip.com), StuffIt (Mac OS; www.stuffit.com), or gunzip or unzip (Unix). After decompression, read the file readme.txt for a description of the distribution.
Creating the Sample Database ...
Get SQL: Visual Quickstart Guide, Second 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.
