📚 Course Curriculum
1. Advanced Queries ▼
- Subqueries (single-row, multi-row)
-
EXISTS and IN operators
-
Complex joins
2. Indexes & Performance ▼
- Types of indexes (BTREE, HASH)
-
Creating and dropping indexes
-
Query optimization with EXPLAIN
3. Stored Procedures & Functions ▼
- Creating stored procedures
-
User-defined functions
-
Parameters and return values
4. Triggers ▼
- BEFORE and AFTER triggers
-
Row-level vs. statement-level triggers
-
Practical use cases
5. Views ▼
- Creating and managing views
-
Updatable views
-
Security benefits of views
6. Transactions & Concurrency ▼
- COMMIT, ROLLBACK, SAVEPOINT
-
Isolation levels (READ COMMITTED, REPEATABLE READ, SERIALIZABLE)
-
Locking mechanisms
7. User Management & Security ▼
- Creating users and assigning privileges
-
GRANT and REVOKE
-
Securing MySQL connections
8. Backup & Recovery ▼
- mysqldump basics
-
Point-in-time recovery
-
Restoring databases
9. Capstone Project (Advanced) ▼
- To be Decided..................