MySQL Database Administration
⭐ 0 (0 ratings) • 0 users
Created by Anonymous
Last updated 01/1970 • English [Auto]
What you'll learn
- Managing a business successfully
- Formulating winning business strategies
- Marketing
- Purchase & Manufacturing
- Finance & Control
- Right People Management
- Right Products in Right Markets
- Sales & Distribution
- Research & Development
- Real-Life Business Strategy
Course content
3 modules • 35 lessons • 9h 39m total length
- ✅ MySQL Architecture Overview 03:28
- ✅ Installation Methods 03:28
- ✅ Configuration Files and Hierarchy 03:28
- ✅ Essential Configuration Parameters 03:28
- ✅ Creating and Managing Users 03:28
- ✅ Privilege System (GRANT, REVOKE) 03:28
- ✅ Password Policies and Authentication 03:28
- ✅ SSL/TLS Configuration 03:28
- ✅ Security Best Practices 03:28
- ✅ mysql_secure_installation 03:28
- ✅ InnoDB vs MyISAM vs Memory 03:28
- ✅ Table Creation and Management 03:28
- ✅ Data Types and Best Practices 03:28
- ✅ Character Sets and Collations 03:28
- ✅ Views, Stored Procedures, Functions 03:28
- ✅ Logical Backups (mysqldump) 03:28
- ✅ Physical Backups (Percona XtraBackup) 03:28
- ✅ Binary Log Backup & Point-in-Time Recovery 03:28
- ✅ Backup Strategies & Scheduling 03:28
- ✅ Recovery Procedures & Testing 03:28
- ✅ Index Types (B-tree, Hash, Full-text) 03:28
- ✅ Index Creation & Maintenance 03:28
- ✅ Composite Indexes & Covering Indexes 03:28
- ✅ EXPLAIN Plan Analysis 03:28
- ✅ Index Statistics & Cardinality 03:28
- ✅ Slow Query Log Analysis 03:28
- ✅ Query Profiling 03:28
- ✅ Optimizer Hints 03:28
- ✅ Common Performance Pitfalls 03:28
- ✅ Best Practices for Writing Efficient Queries 03:28
- ✅ InnoDB Buffer Pool Configuration 03:28
- ✅ Connection & Thread Management 03:28
- ✅ Cache Optimization (Query Cache deprecation) 03:28
- ✅ I/O Optimzation 03:28
- ✅ Memory Management 03:28
₱0 ₱0
🔥 3 days left at this price!
30-Day Money-Back Guarantee
This course includes:
- ✔ 9.5 hours on-demand video
- ✔ 64 downloadable resources
- ✔ Access on mobile and TV
- ✔ Full lifetime access
- ✔ Certificate of completion