Databases

Learn about the difference between Cassandra and MongoDB. These NoSQL databases have some similarities, but many more differences. Examine these factors and decide which database is better for you.

Elasticsearch is an open-source engine that enhances searching, storing and analyzing capabilities of your computing environment. Follow the steps in this tutorial to install Elasticsearch on your Ubuntu machine.

The article provides many images that guide you through each individual step of a MySQL installation on Windows. The elaborate setup is made easy with clear instructions and concise descriptions of each particular option.

This Spark tutorial shows how to get started with Spark. The guide covers the procedure for installing Java, Git, Scala, how to verify the installed dependencies, as well as the detailed procedure for installing Spark. The article contains the basic start and stop commands for master and slave servers.

This article explores several highly efficient methods that allow you to export a MySQL table as a CSV file. As a CSV file, the data from your tables becomes much more accessible, both to humans and a host of other applications.

Once you install MariaDB, one of the first things you need to do is to create a new MariaDB user. This article explains how to create a MariaDB user, and then how to grant privileges to the newly created user.

Learn how to export a PostgreSQL table to a .csv file. This feature is especially helpful when transferring the table to a different system or importing it to another database application. The guide shows you how to use either the COPY or the /copy command to export PostgreSQL databases and columns as .csv files.

Save time and effort by managing different database systems with a single tool. Find out how to set up SQL Workbench to connect to a PostgreSQL database with four (4) easy steps. Use SQL Workbench to migrate data between your databases without the need to use several concurring interfaces.

Learn how to find the duplicate entries in your MySQL databases. The guide shows you how to use the GROUP BY, COUNT() HAVING, and INNER JOIN functions to locate the duplicate entries.

This tutorial shows you how to use Docker and an official MongoDB container image to deploy your databases. Additionally, it covers basic commands that allow you to interact with the MongoDB client effectively.