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
Extract and move data between BigQuery and relational databases using PyBigQuery: a connector for SQLAlchemy.
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.
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.
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.
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.
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.
