Readme.txt

The resource files include two Visual Studio 2013 project folders, one sql file, and two txt files.

This readme.txt file is meant to be the first file that you read and use.  It provides an overview of the tip's resources.

There are 3 types of files in the folder along with two instructions from this Readme.txt file.

INSTRUCTION 1: The tip's script file expects a database named stocks_for_mining.  You can create this database manually or with a script (not provided).  Alternatively, you can alter the USE statement in the script file so it works with another database of your choice.

INSTRUCTION 2: The tips's script file expects a collection of csv files derived from the three source Google sheets referenced in the tip.  The script file expects these csv files in the C:\stocks_for_mining folder path.  Either create this folder and populate the folder with the csv files or change the script and use another folder that you prefer instead.  In any event, all the csv files that you need to reproduce the results described in the tip are in this zipped resource files folder.

The import_downloaded_data_into_SQL_Server.sql file contains the script for importing the csv files into SQL Server.

The data_quality_queries.sql file contains contains queries pertaining to data quality issues discussed within the tip.

The links_to_share_google_sheets.txt file contains three links to three Google Sheets discussed in the tip.  After opening them up, you can make copies of them and rename them in any way that you prefer for your personal testing of the tip.