On this page, you will find instructions for downloading the sample database used in the exercises and labs in Oracle SQL Interactive Workbook, 2nd Edition, as well as instructions for optionally installing additional example tables.

Sample Database

This self-extracting zip file contains the sample database files you will need to complete the exercises and labs. Take the following steps to download and extract the file:

1. Download the self-extracting scripts.exe to the C:\Temp folder on your machine.
2. Open Windows Explorer to C:\Temp and double click on scripts.exe.
3. The WinZip Self-Extractor will open. Click the Unzip button to extract the files to C:\guest\schemasetup. The folders C:\guest and C:\guest\schemasetup will be created for you automatically if you don't already have them.
4. Twenty-three (23) files will be unzipped in the C:\guest\schemasetup directory.
5. The readme.pdf in the c:\guest\schemasetup directory will provide instructions on how to install (viewing requires the Adobe Acrobat Reader). Please read the instructions carefully. Alternatively, you can also read the text-based version of the readme file called readme.txt.
6. Click the Close button to exit the WinZip Self-Extractor.
7. Return to the main page to complete the install.

You may also find it convenient to print the STUDENT Database Schema Diagram (requires the Adobe Acrobat Reader).

Additional Example Tables

If you want to optionally install the additional tables used for some of the examples in the book you can run an additional script.

If you downloaded the sample database you will automatically have two files named sql_book_add_tables.sql and drop_extra_tables.sql in your c:\guest\schemasetup directory. You may install these additional tables after you have created the STUDENT account. Instructions on how to create the additional files are found in the readme.pdf file under the header "4. Additional Example Table Installation Instructions."