SQL

Configure relational databases, brush up on your query language syntax, or find third-party services to interact with your data.

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.

Database in a lab

Databases in Python Made Easy with SQLAlchemy

Leverage the iconic SQLAlchemy Python library to effortlessly handle database connections and queries in software.

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.

A Dirty Way of Cleaning Data (ft. Pandas & SQL)

A Dirty Way of Cleaning Data (ft. Pandas & SQL)

Cleaning data in Pandas the dirty way.

Connecting Pandas to a Database with SQLAlchemy

Connecting Pandas to a Database with SQLAlchemy

Save Pandas DataFrames into SQL database tables, or create DataFrames from SQL using Pandas' built-in SQLAlchemy integration.

Using PyMySQL: Python's MySQL Library

Using PyMySQL: Python's MySQL Library

Connect and fetch records from a MySQL Database using Python's lightweight PyMySQL library.

Accessing Self-Hosted MySQL Externally

Accessing Self-Hosted MySQL Externally

Configure a self-installation of MySQL on Ubuntu to allow access from external sources, such as SequelPro or other GUIs.

Setting up a MySQL Database on Ubuntu

Setting up a MySQL Database on Ubuntu

Setting up MySQL the old-fashioned way: on a Linux server.