Databases

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

13 Best SQL Query Optimization Tools


Query optimization tools are a great way to improve server performance without having to manually change queries and look for errors. This article lists 13 best query optimization tools.

Read more

What Is Data Replication? {Replication Types and Schemes Explained}

June 17, 2021

Database replication is used to improve data security, increase availability and performance, and make the database more robust. This tutorial covers different methods for database replication.

Read more

Star vs. Snowflake Schema

June 10, 2021

The star and snowflake schemas are terms often used in the data warehouse architecture. Learn about what each schema brings to the table and what the drawbacks are of using each.

Read more

What Is a Relational Database?


Relational databases provide a structured and consistent way of storing data. This guide covers the definition of relational databases, the way they organize data, and the pros and cons to using them.

Read more

How to List All Databases in PostgreSQL

June 9, 2021

Follow this simple tutorial to learn three different ways to list all databases in PostgreSQL.

Read more

NoSQL Databases List

June 8, 2021

With the landscape of NoSQL databases changing from day to day, it can be hard to pick the right one to suit your needs.
To help with that, we've compiled a list of the best NoSQL databases for 2021.

Read more

OLTP vs. OLAP: A Comprehensive Comparison


With massive amounts of data, different processing techniques are used depending on whether you need to add information to a database or retrieve it for analytical purposes. Learn how OLTP and OLAP apply to real examples and how each process applies.

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
1 3 4 5 6 7 15