MySQL 8 Recipes [Video]

Preview in Mapt

MySQL 8 Recipes [Video]

Simon Krenger

Recipes to guide you in MySQL 8 anytime
Mapt Subscription
FREE
$29.99/m after trial
Video
$106.25
RRP $124.99
Save 14%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$106.25
$29.99 p/m after trial
RRP $124.99
Subscription
Video
Start 30 Day Trial

Frequently bought together


MySQL 8 Recipes [Video] Book Cover
MySQL 8 Recipes [Video]
$ 124.99
$ 106.25
MySQL 8 Cookbook Book Cover
MySQL 8 Cookbook
$ 39.99
$ 28.00
Buy 2 for $35.00
Save $129.98
Add to Cart

Video Details

ISBN 139781788393638
Course Length3 hours 02 minutes

Video Description

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

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
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
Administration Topics
Performing Basic Troubleshooting
Configuring Security
Performing Backup and Recovery of Your Database
Optimizing Performance with Query Execution Plans
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
Programming Examples
Programming with PHP
Using a PHP Database Abstraction Layer
Programming with Python
Programming with Java

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

Authors

Table of Contents

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
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
Administration Topics
Performing Basic Troubleshooting
Configuring Security
Performing Backup and Recovery of Your Database
Optimizing Performance with Query Execution Plans
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
Programming Examples
Programming with PHP
Using a PHP Database Abstraction Layer
Programming with Python
Programming with Java

Video Details

ISBN 139781788393638
Course Length3 hours 02 minutes
Read More

Read More Reviews

Recommended for You

MySQL 8 Cookbook Book Cover
MySQL 8 Cookbook
$ 39.99
$ 28.00
MySQL 8 for Big Data Book Cover
MySQL 8 for Big Data
$ 35.99
$ 25.20
Java EE 8 Microservices Book Cover
Java EE 8 Microservices
$ 39.99
$ 28.00
Mastering Drupal 8 Development [Video] Book Cover
Mastering Drupal 8 Development [Video]
$ 124.99
$ 106.25
R Data Visualization Recipes Book Cover
R Data Visualization Recipes
$ 39.99
$ 28.00
Java SE 8 Programmer 2 (Part II) [Integrated Course] Book Cover
Java SE 8 Programmer 2 (Part II) [Integrated Course]
$ 124.99
$ 106.25