SQL Blog
Setting up PostgreSQL & pgAdmin
July 4th, 2021 by BoxplotWhat’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 […]
Using DB Browser for SQLite
September 1st, 2019 by BoxplotDB 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 […]
Understanding JOINs in SQL
September 1st, 2019 by BoxplotJoins 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 […]
Understanding Multiple JOINs in SQL
September 1st, 2019 by BoxplotMultiple 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 […]
What is SQL?
August 31st, 2019 by BoxplotWhat 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 […]
