hands-on lab
Python: Introduction to SQLAlchemy
Difficulty: Advanced
Duration: Up to 2 hours
Students: 89
Rating: 5/5
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.
Description
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
Covered topics
Lab steps
Web IDE Review
Core API
ORM API
Mapped Classes / Objects
Relationships
Summary
Solutions