MultiCloud Classroom notes 28/Sep/2026

oracle rds

1. create oracle db and conncet form db visulizer
2. run below query
3. watch class room recording

CREATE USER myapp_user IDENTIFIED BY MyPassword123;

CREATE TABLE employees (
    emp_id      NUMBER PRIMARY KEY,
    first_name  VARCHAR2(50),
    last_name   VARCHAR2(50),
    email       VARCHAR2(100),
    hire_date   DATE,
    salary      NUMBER(10,2)
);

SELECT table_name FROM user_tables WHERE table_name = 'EMPLOYEES';

INSERT INTO employees (emp_id, first_name, last_name, email, hire_date, salary)
VALUES (1, 'John', 'Doe', 'john.doe@example.com', TO_DATE('2023-01-15','YYYY-MM-DD'), 55000);

INSERT INTO employees (emp_id, first_name, last_name, email, hire_date, salary)
VALUES (2, 'Jane', 'Smith', 'jane.smith@example.com', TO_DATE('2023-03-10','YYYY-MM-DD'), 62000);

INSERT INTO employees (emp_id, first_name, last_name, email, hire_date, salary)
VALUES (3, 'Mike', 'Johnson', 'mike.johnson@example.com', TO_DATE('2023-06-01','YYYY-MM-DD'), 58000);

COMMIT;

SELECT * FROM employees;

Aurora MySql & Multi-az 3 instance deployment

1. create databases and run below sample sql querry

# 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');

INSERT INTO students (name, course, enrolled_date) VALUES
('Alice Johnson1', 'DevOps1 Fundamentals', '2026-01-10'),
('Bob Smith1', 'AWS Cloud1 Practitioner', '2026-02-15'),
('ram Smith1', 'AWS Cloud1 Practitioner', '2026-02-16'),
('Charlie1 Lee', 'Docker1 & Kubernetes', '2026-03-05');

# verify data in table 
USE classroom_db;
SELECT * FROM students;

Task

1. create Aurora mysql enable public and test both endpoints rw/ro
2. create pravite multi-az mysql and connect via ec2 bastion host