Databases

SQL Server is Microsoft's proprietary system for managing relational databases, but it's also available on Linux. In this tutorial, learn how to install SQL Server 2019 on Ubuntu or CentOS/RHEL.

SQL Server is Microsoft's solution for creating and managing SQL databases. This tutorial takes you through the step-by-step process of installing SQL Server on Windows.

PostgreSQL is one of the most popular relational database management systems available today. This tutorial offers a step-by-step guide to installing PostgreSQL on Windows.

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.

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.

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.

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.

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.

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.

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.