SQL Blog

SQL & Databases

May 5th, 2022 by Victoria Canizales

As your organization’s data competency grows, so too does the quantity of data it needs to store. If you currently store all of your data on Excel spreadsheets, Google Sheets, or other similar storage tool, you may be noticing that a weakness of such files is that it doesn’t scale; more specifically, it feels clumsy […]

Read More


Setting up PostgreSQL & pgAdmin

July 4th, 2021 by Victoria Canizales

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 Victoria Canizales

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 Victoria Canizales

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 Victoria Canizales

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 Victoria Canizales

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