Lesson 1
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-trainingDocker�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
-
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.