SQL

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

Simplify BigQuery ETL jobs using SQLAlchemy

Simplify BigQuery ETL jobs using SQLAlchemy

Extract and move data between BigQuery and relational databases using PyBigQuery: a connector for SQLAlchemy.

Todd Birchard
Todd Birchard
Data Warehouses
Define Relationships Between SQLAlchemy Data Models

Define Relationships Between SQLAlchemy Data Models

Using the SQLAlchemy ORM to build data models with meaningful relationships. Create one-to-one, one-to-many, many-to-one, and many-to-many relationships.

Todd Birchard
Todd Birchard
SQLAlchemy
Welcome to SQL 4: Aggregate Functions

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.

Todd Birchard
Todd Birchard
SQL
Welcome to SQL 3: Building Relations and Combining Data Sets

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.

Todd Birchard
Todd Birchard
SQL
Welcome to SQL 2: Selecting, Updating, and Deleting Data

Welcome to SQL 2: Selecting, Updating, and Deleting Data

Explore the many flavors of SQL data manipulation in part 2 of our series.

Todd Birchard
Todd Birchard
SQL
Welcome to SQL: Modifying Databases and Tables

Welcome to SQL: Modifying Databases and Tables

Brush up on SQL fundamentals such as creating tables, schemas, and views.

Todd Birchard
Todd Birchard
SQL
Connect Flask to a Database with Flask-SQLAlchemy

Connect Flask to a Database with Flask-SQLAlchemy

Interact with a database within Flask using Flask-SQLAlchemy. Learn to create, fetch, and manage database records via SQLAlchemy ORM.

Todd Birchard
Todd Birchard
Flask
Queries as Python Code with SQLAlchemy's Expression Language

Queries as Python Code with SQLAlchemy's Expression Language

Work with your app's data entirely in Python by defining data models and using the session object from SQLAlchemy's ORM.

Todd Birchard
Todd Birchard
SQLAlchemy