SQL for Business: Setup

Software

SQL is a specialized programming language used with databases. We use a simple database manager called sqlite3 in python for this workshop.

We will use jupyter notebook to run python. If you have not installed jupyter notebooks, please follow the instructions to install. For both windows and Mac, the easiest way is to install ANACODA (recommend download and install the python 3.6 version). ANACODA will automatically install python, jupyter and few packages that are frequently used in data analytics to your computer. You can also choose to use python3 -m pip install jupyter command to install if you already have python in your computer.

After installing ANACODA or jupyter notebook,

Windows

Macs

Now you successfully have the notebook open!

Data

Download this data to your computer: soda.db and move it to sql_workshop folder created above.

About the data

The data for this lesson is a part of the Data Carpentry Business workshop. The original data for this lesson and the workshop are collected from the State of Iowa. It is open for public use, we have modified the data for the workshop.