MySQL - Database Management Diploma

Course details

• Master the fundamentals of MySQL database architecture.
• Acquire proficiency in designing and implementing robust database structures.
• Explore advanced querying techniques for efficient data retrieval.
• Gain insights into optimizing database performance and security.
• Develop the expertise to manage and troubleshoot MySQL databases seamlessly.

• Module 1: Introduction on MySQL 
• Module 2: Data Types 
• Module 3: SELECT Statements 
• Module 4: Backticks 
• Module 5: NULL 
• Module 6: Limit and Offset 
• Module 7: Creating databases 
• Module 8: Using Variables 
• Module 9: Comment MySQL 
• Module 10: INSERT Statements
• Module 11: DELETE Statements 
• Module 12: UPDATE Statements 
• Module 13: ORDER BY Clause 
• Module 14: Group By 
• Module 15: Errors in MySQL 
• Module 16: Joins 
• Module 17: Joins continued 
• Module 18: UNION 
• Module 19: Arithmetic 
• Module 20: String operations 
• Module 21: Date and Time Operations 
• Module 22: Handling Time Zones 
• Module 23: Regular Expressions 
• Module 24: VIEWS 
• Module 25: Table Creation 
• Module 26: ALTER TABLE 
• Module 27: Drop Table 
• Module 28: MySQL LOCK TABLE 
• Module 29: Error codes 
• Module 30: Stored routines (procedures and functions) 
• Module 31: Indexes and Keys 
• Module 32: Full-Text search 
• Module 33: PREPARE Statements 
• Module 34: JSON 
• Module 35: Extract values from JSON type 
• Module 36: MySQL Admin 
• Module 37: TRIGGERS 
• Module 38: Configuration and tuning 
• Module 39: Events 
• Module 40: ENUM 
• Module 41: Collations, Transactions, Log files, Replication, Backup