MySQL
Course Scope
This section contains the MySQL course migrated from Notion and standardized to Docusaurus MDX format.
Modules
- 1. Introduction
- 2. MySQL Data Types
- 3. Basic SQL Operations
- 4. Filtering and Conditions
- 5. Aggregate Functions
- 6. Joins and Unions
- 7. Grouping & Filtering
- 8. Advanced SQL Features
- 9. Database Management
- 10. Constraints & Indexes
- 11. Date & Time Functions
- 12. Views
- 13. Stored Procedures and Functions
- 14. Triggers
- 15. Event Scheduler
- 16. Transactions and Concurrency
- 17. User Management and Security
- 18. Performance Optimization
- 19. Backup and Recovery
Notes
- Placeholder and planning-only source files are intentionally excluded from migration source artifacts.
- Modules 7-18 are now implemented as structured MDX lessons with practical SQL examples and tabular guidance.
- Content has been normalized for Docusaurus MDX safety.
Course Usage
Recommended Learning Order
Follow the modules in numeric order, complete the SQL exercises in each lesson, and run every query in a local practice database before production use.
What's Next
- Start with 1. Introduction to build the fundamentals.
- Continue through each numbered module and practice with your own schema.