Book Image

MySQL 8 Recipes [Video]

By : Simon Krenger
Book Image

MySQL 8 Recipes [Video]

By: Simon Krenger

Overview of this book

<p>MySQL is one of the most popular and widely used relational databases in the World today. With the recently released MySQL 8, it promises to be better and more efficient than ever, giving you high-performance querying results and easy configurability as an administrator. This course contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and configuration of your MySQL instance, the video jumps into the querying aspects of MySQL and shows you the newest improvements in MySQL 8 when it comes to querying and programming with other languages such as Python, PHP, and more.</p> <p>If you’ve already worked with MySQL before and are looking to migrate your solution to MySQL 8, this video will also show you how to do that. The tutorial also 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</p> <h1>Style and Approach</h1> <p>This friendly course takes you through MySQL 8. It is packed with step-by-step instructions and working examples. This comprehensive course is divided into clear bite-size chunks so you can learn at your own pace and focus on the areas of most interest to you.</p>
Table of Contents (5 chapters)
Chapter 3
Administration Topics
Content Locked
Section 3
Performing Backup and Recovery of Your Database
Keeping your data safe from data corruption and hardware failures is an important task when running a database. This video will show you simple ways to backup and recovery your data. - Understand why database backups are important - Perform database backup - Perform database recovery