掌握高级MySQL DBA技能，深入学习复制、备份、恢复、安全及自动化工具（存储过程、触发器和事件）。本课程由专家讲授，适合进阶学习者提升数据库管理效率。
原始标题：Advanced MySQL Database Administration
Released 9/2024
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Advanced | Genre: eLearning | Language: English + srt | Duration: 7h 51m | Size: 1.1 GB
MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, take your database DBA skills to the next level and expand into advanced concepts like replication, backup, recovery, and security, along with automation tools like stored procedures, triggers, and scheduled events.
Instructor John Pauler starts by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks. Learn about creating and editing schemas and tables, inserting and deleting records, and reviewing the key principles of normalized databases.
John then covers advanced DBA concepts like replication, backup and recovery, and how to leverage automation via stored procedures, triggers, and scheduled events.
Throughout the course, you’ll be playing the role of lead DBA for a new firm, building out an entire database and populating tables from the ground up, just like you would in the real world.
此处内容需要权限查看
会员免费查看
