MySQL 8 Recipes

MySQL 8 Recipes

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 3h 02m | 523 MB

Recipes to guide you in MySQL 8 anytime

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.

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

What You Will Learn

  • Install and configure a new MySQL 8 database
  • Upgrade existing databases to MySQL 8
  • Perform typical administration tasks
  • Master the new querying features in MySQL 8
  • Perform performance-tuning tasks
  • Optimize your database
  • Access databases with PHP, Python, or Java
Table of Contents

01 The Course Overview
02 Learning MySQL 8
03 Getting to Know the MySQL 8 Architecture
04 Installation via Package Manager
05 Installation via Manual Package
06 Upgrading an Existing Database to MySQL 8
07 Using Tools to Access the Database
08 Getting to Know Your Database
09 Performing Initial Database Configuration
10 Accessing the Data Dictionary
11 Managing Users
12 Performing Basic Troubleshooting
13 Configuring Security
14 Performing Backup and Recovery of Your Database
15 Optimizing Performance with Query Execution Plans
16 Learning SQL – Querying Data
17 Learning SQL – Inserting and Modifying Data
18 Learning SQL – Design Databases
19 Learning Best Practices for Writing Queries
20 Using the New Querying Features in MySQL 8
21 Working with Indexes
22 Managing Big Databases Using Partitioning
23 Programming with PHP
24 Using a PHP Database Abstraction Layer
25 Programming with Python
26 Programming with Java