Advanced

Databases with SQLite and SQLAlchemy

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

  • 4.8/5.0
  • 2817 enrolled
  • Advanced
  • French
Course Description

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

--

Edson Bitjoka

Edson Bitjoka

Developer & Instructor

About the instructor

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

Student reviews
Théo Morel
Théo Morel

4 days ago

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

Frequently asked questions

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.
Databases with SQLite and SQLAlchemy
Online course: 25 € / hour
In-person course: 35 € / hour

This course includes

  • Chapters 14
  • Duration 9h
  • Level Advanced
  • Language French
  • Unlimited access Yes
  • Certificate Yes