Connect to a PostgreSQL database and execute queries in Python using the Psycopg2 library.
Leverage the iconic SQLAlchemy Python library to effortlessly handle database connections and queries in software.
Create a database in Google Cloud using Cloud SQL, compare Cloud SQL to RDS, and learn the admin API.
Cleaning data in Pandas the dirty way.
Save Pandas DataFrames into SQL database tables, or create DataFrames from SQL using Pandas' built-in SQLAlchemy integration.
Connect and fetch records from a MySQL Database using Python's lightweight PyMySQL library.
Configure a self-installation of MySQL on Ubuntu to allow access from external sources, such as SequelPro or other GUIs.
Setting up MySQL the old-fashioned way: on a Linux server.