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.

Todd Birchard
Todd Birchard
SQL
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.

Todd Birchard
Todd Birchard
SQL
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.

Todd Birchard
Todd Birchard
SQL
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.

Todd Birchard
Todd Birchard
SQL
Psycopg2: PostgreSQL & Python the Old Fashioned Way

Psycopg2: PostgreSQL & Python the Old Fashioned Way

Connect to a PostgreSQL database and execute queries in Python using the Psycopg2 library.

Todd Birchard
Todd Birchard
PostgreSQL
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.

Todd Birchard
Todd Birchard
Google Cloud