• code

    Setup Your Local Data Warehouse Content

    In last week’s post, I showed you how to get a free SQL database by setting up a MySQL database server on your desktop. Now, it’s time to finish setting up your local data warehouse that you can use it to practice your SQL chops. We will use data that is posted on data.world to fill out our data warehouse. The first dataset is from the WICHE organization and shows you student enrollments and graduations in K-12 schools. This is a dataset that I uploaded to data.world years ago and I use it in demos like this. We will also download a file with information on US states so we…

  • code

    Get this Free SQL Database

    For a long time, I’ve wanted to published guides to the programming languages that I use. Last week, I started by writing up quick notes on SQL but it occurred to me that you will need a SQL database to follow along. So I found a free SQL database system that you can download right now. Download MAMP The program that you need is called MAMP and you can download that here. Take care to download the correct version for your operating system. MAMP makes it easy to install these three open-source products: Apache, MySQL, and PHP. MySQL is the free SQL database, but you need all three working set…