📚 Course Curriculum
1. Introduction to Databases & MySQL ▼
- What is a database?
-
Relational vs. non-relational databases
-
Installing and configuring MySQL
2. MySQL Tools ▼
- MySQL Workbench overview
-
Command-line client basics
-
Connecting to databases
3. Database & Table Management ▼
- Creating databases
-
Creating tables with constraints
-
Dropping and altering tables
4. Data Types & Operators ▼
- Numeric, string, date/time data types
-
Primary key, foreign key, auto-increment
-
Comparison and logical operators
5. Basic SQL Queries ▼
- SELECT statements
-
WHERE clause filtering
-
ORDER BY and LIMIT
6. Joins & Relationships ▼
- INNER JOIN, LEFT JOIN, RIGHT JOIN
-
Understanding one-to-many and many-to-many relationships
-
Using aliases
7. Data Manipulation ▼
- INSERT, UPDATE, DELETE
-
Bulk inserts
-
Safe updates with conditions
8. Functions & Expressions ▼
- String functions (CONCAT, LENGTH, SUBSTRING)
-
Numeric functions (ROUND, CEIL, FLOOR)
-
Date functions (NOW, CURDATE, DATE_FORMAT)
9. Mini Project (Basics) ▼
- To be Decided..............