Mr. Editor-in-chief • November 21, 2025

Advanced MySQL Topics - Database Optimization

MySQL database optimization: create test tables with employees and activity data for performance tuning practice.

Mr. Editor-in-chief • September 18, 2025

Advanced MySQL Topics - Triggers & Scheduled Events

MySQL triggers and scheduled events: create automatic database actions with example product table setup.

Mr. Editor-in-chief • September 6, 2025

Advanced MySQL Topics - Functions vs Stored Procedures

MySQL stored functions vs procedures: comparison of creation commands, invocation methods, return value rules.

Mr. Editor-in-chief • February 17, 2024

Deploy Django with MySQL on Amazon Linux 2023

Deploy Django with MySQL on Amazon Linux 2023: MySQL 8.0 installation, temporary password retrieval, user setup.

Mr. Editor-in-chief • December 29, 2023

Deploy an Express API with MySQL database onto AWS EC2

Deploy Express API on AWS EC2: Node.js installation, MySQL 8.0 setup, database configuration, rsync code transfer.