Database Programming with SQLAlchemy
Course Content¶
Get to know SQLAlchemy¶
We will start with an overview of the terminology used in SQLAlchemy, such as drivers, connectors, engines, metadata, sessions, tables and mappers.
Simple statements¶
An overview of how the basic SQL statements can be generated from SQLAlchemy and how SQLAlchemy can simplify our life when we need to write those statements.
Simple ORM¶
Set up an object relational mapping and experiment with the life cycle an object goes through when it is mapped by SQLAlchemy to the database. This can be be done using plain SQLAlchemy or Declarative or Elixir.
SQLAlchemy Philosophy¶
Next we need to understand a bit of the philosophy behind SQLAlchemy and to study its different usage patterns. Know what is possible with SQLAlchemy and where to look for in its documentation. This will help us when being faced with more advanced topics.
Advanced statements¶
See how SQLAlchemy allows us to keep even advanced database usage reasonably simple and experience the true power of SQLAlchemy.
ORM and relations¶
Experience how relations between mapped objects behave and look at the options both the database and SQLAlchemy offer.
Advanced ORM¶
Experiment with non trivial mapping issues, such as inheritance, arbitrary selects and arbitrary relations. In this part we will also study the use of transactions in combination with the ORM.