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.
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.
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.
As the easiest way to install a database, learn how to install a new MySQL database using the existing packages in your Linux system.
This video covers more advanced or more customized installations, install a new database using the generic method provided by MySQL.
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.
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.
Learn how you can list databases inside your server and how you can navigate between the different databases.
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.
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.
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.
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.
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.
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.
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.
Querying data is maybe the most important task for any database developer. This video explores simple and more advanced usages of the SELECT command.
To modify data, SQL uses three different commands. This video will help you to insert and modify data in your database.
In this video, we will learn about creating new tables and will learn about the most common data types in MySQL.
Writing good queries may sound hard, but with a few tips you will be writing better queries in an instant.
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.
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.
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.
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.
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.
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.
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.
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.