Databases

As a relational database management system, PostgreSQL offers a variety of data types for users to work with. This tutorial covers the different built-in data types available in PostgreSQL.

A DBMS facilitates data manipulation and provides an additional security layer for your database. This article lists the 25 best database management systems.

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.

Spark DataFrames are an essential part of working with data in Spark. Learn how to create DataFrames from scratch in this easy to follow tutorial.

Microsoft's SQL Server 2019 supports Windows 10, Linux, macOS, and Docker as install options. This tutorial takes you through the process of installing SQL Server on macOS as a Docker deployment.

Database security involves all aspects of security. Many unwanted database breaches and information compromises are avoidable when sticking to the best security practices. Learn how you can best secure your data to avoid disasters.

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.