Intro to JOINS in SQL

Reading Time: 5 minutes

In this article, we will learn the basics of joining tables in SQL. We will learn about Left, Right, Inner, and Outer joins and give examples of how to use them.

Data in an RDBMS (Relational Database Management System) is grouped into tables. These tables have a rigid definition of the type of data that can be stored in them. To connect different tables, and thus different types of data that may relate to each other, we will use the JOIN clause. 

Continue reading “Intro to JOINS in SQL”

How to Install SQuirrel SQL Client

Reading Time: 3 minutes

In this article, we will discuss what the SQuirreL SQL Client is, some of its features, the supported database types, and how to install the client.

What is SQuirreL SQL Client?

The SQuirreL SQL Client is an open-source, graphical Java database administration tool that will allow you to review the structure of a JDBC compliant database, browse the data in tables, and issue SQL commands.

Continue reading “How to Install SQuirrel SQL Client”