Introduction to Structured Query Language (SQL)

Getting your environment ready – SQL

ADACS-Training Docker Image

The container is based on Ubuntu 16.04. It contains the following software modules:

  • MySQL Server + Employees Sample Database
  • git
  • OpenMPI
  • Anaconda2 (4.2.0)
  • Emacs

Docker is a virtualization mechanism to package your application into a standardised unit. To install Docker on your machine follow these instructions. More details about Docker can be found on “Get started with Docker”

To start an ADACS-Training container, write the following command in your terminal :

docker run -p 3306:3306 -p 8888:8888 -it caseresearch/adacs-training

This will download all the necessary software and start a new Docker for you. After this step, you have a fully functional Docker container with ports 3306 ( for MySQL) and port 8888 ( for ipython) exposed to your machine.

A nice docker cheat sheet can be found here.

Other Tools Required

Within the workshop, you will need to have the following tools in addition to the Docker container.

  • MySQL WorkBench

If you prefer to use your PC/laptop without Docker

If you decided not to use Docker, you should install the following software modules on your local machine.

  • git
  • MySQL Server
  • MySQL WorkBench
  • Python 2.7 or Anaconda (Python 2.7)
    Please ensure that you have the latest pandas package by running

    conda update pandas
  • MySQL Sample Database
    
    git clone https://github.com/datacharmer/test_db.git .
    mysql < employees.sql
  • MySQL WorkBench

 

WordPress Theme built by Shufflehound.

Copyright © Astronomy Data and Compute Services

ADACS is delivered jointly by Swinburne University of Technology and Curtin University. ADACS is funded under Astronomy National Collaborative Research Infrastructure Strategy (NCRIS) Program via Astronomy Australia Ltd (AAL).