MySQL

Full MySQL course — 47 topics from the basics to advanced use.

Lessons

• Stored Procedures
• Stored Functions
• Triggers
• Events and the Event Scheduler
• JSON in MySQL
• Full-Text Search
• Spatial Data (GIS)
• Generated Columns and Invisible Columns
• Partitioning
• Users, Roles, Privileges, and Security
• SQL Injection and Secure Application Access
• Backup and Recovery
• Replication and High Availability
• Query Optimization
• Server Configuration, Tuning, and Monitoring
• Schema Design for MySQL
• MySQL Introduction
• Installing and Setting Up MySQL
• Working with MySQL Clients
• Databases and Tables
• MySQL Data Types
• Character Sets and Collations
• Constraints, Keys, and AUTO_INCREMENT
• Inserting, Updating, and Deleting Data
• Querying Data with SELECT
• MySQL Built-in Functions
• Aggregation and GROUP BY
• Connecting Applications to MySQL
• MySQL for Automotive and Embedded Engineering
• MySQL Projects
• Troubleshooting and Common Errors
• MySQL Best Practices
• MySQL Versions, Upgrades, and Deprecations
• MySQL Interview Questions
• Practice Exercises
• MySQL Cheat Sheet
• Final Quiz
• Learning Roadmap
• What to Learn Next & Final Checklist
• Joins
• Subqueries, Derived Tables, and Set Operations
• CTEs and Window Functions
• Views
• Indexes in MySQL
• Transactions and Locking in InnoDB
• Storage Engines and InnoDB Architecture
• Course Overview & Sample Database