hands-on lab

Python: Introduction to SQLAlchemy

Difficulty: Advanced

Duration: Up to 2 hours

Students: 115

Rating: 5/5

Start lab

On average, students complete this lab in45m

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.

About

Author

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

Development

Python

Hands-on Lab UUID

Lab steps

0 of 7 steps completed.Use arrow keys to navigate between steps. Press Enter to go to a step if available.

Web IDE Review
Core API
ORM API
Mapped Classes / Objects
Relationships
Summary
Solutions

Lab Rules

Lab rules apply