PostgreSQL

Our preferred relational database of choice which deserves more love. Learn the advantages that PostgreSQL provides over closed-source competitors.

Welcome to SQL 4: Aggregate Functions

Welcome to SQL 4: Aggregate Functions

Become more intimate with your data- use SQL's aggregate functions to explore the traits which make your data unique and beautiful.
SQL
7 min read
March 14
Welcome to SQL 3: Building Relations and Combining Data Sets

Welcome to SQL 3: Building Relations and Combining Data Sets

This week we look at the fun side of SQL where we JOIN tables and create UNIONs.
SQL
10 min read
February 26
Welcome to SQL 2: Selecting, Updating, and Deleting Data

Welcome to SQL 2: Selecting, Updating, and Deleting Data

Explore the many flavors of SQL data manipulation in part 2 of our series.
SQL
7 min read
February 22
Welcome to SQL: Modifying Databases and Tables

Welcome to SQL: Modifying Databases and Tables

Brush up on SQL fundamentals such as creating tables, schemas, and views.
SQL
10 min read
February 19
Psycopg2: PostgreSQL & Python the Old Fashioned Way

Psycopg2: PostgreSQL & Python the Old Fashioned Way

Manage PostgreSQL database interactions in Python with the Psycopg2 library.
PostgreSQL
5 min read
January 15
Cloud SQL: Relational Databases on Google Cloud

Cloud SQL: Relational Databases on Google Cloud

Create a database in Google Cloud using Cloud SQL, compare Cloud SQL to RDS, and learn the admin API.
Google Cloud
6 min read
August 10