MySQL

MySQL

Not yet built

This part of the roadmap has not been authored yet. Check back once it has its own concepts.

Sections in the roadmap

  1. MySQL Fundamentals — Must Be Strong4 items
  2. SQL Data Types7 items
  3. SQL Querying6 items
  4. INSERT, UPDATE, DELETE and Data Modification6 items
  5. Joins — Master This7 items
  6. Aggregation and Analytical SQL6 items
  7. Constraints and Data Integrity6 items
  8. Normalization and Schema Design6 items
  9. Keys and Identifiers6 items
  10. MySQL Storage Engines4 items
  11. InnoDB Internals — Senior Level7 items
  12. Indexing — Core Competency10 items
  13. Index Design Strategy6 items
  14. Query Execution and Optimizer5 items
  15. EXPLAIN and EXPLAIN ANALYZE5 items
  16. Query Optimization9 items
  17. Slow Query Investigation6 items
  18. Transactions7 items
  19. ACID4 items
  20. Isolation Levels4 items
  21. Locking and Concurrency7 items
  22. MVCC5 items
  23. Deadlocks and Lock Contention6 items
  24. Common Table Expressions4 items
  25. Views5 items
  26. Stored Procedures and Functions5 items
  27. Triggers4 items
  28. Events and Scheduled Database Work3 items
  29. JSON in MySQL5 items
  30. Character Sets and Collations5 items
  31. Date and Time Handling7 items
  32. Transactions with Business Workflows5 items
  33. Data Migration Strategy7 items
  34. Backup and Restore8 items
  35. Binary Logs and Replication6 items
  36. Replication Topologies6 items
  37. High Availability6 items
  38. Scaling MySQL8 items
  39. Partitioning5 items
  40. Sharding — Conceptual Senior Level8 items
  41. Connection Management7 items
  42. MySQL Security — Core Competency6 items
  43. Authentication and Accounts5 items
  44. Authorization and Roles5 items
  45. Encryption and Transport Security6 items
  46. SQL Injection Prevention4 items
  47. Data Privacy and Compliance7 items
  48. MySQL Monitoring3 items
  49. Performance Schema and Instrumentation3 items
  50. Slow Query Log and Diagnostics3 items
  51. MySQL Information Schema and Metadata3 items
  52. Metadata Locks and DDL3 items
  53. Online Schema Changes3 items
  54. Tablespaces and Storage4 items
  55. Buffer Pool and I/O4 items
  56. Memory and Temporary Tables3 items
  57. MySQL Error Handling and Diagnostics4 items
  58. Transactions and Deadlock Retry Strategy4 items
  59. Application Integration4 items
  60. MySQL with Django3 items
  61. Reporting and Analytics Workloads4 items
  62. Caching with MySQL8 items
  63. Message Queues and MySQL5 items
  64. OLTP vs OLAP4 items
  65. Schema Design for High-Scale Applications8 items
  66. Time-Series and Large Historical Tables3 items
  67. Full-Text Search2 items
  68. Spatial Data — Optional but Useful2 items
  69. Stored Logic vs Application Logic3 items
  70. Production Change Management3 items
  71. Capacity Planning4 items
  72. High-Availability and Disaster-Recovery Concepts3 items
  73. Common MySQL Anti-Patterns1 item
  74. MySQL Code/Schema Review Checklist6 items
  75. Practical MySQL Projects5 items
  76. Recommended Priority for a 5-Year MySQL Engineer3 items
  77. What a 5-Year MySQL Engineer Should Explain5 items
  78. Suggested Learning Order1 item
  79. Target Outcome1 item

Back to all topics