Class Details
MySQL is a tool to store and manage data in tables — just like Excel but more powerful. It's used in websites and apps to save things like user info, orders, or messages.
Course Outline
Week 1: Introduction to Databases & MySQL
What is a database?
What is MySQL and where is it used?
Install MySQL & MySQL Workbench
Create your first database
Create tables (like student, course, etc.)
🔹 Week 2: Adding and Viewing Data
Insert records using INSERT
View data using SELECT
Filter data with WHERE
Use basic conditions: =, <, >, AND, OR, LIKE
🔹 Week 3: Updating & Deleting Data
Update records using UPDATE
Delete records using DELETE
Practice CRUD operations (Create, Read, Update, Delete)
Sort data using ORDER BY
Limit results using LIMIT
🔹 Week 4: Working with Multiple Tables (JOINs)
What are primary keys & foreign keys
Use JOIN to connect two tables
Practice: student table + course table
Simple use of functions: COUNT, MAX, MIN, SUM
🔹 Week 5 (Optional): Mini Project + Practice
Create a mini project: Student Management System
Add, view, edit, and delete student data
Search students by name, age, or class