MySQL

RDD vs. DataFrame vs. Dataset

July 21, 2021

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.

Read more

How To Optimize MySQL Tables

June 24, 2021

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.

Read more

How to Install MySQL on Ubuntu 20.04

June 3, 2021

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.

Read more

What Is Database Denormalization?


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.

Read more

What is Database Normalization?

May 26, 2021

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

Read more

MySQL Events and Event Scheduler Guide

April 27, 2021

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.

Read more

How To Use MySQL JOINS {With Examples}

April 20, 2021

Introduction JOINS in MySQL are used to combine information located in multiple tables and retrieve that information in a single result. Relational databases contain several logically related tables linked together, and each table contains unique data or common data. JOINS help retrieve data from tables based on a common field between them. In this tutorial, you will […]

Read more

How To Use MySQL Triggers

April 12, 2021

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.

Read more

MySQL Data Types

March 4, 2021

Data types are important to understand as a name and a data type define each column in a database table. Learn all about MySQL data types and when to use them in this comprehensive guide.

Read more

MySQL Date Function Guide with Examples

January 28, 2021

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.

Read more
1 2 3 5
© 2021 Copyright phoenixNAP | Global IT Services. All Rights Reserved.