PostgreSQL (page 1)
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
Become more intimate with your data- use SQL's aggregate functions to explore the traits which make your data unique and beautiful.
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.
Welcome to SQL 2: Selecting, Updating, and Deleting Data
Explore the many flavors of SQL data manipulation in part 2 of our series.
Welcome to SQL: Modifying Databases and Tables
Brush up on SQL fundamentals such as creating tables, schemas, and views.
Psycopg2: PostgreSQL & Python the Old Fashioned Way
Connect to a PostgreSQL database and execute queries in Python using the Psycopg2 library.
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.