Join Tables in Postgres with Python

Introduction In this article, we will learn how to join tables in Postgres using Python to write the SQL. During this tutorial, we’ll use the following structure: What? What does a table join in PostgreSQL do and what is the syntax? How? How, why, and when do we best use the JOIN clause in our … Continued

Normalize Postgres Database with Foreign Keys

Introduction In this article we will learn to normalize a Postgres database with foreign keys (one-to-many relationships). Before relational databases were developed, we stored data much like you see in spreadsheets, where you typically have duplicate data like customer names for example. Imagine a table called “orders” that has a row for every order. If … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.