const learn = () => {};

function code() { }

if (passionate) { }

while (true) { }

for (let i = 0; i < ∞; i++)

import { skills } from "learning";

export default Developer;

async function master() {}

return success;

console.log("Hello World");

{ }

< >

[ ]

( )

...

Home/Courses/Database - MySQL & Mongo

Beginner

Data Science

Database - MySQL & Mongo

Data is the backbone of every modern application. Whether it's social media or business software, managing data effectively is a critical skill. This 2-month intensive course is designed to give you a complete 360-degree view of database management, covering both Relational (SQL) and Non-Relational (NoSQL) systems using Python.

8 weeks

Beginner Level

180,000 MMK

Enroll Now View Batches

if (Prerequisites) { }

✓ Python

Course Outline

Module 1

𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 & 𝐓𝐚𝐛𝐥𝐞

Create Database
Create Table
Drop Database
Drop Table
Alter Table

Module 2

𝐈𝐧𝐬𝐞r𝐭,𝐔𝐩𝐝𝐚𝐭𝐞 & 𝐃𝐞𝐥𝐞𝐭𝐞

Insert Into
Update
Select Into
Insert Into Select
Delete

Module 3

𝐒𝐞𝐥𝐞𝐜𝐭

All Columns
Specific Columns
Select Where
Select AS
Select Limit
Order By
Group By
Having Clause

Module 4

𝐎𝐩𝐞𝐫𝐚𝐭𝐨𝐫𝐬

Arithmetic
Comparison
Logical
String
Set
Null & Not Null
Aggregate Operators

Module 5

𝐂𝐨𝐧𝐬𝐭𝐫𝐚𝐢𝐧𝐭𝐬

Not Null
Unique
Primary Key
Foreign Key
Check
Default
Composite Key

Module 6

Joins

LEFT JOIN
RIGHT JOIN
INNER JOIN

Module 7

𝐏𝐲𝐭𝐡𝐨𝐧

Set Up Python
Python DataTypes
Python Functions
Python OOP
Set Up Pycharm CE
Set Up MySQlConnector
Set Up Matplot for Visualizatio

Module 8

𝐌𝐲𝐒𝐐𝐋 & 𝐏𝐲𝐭𝐡𝐨𝐧 𝐏𝐫𝐨𝐣𝐞𝐜𝐭𝐬

Personal Expense Tracker
Smart Phone Store
Library Management System

Module 9

𝐍𝐨𝐒𝐐𝐋 - 𝐌𝐨𝐧𝐠𝐨 𝐃𝐁𝐌𝐒

𝐈𝐧𝐭𝐫𝐨𝐝𝐮𝐜𝐭𝐢𝐨𝐧
𝐒𝐞𝐭 𝐔𝐩 𝐌𝐨𝐧𝐠𝐨𝐃𝐁 𝐂𝐄
𝐖𝐨𝐫𝐤𝐢𝐧𝐠 𝐰𝐢𝐭𝐡 𝐌𝐨𝐧𝐠𝐨𝐃𝐁 𝐢𝐧 𝐏𝐲𝐭𝐡𝐨𝐧
Connecting to MongoDB
Insert Data
Querying Data
Updating Data
Deleting Data

Module 10

𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐌𝐨𝐧𝐠𝐨𝐃𝐁 𝐎𝐩𝐞𝐫𝐚𝐭𝐢𝐨𝐧𝐬

Indexing
Aggregation Framework

Module 11

𝐌𝐨𝐧𝐠𝐨𝐃𝐁 & 𝐏𝐲𝐭𝐡𝐨𝐧 𝐏𝐫𝐨𝐣𝐞𝐜𝐭𝐬

User Manager - JSON
Student Manager
Online Banking Project

Learning Outcomes

Understand the fundamental role and importance of databases in modern software development.
Differentiate between SQL (Relational) and NoSQL (Document-based) database architectures.
Master SQL syntax for database and table creation, modification, and deletion.
Execute complex data queries using specific columns, filters, limits, and ordering.
Implement database integrity using Primary Keys, Foreign Keys, and Unique constraints.
Perform advanced SQL operations using Arithmetic, Logical, and Aggregate operators.
Establish secure connections between Python applications and MySQL databases.
Build real-world Python applications like Expense Trackers and Library Management Systems.
Master MongoDB operations to manage data in flexible JSON-style document formats.
Use the MongoDB Aggregation Framework for advanced data processing and indexing.
Create professional data visualizations using the Matplotlib library in Python.
Develop a full-scale Online Banking project integrating database logic with Python OOP.

Upcoming Batches

View All →

batch.config.ts/database

Database - Batch 4 {}

const course = "database"

days

Tue, Thurs

time

7 PM to 8:30 PM

start_date

5 May 2026

starts_in

-32 days

instructor

Wai Yan Htun - Founder

status

upcoming

> npm run enroll

Ready to Learn Database - MySQL & Mongo?

Join our next batch and start building real projects

Contact on Telegram Browse More Courses