MySQL

The Foundational Database

MySQL has been the relational database I have worked with the longest. My experience began with the Ragnarok Canopus Private Server, where I was responsible for administering the entire database, which stored all game data from user accounts to items and monster spawns.

Web Application Backend

Throughout my career, MySQL has been the backend for dozens of PHP-based web applications. In projects built with both raw PHP and frameworks like CodeIgniter, I designed database schemas, wrote complex SQL queries, and ensured data integrity.

Key Competencies

• Database Design: Creating normalized and efficient database schemas (e.g., Third Normal Form).
• SQL Proficiency: Writing advanced SQL queries, including complex joins, subqueries, and aggregate functions.
• Administration: Performing tasks like backup and recovery, user management, and performance tuning.
• Query Optimization: Using tools like EXPLAIN to analyze query performance and optimize indexes.
• Storage Engines: Understanding of different storage engines like InnoDB and MyISAM.