±³À°¸í | ÃÊ±Þ MySQL for Database Administrators (DBA¸¦ À§ÇÑ MySQL ¼¹ö ±¸¼º) 3Â÷ |
---|---|
±³À°±â°£ | 2018-01-08 ~ 2018-01-12 |
±³À°½Ã°£ | 30 ½Ã°£ |
±³À°Àå | ¿µ¿ì±Û·Î¹ú·¯´× Áöµµº¸±â |
°»ç | ¿À¶óŬ°øÀΰ»ç |
Á¤¿ø | 20¸í |
±³À°ºñ | 1,230,000 ¿ø |
¡à Course Topics
- MySQL overview
- MySQL Enterprise Edition
- MySQL on the Web
- MySQL in the Cloud
- The MySQL community
¡Û Installing MySQL
- Installing MySQL
- Installed Files and Directories
- Initial Configuration
- Starting and Stopping MySQL
- Upgrading MySQL
¡Û MySQL Architecture
- Architectural Overview
- How MySQL Transmits Data
- How MySQL Processes Requests
- How MySQL Stores Data
- Tablespaces
- Redo and Undo Logs
- How MySQL Uses Memory
- Plug-in Interface
¡Û Configuring MySQL
- Server Options, Variables, and the Command Line
- Option Files
- System Variables
- Launching Multiple Servers on the Same Host
¡Û Monitoring MySQL
- Monitoring MySQL with Log Files
- Monitoring MySQL with Status Variables
- Monitoring MySQL with Performance Schema
- MySQL Enterprise Audit
- MySQL Enterprise Monitor
- Monitoring User Activity
¡Û User Management
- MySQL Privilege System
- Creating and Modifying User Accounts
- Configuring Passwords and Account Expiration
- Authentication Plug-Ins
- Granting Permissions
- Grant Tables
- Resetting a Forgotten Root Password
¡Û MySQL Security
- Security Risks
- Network Security
- Secure Connections
- Password Security
- Operating System Security
- Protecting Against SQL Injections
- MySQL Enterprise Firewall
¡Û Maintaining a Stable System
- Stability
- Why Databases Fail
- Capacity Planning
- Troubleshooting
- Identifying the Causes of Server Slowdowns
- InnoDB Recovery
¡Û Optimizing Query Performance
- Identifying Slow Queries
- The EXPLAIN statement
- Working with Indexes
- Index Statistics
¡Û Backup Strategies
- Understanding Backups
- Backup Techniques
- Creating a Backup Strategy
¡Û Performing Backups
- MySQL Backup Tools
- Raw Backup Methods
- Techniques that Use the Binary Log
¡Û Configuring a Replication Topology
- Overview of Replication
- Replication Conflicts
- When to Use Replication
- Configuring Replication
¡Û Administering a Replication Topology
- Failover
- MySQL Utilities
- Replication Threads
- Monitoring Replication
- Troubleshooting Replication
¡Û Group Replication
- Overview
- Single-Primary and Multi-Primary Modes
- Configuring Group Replication
- Monitoring Group Replication
¡Û Conclusion
- Course Overview
- MySQL Curriculum
- Course Evaluation
- Thank You!
- Q&A Session
ÇпøÀÇ ¼³¸³¤ý¿î¿µ ¹× °ú¿Ü±³½À¿¡ °üÇÑ ¹ý·ü ½ÃÇà·É¿¡ µû¶ó ´ÙÀ½°ú °°ÀÌ ¼ö°·á¸¦ ȯºÒÇØµå¸³´Ï´Ù.