Databases

How to Repair MySQL Database

August 5, 2021

A corrupt database can happen at any moment. Try some of these methods to repair your MySQL database quickly.

Read more

How to Fix 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

August 3, 2021

MySQL is the most popular open-source relational database management system. This tutorial will help you identify and fix the cause of the 'can't connect to local MySQL server through socket' error.

Read more

PostgreSQL Data Types

July 29, 2021

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.

Read more

Best Database Management Software - Top 25 Software

July 21, 2021

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

Read more

RDD vs. DataFrame vs. Dataset


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.

Read more

How to Create a Spark DataFrame


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.

Read more

How to Install SQL Server on MacOS

July 13, 2021

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.

Read more

How to Install SQL Server on Linux

July 8, 2021

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.

Read more

How to Install SQL Server on Windows 10

July 1, 2021

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.

Read more

How to Download and Install PostgreSQL on Windows

June 29, 2021

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.

Read more