Databases with SQLite and SQLAlchemy

Store and manage your data efficiently! Learn to interact with relational databases in Python.

Store and manage your data efficiently! Learn to interact with relational databases in Python.

What is a database?

Discover SQLite (lightweight, local)

Create a table and insert data

Read, filter, update records

Example: manage a book list

Challenge: find a book by title

Why use an ORM?

Define a model in Python

Workshop: create a user database with SQLAlchemy

Developer & Instructor

I teach you to store, query, and manage data professionally. SQL and ORM will be second nature!

4 days ago

SQLAlchemy is awesome! My code is much cleaner than with raw SQL.

ORM for fast development and maintainability. Raw SQL for extreme performance or very complex queries.

Yes! SQLAlchemy supports PostgreSQL, MySQL, etc. Just change the connection string.

01 ORM vs raw SQL—which to choose?