MySQL

MySQL string functions allow you to manipulate character string data using the SELECT statement. Learn to use MySQL string functions with this comprehensive tutorial.

A corrupt database can happen at any moment. Try some of these methods to repair your MySQL database quickly.

Spark contains three major data structures and APIs for working with big data: RDDs, DataFrames and Datasets. Learn about the difference between them as well as when it's best to apply each.

MySQL tables fragment over time as delete and update queries are performed. With a large database, the fragmentation slows down queries significantly. Learn about when to use optimization and follow our tips on how to perform table defragmentation.

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.