Companion page for Data Analysis Using SQL and Excel

by Gordon S. Linoff. 2007 John Wiley & Sons.

To order Data Analysis Using SQL and Excel from Amazon click here .

What This Page Contains

This page is a companion page for the book Data Analysis Using SQL and Excel. It provides the data sets and scripts for loading the data sets, and Excel files associated with the book. The information on this page is deemed accurate, but we are not responsible for errors and omissions.

Data

The data files are provided as compressed text files with scripts for the following databases:

Microsoft SQL Server (free/trial download available at SQL Server download )
MySQL (free/trial download available at MySQL download )
SAS (free/trial download not available)

In addition, SAS files are provided as a compressed library.

The queries in the book have been tested on Oracle (free/trial download available at Oracle download ), although load scripts are not yet available. The queries have not been validated on other databases, such as PostgreSQL (free/trial download available at PostgreSQL download ).

Instructions for Downloading and Installing

Download the text files.
Download the appropriate script for your environment.
Follow the instructions inside the script.

Scripts and Datasets

In many browsers, right clicking on a file link will bring up a menu with a download, save target as or save to disk option. If your browser cannot handle these links, you may also obtain the files via anonymous ftp from ftp.data-miners.com using an ftp tool or the ftp command line interface.

mysql.sql. Script for loading data into a mysql database.

sql-server.sql. Script for loading data into a Microsoft SQL Server database.

sas-script.sas. Script for loading data into SAS datasets.

textfiles.zip. The data files.

saslib.zip.