mysql
MySQL database administration, optimization, and development for production environments.
- Covers core administration tasks including installation, user management, backup with mysqldump, binary log management, and configuration tuning
- Query development support for SELECT, JOINs, subqueries, stored procedures, triggers, and events
- Performance optimization through EXPLAIN analysis, index tuning, slow query log review, and Performance Schema inspection
- High availability setup including MySQL replication, group replication, MySQL Router, ProxySQL, and failover strategies
- Requires SQL fundamentals, Linux basics, and networking knowledge
MySQL Skill
Overview
Master MySQL database administration, optimization, and development for production environments.
Topics Covered
MySQL Basics
- Installation and configuration
- User management
- Database creation
- Storage engines (InnoDB, MyISAM)
- Character sets
Query Development
- SELECT statements
- JOINs and subqueries
- INSERT, UPDATE, DELETE
- Stored procedures
More from pluginagentmarketplace/custom-plugin-sql
data-analysis-sql
SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.
57data-warehouse
Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.
51redis
Redis data structures and commands including strings, lists, hashes, sets, sorted sets, streams, and transactions for high-performance caching and real-time applications.
49postgresql
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
41bi-fundamentals
BI fundamentals with metric definition, KPI calculation, dimensional modeling, dashboard optimization, and data storytelling. 40+ metric examples and calculation patterns.
36sql-fundamentals
Master SQL fundamentals including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations. Learn data types, WHERE clauses, ORDER BY, GROUP BY, and basic joins.
29