PostgreSQL (page 1)
Our preferred relational database of choice which deserves more love. Learn the advantages that PostgreSQL provides over closed-source competitors.
SQL
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
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
Welcome to SQL 2: Selecting, Updating, and Deleting Data
Explore the many flavors of SQL data manipulation in part 2 of our series.
SQL
Welcome to SQL: Modifying Databases and Tables
Brush up on SQL fundamentals such as creating tables, schemas, and views.
PostgreSQL
Psycopg2: PostgreSQL & Python the Old Fashioned Way
Connect to a PostgreSQL database and execute queries in Python using the Psycopg2 library.
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.