Free Download Udemy MySQL: Become A MySQL Admin. With the help of this course you can Store, retrieve, and manipulate your data and design efficient database solutions with MySQL 8.
This course was created by . It was rated 3.4403782 out of 5 by approx 154 ratings. There are approx 774 users enrolled with this course, so don’t wait to download yours now. This course also includes 507 mins on-demand video, Full lifetime access, Access on mobile and TV & Certificate of Completion.
What will I need?
- Basic understanding of database concepts is all you need
Is this course right for me?
- New and returning MySQL DBAs, who are just getting to know MySQL, or who knew earlier versions and are curious about the latest administration differences in MySQL 8
What am I going to learn?
- Handle MySQL user management
- Set up and operate MySQL replication, including moving to GTID based replication
- Hands on experience of operations carried out on MySQL instances, running sysbench against them, and producing a workload
- Perform administration and performance-tuning tasks
- Master the new querying features in MySQL 8
- Access databases with PHP, Python, or Java
MySQL is the most popular and widely used relational databases in the World today.
The main purpose of this comprehensive course is to assist you on setting up MySQL 8 and running with replication, learn about database administration topics like backups, replication, monitoring, and point in time recovery, switchovers, user management and version upgrades. It is packed with step-by-step instructions and working examples to solve any problem you might come across in MySQL querying and administration
Contents and Overview
This training program includes 2 complete courses, carefully chosen to give you the most comprehensive training possible.
The first course, MySQL 8 for Administrators, covers the differences between various MySQL versions. It starts off with the basics: Installing MySQL and creating users. After that, we will get sysbench up and running. Sysbench, responsible for issuing queries against databases, is the de-facto benchmarking tool for MySQL. With that hands-on lab environment at hand, we will learn about various database administration topics like backups, replication, monitoring, and point in time recovery, switchovers, user management and version upgrades.
The second course, MySQL 8 Recipes, contains practical recipes on efficient MySQL administration, with tips on effective user management, security, database monitoring, troubleshooting, and more. Supplying quick solutions to common problems you might encounter while working with MySQL, the tutorial contains practical tips and tricks to give you the edge over others while designing, developing, and administering your MySQL solution.
By the end of this training program, you will be well versed with high-performance querying and database administration using MySQL.
About the Authors
Peter Boros has more than 10 years of MySQL administration experience. Peter has also taught Oracle University courses about MySQL across EMEA, later he was a Principal Architect at Percona, a company specializing in MySQL consulting. Apart from this, he has worked with a few of the world’s largest MySQL deployments, belonging to prestigious web properties. This course is a product of Peter’s immense work experience and his expertise on the subject.
Simon Krenger is a Database Engineer for the Swiss Federal Railways (SBB) in Bern, Switzerland. He has worked with a wide variety of technologies, including Oracle databases (OCP), Linux, and automation software. He focuses on Information Security and has gained experience with common agile software development practices.
Free Download Udemy’s MySQL: Become A MySQL Admin