SQL
Configure relational databases, brush up on your query language syntax, or find third-party services to interact with your data.
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.
Manage Database Models with Flask-SQLAlchemy
Connect your Flask app to a database using Flask-SQLAlchemy.
From CSVs to Tables: Infer Data Types From Raw Spreadsheets
The quest to never explicitly set a table schema ever again.
Psycopg2: PostgreSQL & Python the Old Fashioned Way
Manage PostgreSQL database interactions in Python with the Psycopg2 library.
Pythonic Database Management with SQLAlchemy
The iconic Python library for handling any conceivable database interaction.
PostgreSQL Cloud Database on Google Cloud
Deep Dive into Cloud SQL and its out-of-the-box API.
A Dirty Way of Cleaning Data (ft. Pandas & SQL)
Cleaning data in Pandas the dirty way.
Lynx Roundup, July 14th
Blockchain algos, SQL Cheat Sheet, Convex Optimization.
