SQLAlchemy Training

SQLAlchemy is THE the library to use in the Python world when interacting with databases. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.
This practical course will make sure you understand the concepts behind SQLAlchemy. We will focus on practical patterns of SQLAlchemy usage and see how its use can grow from very simple to more advanced.

Intended Audience

This course is for programmers who need to interact with databases, either in web applications, desktop applications or enterprise applications.  Basic knowledge of SQL and Python is necessary.  The  Python for programmers training is recommended if you want to get up to speed on Python.

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 Models : Set up an object model and map it to a relational database, experiment with the life cycle an object goes through when it is mapped by SQLAlchemy to the database. We will cover both plain SQLAlchemy and Declarative.
  
• 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.
  
• Advanced models 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.
• Integration : how to integrate SQLAlchemy within web applications and desktop applications.
  

Duration

1 day

Exercises

The participants can follow all steps directly on their computers. There are exercises at the end of each unit providing ample opportunity to apply the freshly learned knowledge.

Course material

Every participant receives comprehensive printed materials that cover the whole course content as wells as a CD with all source codes and used software.

Prices

Prices can be found here.

Subscription

Either send an e-mail to info@conceptive.be or visit the Python Academy Website.