Mysql on Docker : On-Premise & AWS Cloud

A 3-in-1 Course to learn Docker / Mysql on Docker / Mysql on Docker in AWS Cloud

Created by: Kshitij Joy (Cloud Alchemy)
Oracle Certified Master(OCM) & Oracle Cloud Architect

What Will I Learn?

• What is Docker ?
• What are Containers ?
• Containers Vs Virtual Machines
• Benefits of Docker
• Installation of Docker on MacOs/Linux
• Magic: How Docker works on Mac
• Docker Architecture: Deep Dive (What is Docker Registry/Daemon/Client/Image/Container/Engine ?)
• Demos on Docker Commands
• Explanation of Mysql Community Edition
• Demo: Install Official Docker Images & Oracle Image for Mysql
• Demo: Install multiple versions of mysql
• Demo: Connect to Mysql Container database using CLI & Mysql workbench
• Understand Docker Compose with Demos
• Demo: How to Create a Custom Docker Image
• Demo: Push Image to Docker Hub
• What is Data Persistence in Docker
• Demo: Mysql container using Volume
• Demo: Backup / Recovery of Mysql Container database
• Introduction to Docker in AWS
• What is AWS VPC ?
• Demo: Create a Custom VPC
• What is a Security Group ?
• Demos: Create a Security Group for Webserver & DBServer
• Understand the Sample Architecture : Webserver to Database Server
• Demo: Build an EC2 Instance for Webserver & DBServer in Custom VPC
• Demo: Install Docker on EC2 Machine in AWS Cloud
• Demo: Installation of PHP 7.2 on Webserver
• Demo: Create Mysql container database on AWS
• Demo: Write a PHP Code to connect to Mysql Database (Docker on AWS) & Display Resultset

Requirements

• Knowledge of Databases (Mysql / Oracle)

Target audience

• Students who want to learn Docker & Mysql in Docker On-Premises & AWS Cloud