SQL Blog

Setting up PostgreSQL & pgAdmin

July 4th, 2021 by boxplotanalytics

What’s the difference between PostgreSQL and pgAdmin? PostgreSQL is a free-to-use relational database management system (DBMS); pgAdmin is a graphical user interface (GUI) tool that lets users interact with their PostgreSQL database(s). In other words, PostgreSQL is the actual database system, and pgAdmin is a tool that lets users use that system. How do I […]

Read More


Using DB Browser for SQLite

September 1st, 2019 by boxplotanalytics

DB Browser for SQLite (it’s also called SQLite Browser for short) is an excellent tool for practicing SQL without having to get connected to a real live server. This post will walk through how to install, open, and use SQLite Browser. Install SQLite Browser Go to the SQLite Browser website and choose the download for […]

Read More


Understanding JOINs in SQL

September 1st, 2019 by boxplotanalytics

Joins in SQL Joins are one of the most important (if not THE most important) concepts in SQL. If you take the time to solidly understand how joins work, you’ll be in an excellent place for writing queries. So, let’s dive in! Join Definitions Joining tables in SQL is a way of combining them. It […]

Read More


Understanding Multiple JOINs in SQL

September 1st, 2019 by boxplotanalytics

Multiple joins are one of the toughest SQL concepts – in this post we’ll decode them and review some common pitfalls. One of the best ways to learn is with an example. If you’d like to follow along, you can download this zip file that contains the three tables as .csv files here, and import […]

Read More


What is SQL?

August 31st, 2019 by boxplotanalytics

What is SQL? Currently, if you Google this question, you’ll get a whole slew of technical articles that aren’t very helpful for understanding just what SQL is and when people use it. We’ll break that down in this blog post. This is a high level overview – if you want to understand how to actually […]

Read More