MultiCloud Classroom notes 27/Sep/2026

aws RDS & Aurora

• Expree configure: serverless database
• full configure: managed database
• Restore from s3: restore database from s3 (create db from backup or snapshort)

Engine options

• mysql
• mssql
• oracle
• postgressSQl
• IBMdb2
• Aurora mysql /Aurora postgressSQL
• MariaDB

create mysql db and install mysql workbench or DbVisualizer

Watch class recording and create db

Download: https://www.dbvis.com/ choco install mysql.workbench -y

Task:

1. create mysql and connect from mysql workbench/ DbVisualizer
2. Follow below sql query:

# Create database
CREATE DATABASE classroom_db;
USE classroom_db;

# create table on above database
CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    course VARCHAR(100),
    enrolled_date DATE
);

# Inset data in table
INSERT INTO students (name, course, enrolled_date) VALUES
('Alice Johnson', 'DevOps Fundamentals', '2026-01-10'),
('Bob Smith', 'AWS Cloud Practitioner', '2026-02-15'),
('ram Smith', 'AWS Cloud Practitioner', '2026-02-16'),
('Charlie Lee', 'Docker & Kubernetes', '2026-03-05');

# verify data in table 
SELECT * FROM students;

Next class will dicuss oracle db and multi-az deployment