Conan Mercer Applied Scientist
PostgreSQL - Selects
25 May 2021 - Conan Mercer
MotivationThis 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.