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 runningconda update pandas
- MySQL Sample Database
git clone https://github.com/datacharmer/test_db.git . mysql < employees.sql
- MySQL WorkBench
-
MySQL Community Edition is a freely downloadable version of MySQL Server. It is an open-source software provided under the GPL License. This link provides access to the different MySQL Community Edition installers.
-
MySQL Workbench is available for Windows, Linux, and OS X.This link explains the installation process for each of these platforms.
-
Docker Community Edition is available on many platforms, from desktop to cloud to server. This link provides additional information about how to install Docker to your OS.