Mysqlon Docker OnPremise AWSCloud

A 3-in-1 Course to learn Docker / Mysql on Docker / Mysql on Docker in AWS Cloud
Mysqlon Docker OnPremise AWSCloud
File Size :
1.63 GB
Total length :
5h 3m



Kshitij Joy (Udemy Instructor Partner / Oracle ACE Pro)


Last update




Mysqlon Docker OnPremise AWSCloud

What you’ll 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

Mysqlon Docker OnPremise AWSCloud


Knowledge of Databases (Mysql / Oracle)


This is a 3-in-1 course designed for the students who wish to learn the Basics of Docker , How Mysql Databases work on Docker On-Prem & AWS Cloud.Docker Introduction We shall begin with the Basics : What is Docker , What are Containers as the concept of Docker revolves around Containers. We shall then looks and compare Docker with Virtual Machines. An understanding will be given to the students about the benefits of Docker and some interesting Facts.Docker Architecture : Deep Dive & DemosMy belief is when learning a new technology it’s always good to understand the Architecture and hence we shall do a deep dive into the architecture of Docker, We will understand the basic terminlogies like What is a Docker Image/Container/ Registry/Engine and this will equip us to understand the technology and get a good grasp of the subject.The demos for installation of Docker on MacOs will be done and we will also perform loads of demos to run and understand the Basic Docker Commands.Mysql Database on Docker We shall then move our focus to Mysql Databases on Docker and get an understanding around the official images for Mysql community edition that are available from Docker & Oracle. We will do demos to install these and look at differences.We shall try and understand the importance of tags and how you can install multiple versions of mysql. I will also show how you can connect mysql database in a container using CLI & Mysql workbench. We will focus on Industry standards for creating Docker containers using the Docker Compose with Demos. We will also look at practical methods of creating your own custom image / pusing that image to Docker Hub / Pulling the same image and create a new container from the image.An in-depth understanding will be given on Data Persistence in Docker and how we can create Mysql Database using Docker Volumes. As any discussion on Databases will be incomplete without Backups/Recovery hence we shall take a look at Backup/Recovery of Mysql Databases in Docker.Mysql Database on Docker in AWS CloudWe shall use the above understanding and use it in the world of AWS Cloud. For this we will work on our custom Architecture where in we will create our own VPC (Virtual Private Cloud)  and this VPC will have 2 Subnets: A Public Subnet for Webserver and a Private Subnet for the Database Server (Mysql).  I will do practical demos and give you good understanding on the Security Groups and how you can create Security Groups for Webserver and DB Sever, please note that as Database Server is in private Subnet no one from outside world can access it directly and only the Webserver will be able to talk to Database Server.At the same time the Database Server needs to have internet connectivity as we need to install Docker there , how this can be achieved will be mentioned as well.Some more practical demos will be done showing the students how we can build EC2 Machines in AWS Cloud , one which will be used for Webserver and other for the Database Server. We will also install PHP 7.2 along with Apache Webserver at the Front End , and for the Backend we we will have Mysql Database running inside Docker on AWS Cloud. At the end we will write a PHP Code and which will make a connection from PHP to Mysql Database on Docker in AWS Cloud and will extract and display the database from Mysql Tables.Happy LearningDB Alchemist Academy


Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What will you Learn from the Course

Section 2: Introduction to Docker

Lecture 3 Introduction to Docker

Lecture 4 What is Docker ?

Lecture 5 What are Containers ?

Lecture 6 Containers Vs Virtual Machines

Lecture 7 Benefits of Docker

Lecture 8 Interesting Facts About Docker

Section 3: Docker Architecture & Important Commands

Lecture 9 Installation , Docker Architecture & Important Commands

Lecture 10 What is Docker on MacOs

Lecture 11 Installation of Docker on MacOS

Lecture 12 Demo: Magic Behind the Scenes

Lecture 13 Docker Architecture

Lecture 14 What is a Docker Daemon ?

Lecture 15 What is a Docker Client ?

Lecture 16 What is Docker Registry ?

Lecture 17 What is Docker Engine ?

Lecture 18 What is a Docker Image ?

Lecture 19 What are Docker Containers ?

Lecture 20 Important Docker Commands

Lecture 21 Demo: Docker Commands : Part I (Intro)

Lecture 22 Demo: Docker Commands : Part II

Lecture 23 Demo : Docker Commands : Part III

Section 4: Mysql onDocker : On-Prem

Lecture 24 Introduction to Mysql on Docker

Lecture 25 Mysql Editions on Docker

Lecture 26 Demo: Configure MySql Official Docker Image

Lecture 27 Demo: Configure Mysql Oracle Image

Lecture 28 Install Multiple Versions of Mysql

Lecture 29 Demo: Install Multiple Versions of Mysql

Lecture 30 How to Connect to Mysql Container

Lecture 31 Demo: Connect to Mysql Container Using Command Line & MySql Workbench

Lecture 32 What is Docker Compose ?

Lecture 33 Demo: How to Use Docker Compose

Lecture 34 How to Create Custom Docker Image ?

Lecture 35 Demo: Creating a Custom Docker Image

Lecture 36 Push Custom Image to Docker Hub

Lecture 37 Pull the same Custom Image from Docker Hub

Lecture 38 What is Data Persistence in Docker ?

Lecture 39 What are Docker Volumes ?

Lecture 40 Demo: Mysql Database on Docker Volumes using Docker run

Lecture 41 Demo: Mysql Database on Volumes using Docker Compose

Lecture 42 Backup/Restore Mysql on Docker

Lecture 43 Demo: Backup/Restore for Mysql on Docker

Lecture 44 Subscribe to Our YouTube Channel

Lecture 45 A 10 Second Survey

Section 5: Mysql on Docker in AWS Cloud

Lecture 46 Mysql on Docker in AWS Cloud !!!

Lecture 47 Introduction to Docker in AWS

Lecture 48 What are AWS Instance Types ?

Lecture 49 What is a VPC ?

Lecture 50 Understand a Simple VPC

Lecture 51 Demo: Create an Elastic IP

Lecture 52 Demo: Create a Custom VPC

Lecture 53 What is a Security Group ?

Lecture 54 Demo: Create a Security Group for Webserver & Database Server

Lecture 55 Demo: Create a Webserver EC2 Instance

Lecture 56 Demo: Create a Database Server EC2 Instance

Lecture 57 Demo: Connectivity tests to Webserver & DBServer|

Lecture 58 Demo: Install Docker on AWS

Lecture 59 Demo: Install PHP 7.2 on Webserver

Lecture 60 Demo: Configure Mysql Container in AWS

Lecture 61 Demo: PHP to Mysql Connectivity, Extract & Display the Query Results

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

Course Information:

Udemy | English | 5h 3m | 1.63 GB
Created by: Kshitij Joy (Udemy Instructor Partner / Oracle ACE Pro)

You Can See More Courses in the IT & Software >> Greetings from

New Courses

Scroll to Top