Practical Guides, Builds & Real-World Lessons
Articles on architecture, performance optimization, CMS platforms, backend systems, infrastructure, and scalable digital engineering.
Showing 2 of 2 articles
🚀 My Experience Solving the TestGorilla WordPress & MySQL Assessment
Recently, I completed a TestGorilla technical assessment covering two core backend areas: ✅ WordPress (Core, Plugins, Hooks, Security, Database) ✅ MySQL (Queries, Joins, Subqueries, Triggers, Functions) In this article, I’ll walk through the key concepts tested and the correct approaches used to solve them. 🟦 Part 1: WordPress Assessment The WordPress section focused heavily on core architecture concepts, not just basic usage. 1️⃣ Default Post Formats Aside Gallery Chat Review Understanding post formats is important when building themes. 2️⃣ Default WordPress Taxonomies category post_tag post_format link_category These are essential when working with custom post types. 3️⃣ Performing Database Queries global $wpdb; $wpdb->query('SQL query here'); WordPress uses the $wpdb global object for database interaction. 4️⃣ Securing wp-config.php For security best practices, wp-config.php should be protected using .htaccess to prevent direct access to credentials. 5️⃣ Backup Support File backups Database backups 6️⃣ Anti-Spam Configuration Stricter comment moderation rules can be configured under: Settings → Discussion 7️⃣ Default Database Tables wp_commentmeta wp_postmeta wp_term_relationships 8️⃣ Plugin Header Comments Only the main plugin file requires a header comment — not all PHP files. 9️⃣ Plugin Utility Functions plugin_dir_path() plugin_basename() plugins_url() 🔟 Options API update_option('option_name', $value); The Options API is the standard way to store plugin settings. 1️⃣1️⃣ Settings API register_setting(); 1️⃣2️⃣ WordPress Hooks 🔹 Action Hooks 🔹 Filter Hooks These power WordPress extensibility. 🟩 Part 2: MySQL Assessment The MySQL section tested practical, real-world query logic and relational database understanding. 1️⃣ Primary & Foreign Keys Used to enforce referential integrity between related tables. 2️⃣ OR vs AND WHERE color = 'blue' OR color = 'white' 3️⃣ Second Highest Salary SELECT MAX(salary) FROM employees WHERE salary 4️⃣ Triggers AFTER INSERT AFTER DELETE 5️⃣ ALTER TABLE ALTER TABLE stu_data ADD ssn CHAR(10); ALTER TABLE emp_data MODIFY email VARCHAR(127); 6️⃣ AUTO_INCREMENT country_id INT AUTO_INCREMENT PRIMARY KEY; 7️⃣ LIKE Operator WHERE emp_name LIKE 'A%'; 8️⃣ DELETE with Conditions DELETE FROM world_population WHERE (country_name = 'USA' OR country_name = 'UK') AND population 9️⃣ LIMIT in DELETE DELETE FROM stu_data LIMIT 10; 🔟 Correlated Subqueries WHERE goals_scored 1️⃣1️⃣ NOT EXISTS WHERE NOT EXISTS ( SELECT 1 FROM products_sold WHERE product_id = p.product_id ); 1️⃣2️⃣ Comparing with MAX() WHERE emp_salary > ( SELECT MAX(emp_salary) FROM emp WHERE dept_id = 10 ); 🎯 Key Skills This Assessment Tested WordPress Core Architecture Plugin Development Hooks & Extensibility Database Structure Understanding SQL Query Optimization Subqueries & Aggregates Triggers & Functions Logical Thinking 💡 Final Thoughts This wasn’t a beginner-level assessment. It required: Strong understanding of SQL logic Solid WordPress internal knowledge Clear thinking under time pressure If you're preparing for a WordPress + MySQL technical test: ✔ Master subqueries ✔ Understand hooks deeply ✔ Practice real-world SQL conditions ✔ Know WordPress core APIs
🚀 TestGorilla WordPress & MySQL Assessment – Breakdown & Solutions
I recently completed a TestGorilla technical assessment focused on WordPress and MySQL. The test evaluated real-world backend fundamentals including: WordPress Core & Plugin Development Database Schema Understanding SQL Query Logic & Subqueries Triggers & Functions Data Integrity & Optimization Part 1: WordPress Concepts Tested 1️⃣ WordPress Core Architecture Default post formats Built-in taxonomies Default database tables 2️⃣ Plugin Development Fundamentals Only the main plugin file requires a header comment. Common functions tested: plugin_dir_path() plugin_basename() plugins_url() 3️⃣ Database Interaction in WordPress global $wpdb; $wpdb->query('SQL query'); 4️⃣ Options API & Settings API update_option('option_name', $value); register_setting(); 5️⃣ Hooks System Action Hooks Filter Hooks 6️⃣ Security Best Practices Protect wp-config.php using .htaccess. Part 2: MySQL Questions Breakdown Primary & Foreign Keys Relational tables require proper PK and FK constraints. Filtering with OR SELECT * FROM products WHERE color = 'blue' OR color = 'white'; Second Highest Salary SELECT MAX(salary) FROM employees WHERE salary ALTER TABLE Usage ALTER TABLE stu_data ADD ssn CHAR(10); ALTER TABLE emp_data MODIFY email VARCHAR(127); AUTO_INCREMENT country_id INT AUTO_INCREMENT PRIMARY KEY; LIKE Operator SELECT * FROM emp_data WHERE emp_name LIKE 'A%'; DELETE with Conditions DELETE FROM world_population WHERE (country_name = 'USA' OR country_name = 'UK') AND population Correlated Subquery SELECT p.player_name FROM players p WHERE p.goals_scored NOT EXISTS SELECT p.product_name FROM products p WHERE NOT EXISTS ( SELECT 1 FROM products_sold ps WHERE ps.product_id = p.product_id ); Subquery with MAX SELECT emp_name FROM emp WHERE emp_salary > ( SELECT MAX(emp_salary) FROM emp WHERE dept_id = 10 ); Key Skills Evaluated Relational Database Design SQL Logical Thinking Subqueries & Aggregations WordPress Internal APIs Security & Best Practices Final Thoughts This assessment wasn't about memorization — it tested clarity of fundamentals. If you're preparing for backend roles involving WordPress and MySQL, mastering these concepts is essential.
Planning a Build or System Upgrade?
Whether you're launching a new platform, optimizing performance, migrating systems, or adding advanced functionality, you can begin a structured engagement.