Learn how to interact with relational databases in Python with SQLAlchemy.
The need to interact with SQL databases using Python is relatively common across multiple industries. SQLAlchemy is a module designed to provide better developer ergonomics for database access and interactions.
Learning Objectives
Explore the SQLAlchemy APIs: core and ORM.
At the end of this lab you'll be familiar with:
- The core API
- The ORM API
- Mapped classes / objects
- ORM Relationships
Prerequisites:
- Proficient with the Python runtime
- Proficient with the Python language syntax
- Familiar with relational databases
- Familiar with SQL syntax
- Familiar with the Python DBAPI v2.0
Target Audience
- Python Developers
Updates
August 23rd, 2023 - Updated docker image to run lab_init.sh
April 19th, 2023 - Updated theia to enable autosave
November 30th, 2022 - Added a solutions step
Ben Lambert is a software engineer and was previously the lead author for DevOps and Microsoft Azure training content at Cloud Academy. His courses and learning paths covered Cloud Ecosystem technologies such as DC/OS, configuration management tools, and containers. As a software engineer, Ben’s experience includes building highly available web and mobile apps. When he’s not building software, he’s hiking, camping, or creating video games.