Conan Mercer Applied Scientist

PostgreSQL - Selects

25 May 2021 - Conan Mercer


This Jupyter Notebook is the first in my series on PostgreSQL. The goal is to become familiar with the basic and more advanced forms of the Structured Query Language (SQL), with particular focus on Data Science applications. This guide uses a sample database called dvdrental, a common resource used to learn PostgreSQL, it can be downloaded from here.

This Jupyter Notebook also resides on my GitHub - it can be viewed from here


This post introduced the SELECT statement in PostgreSQL along with primary and foreign keys and their importance in relational database theory.
In the future I will be writing about more advanced SQL topics such as query tuning and performance optimization.