BTC - 1CZ4nTozpgfgqufWhiXDtBu9pVurd41SPz
Overview
Store, retrieve, and manipulate your data and design efficient database solutions with MySQL 8
Solve any problem you might come across in MySQL querying and administration
A practical tutorial designed for MySQL developers and administrators
Objectives
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
About
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
Style and Approach
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.
Table of Contents
1 Overview and Installation
The Course Overview
Learning MySQL 8
Getting to Know the MySQL 8 Architecture
Installation via Package Manager
Installation via Manual Package
Upgrading an Existing Database to MySQL 8
2 Working with the Database
Using Tools to Access the Database
Getting to Know Your Database
Performing Initial Database Configuration
Accessing the Data Dictionary
Managing Users
3 Administration Topics
Performing Basic Troubleshooting
Configuring Security
Performing Backup and Recovery of Your Database
Optimizing Performance with Query Execution Plans
4 Querying the Database
Learning SQL: Querying Data
Learning SQL: Inserting and Modifying Data
Learning SQL: Design Databases
Learning Best Practices for Writing Queries
Using the New Querying Features in MySQL 8
Working with Indexes
Managing Big Databases Using Partitioning
5 Programming Examples
Programming with PHP
Using a PHP Database Abstraction Layer
Programming with Python
Programming with Java |