Databases

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 a Database Server & What Is It Used For?

May 31, 2021

A database server is a machine used to store the database and to manage data access and retrieval. Read this article to learn more about database servers, how they work, and to see some examples of database servers.

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

How to Create a Database in PostgreSQL


This tutorial shows three easy ways to create a database in PostgreSQL. Whether you prefer using a GUI or the command line, PostgreSQL's got you covered.

Read more

12 Best Cloud Databases

May 20, 2021

This article deals with the key features of cloud databases, their benefits over traditional on-premises databases. Read to find out some available cloud database solutions.

Read more

Database Types Explained

May 13, 2021

There are many different types of databases currently available. The wrong choice can have a great impact. Whether you're looking to learn about the different database types or looking into how to make a choice, this article gives a comprehensive overview of the available database types.

Read more

What is a Document Database?


This article deals with the characteristics of document databases, how they differ from relational databases, and their pros and cons. Read on to see examples of document databases.

Read more

What Is an OLTP Database?

May 12, 2021

The OLTP database system is used to manage and process everyday transactions of a business or company. Learn about OLTP and its difference from OLAP in this article.

Read more

What Is a Distributed Database?

May 6, 2021

Distributed databases are a solution for various issues that arise when using a centralized database. Learn about distributed databases and their advantages and disadvantages.

Read more
1 9 10 11 12 13 15