MySQL

Learn how to install the MySQL server on Ubuntu 20.04 in this simple tutorial. See also how to secure your server after installation and log in to start working.

You've normalized a database, but now it's too complicated to analyze data. Database denormalization is a commonly used process in data analytics to simplify reports. Learn about the various methods to denormalize a database and when to apply it.

Database normalization is a key concept in database design. Learn how to organize the data and divide it into optimal tables for maximized efficiency.

MySQL events run on a schedule defined by the user. They automate database maintenance and execute tasks periodically. Learn how to use them in this simple tutorial.

This tutorial explains what MySQL JOINS are and how to use them to combine information located in multiple tables, producing a unified result.

MySQL triggers provide control over data validation when inserting, updating or deleting data from a database. Learn how to use triggers through an example database and when to use each type of trigger.

Find a list of all MySQL date functions in this helpful article. Learn what each function does and how to use it through the practical examples.

Need a reference sheet for all the important MySQL commands? Check out this MySQL Commands article which includes a downloadable MySQL cheat sheet in PDF format.

MySQL, the most widely used relational database management system can be installed on CentOS 8 from the default AppStream repository or from the official MySQL developer's repository. This article details both options and instructs how to secure your databases.

Deploying MySQL in a container is a fast and efficient solution for small and medium-size applications. Instead of setting up a separate MySQL server, you can deploy a MySQL database container instead. These containers are lightweight and fast to spin up since they share the kernel and libraries of the host while packaging the deployed application.