MySQL 8 Recipes
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MySQL 8 Recipes to your Wishlist.

Add to Wishlist

MySQL 8 Recipes

Recipes to guide you in MySQL 8 anytime
New
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Created by Packt Publishing
Last updated 9/2017
English
English [Auto-generated]
Current price: $12 Original price: $125 Discount: 90% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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
View Curriculum
Requirements
  • 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.
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

About The Author

Simon is a Database Engineer for the Swiss Federal Railways (SBB) in Bern, Switzerland.

He has worked with a wide variety of technologies, including Oracle databases (OCP), Linux, and automation software. He focuses on Information Security and has gained experience with common agile software development practices.


Who is the target audience?
  • If you are a MySQL developer or administrator looking for quick, handy solutions to solve common and not-so-common problems in MySQL, this course is all you need. Some basic understanding of database concepts is all you need to get started with this video. Some familiarity with MySQL will be helpful, but not mandatory.
Compare to Other MySQL Courses
Curriculum For This Course
26 Lectures
03:02:04
+
Overview and Installation
6 Lectures 39:15

This video provides an overview of the entire course.

Preview 02:59

Get to know the MySQL database by learning about other databases and comparing them to MySQL. Also visit the MySQL website to find the documentation and downloads.

Learning MySQL 8
05:01

When working with MySQL, you should quickly be able to locate a problem within the MySQL software. This video will give you an overview on how MySQL is built and what components there are.

Getting to Know the MySQL 8 Architecture
08:44

As the easiest way to install a database, learn how to install a new MySQL database using the existing packages in your Linux system.

Installation via Package Manager
09:09

This video covers more advanced or more customized installations, install a new database using the generic method provided by MySQL.

Installation via Manual Package
07:14

In this video, we will upgrade an existing database to the latest version of MySQL, for that, you need to perform a few steps. This video will show you what these steps are and how you can upgrade successfully.

Upgrading an Existing Database to MySQL 8
06:08
+
Working with the Database
5 Lectures 34:43

Access your database using different tools provided by MySQL. We will explore both tools for the command-line and tools with a graphical user interface.

Preview 05:38

Learn how you can list databases inside your server and how you can navigate between the different databases.

Getting to Know Your Database
06:42

Configuring a database is one of the typical tasks that a database administrator has to perform. Learn how you can see how your database is configured and how you can change the configuration.

Performing Initial Database Configuration
07:47

The data dictionary is a big new feature in MySQL 8. This video shows you some of the new views and how you can use the new feature to get more information about your database.

Accessing the Data Dictionary
06:10

Learn how to create, modify and delete users in your database. We will also explore how you can set the privileges for existing or new users.

Managing Users
08:26
+
Administration Topics
4 Lectures 29:37

When operating a database, you will certainly encounter some problems. This video helps you to perform basic troubleshooting on your database and find common problems.

Preview 06:19

Because the data in your database is often important, we need to make sure your data stays safe. This video talks about security issues and how you can secure your database.

Configuring Security
06:48

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.

Performing Backup and Recovery of Your Database
07:57

For your application, it is important that the data returned from the database is returned as quickly as possible. This video explains how you can improve the performance of your query by using Query Execution Plans.

Optimizing Performance with Query Execution Plans
08:33
+
Querying the Database
7 Lectures 50:30

Querying data is maybe the most important task for any database developer. This video explores simple and more advanced usages of the SELECT command.

Preview 09:02

To modify data, SQL uses three different commands. This video will help you to insert and modify data in your database.

Learning SQL: Inserting and Modifying Data
06:31

In this video, we will learn about creating new tables and will learn about the most common data types in MySQL.

Learning SQL: Design Databases
07:33

Writing good queries may sound hard, but with a few tips you will be writing better queries in an instant.

Learning Best Practices for Writing Queries
05:34

MySQL 8 brings a few new features for developers to make querying the database easier. This video shows you what new features there are and takes a closer look at Common Table Expressions.

Using the New Querying Features in MySQL 8
06:05

Aside from tables, indexes are an important tool to make your queries faster. Learn about different types of indexes and also learn how indexes can have disadvantages.

Working with Indexes
08:19

Managing big tables with a lot of rows is no easy task. Thankfully, with MySQL 8, there are new features to manage partitions. We will also see the different available partitioning types.

Managing Big Databases Using Partitioning
07:26
+
Programming Examples
4 Lectures 27:59

On the web, PHP is one of the most popular languages. So for building your web application, you can use different modules to access a database backend. In this video, we will learn about the mysqli module and how we can use this module to access the database. This video also includes PHP example code.

Preview 07:11

When working with PHP and objects, a database abstraction layer can help you to write easier code. In this video, we will learn about using PDO and how we can access the database using the PDO methods.

Using a PHP Database Abstraction Layer
07:01

Writing code in Python is very easy. This video shows you how you can also easily access a MySQL database using the MySQLdb Python module. This video also includes Python example code.

Programming with Python
06:26

Java is one of the most common programming languages today. Accessing the database in Java always uses a JDBC driver. This video will show you how JDBC works and what methods you can use to access the database. Also, this video contains example code for accessing the database with Java.

Programming with Java
07:21
About the Instructor
Packt Publishing
3.9 Average rating
8,274 Reviews
59,234 Students
687 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.