by Simon Krenger | Released August 2017 | ISBN: 9781788393638

Recipes to guide you in MySQL 8 anytimeAbout This VideoStore, retrieve, and manipulate your data and design efficient database solutions with MySQL 8Solve any problem you might come across in MySQL querying and administrationA practical tutorial designed for MySQL developers and administratorsIn DetailMySQL 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.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 Show and hide more

1. Chapter 1 : Overview and Installation
   • The Course Overview 00:02:59
   • Learning MySQL 8 00:05:01
   • Getting to Know the MySQL 8 Architecture 00:08:44
   • Installation via Package Manager 00:09:10
   • Installation via Manual Package 00:07:14
   • Upgrading an Existing Database to MySQL 8 00:06:09
2. Chapter 2 : Working with the Database
   • Using Tools to Access the Database 00:05:38
   • Getting to Know Your Database 00:06:42
   • Performing Initial Database Configuration 00:07:47
   • Accessing the Data Dictionary 00:06:11
   • Managing Users 00:08:26
3. Chapter 3 : Administration Topics
   • Performing Basic Troubleshooting 00:06:19
   • Configuring Security 00:06:49
   • Performing Backup and Recovery of Your Database 00:07:58
   • Optimizing Performance with Query Execution Plans 00:08:33
4. Chapter 4 : Querying the Database
   • Learning SQL: Querying Data 00:09:02
   • Learning SQL: Inserting and Modifying Data 00:06:31
   • Learning SQL: Design Databases 00:07:33
   • Learning Best Practices for Writing Queries 00:05:34
   • Using the New Querying Features in MySQL 8 00:06:05
   • Working with Indexes 00:08:19
   • Managing Big Databases Using Partitioning 00:07:26
5. Chapter 5 : Programming Examples
   • Programming with PHP 00:07:11
   • Using a PHP Database Abstraction Layer 00:07:01
   • Programming with Python 00:06:27
   • Programming with Java 00:07:21
Show and hide more