Home >>> Courses >>> SQLAlchemy

What customers say ...


Very good course, excellent content. Does require a strong python background which I lacked so perhaps my experience was not typical. Still I learned a very great deal.

Keith Bord, Oracle about the course "Advanced Python" more...


Highly recommended. Many aha-experiences and took home many positive inspiratons.

Helmut Dittrich, CEO DiFis-Engineering UG, arrow-fix.com, about the German introduction to Django "Django für Fortgeschrittene" more...


Very good introduction to the programming language.

Matthias Enderle, freelancer programmer about the German version of the course "Python for Programmers" more...


I highly recommend these courses. The trainer is superb.

Dr. Kai Irschik, Ocean Breeze Energy GmbH & Co. KG about the courses "Python for Programmers" and "Python for Scientists and Engineers" more...


Dr. Müller is (a) very good teacher .. (I) would highly recommend this course and also Dr. Müller for this course.

Dhiraj Surve, Suzlon.com about the course "Python for Programmers" more...


SQLAlchemy Course

Dates for Open Courses

Course available as open and in-house training. Currently no dates for open courses. Please ask us at info@python-academy.de

Motivation

SQLAlchemy is THE object relational mapper used in the Python world. 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.

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.

Course 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 all source codes and used software.

Intended Audience

Programmers with basic Python knowledge or after taking other courses such as Python for Programmers .

Prerequisites

  • Basic knowledge of Python and object oriented programming is required. If you don't know Python it is strongly recommended to take Python for Programmers before this course.
  • Basic knowledge of SQL is necessary.
[Follow @pyacademy]

The Python Academy is sponsor of PyCon.DE 2019.

[PyCon.DE  2019]

The Python Academy is sponsor of PyCon LT 2019.

[PyCon LT 2019]

The Python Academy is sponsor of PyCon US 2019.

[PyCon US 2019]

Our Partners

Partner Coding Akademie


[Coding Akademie]
------------

The Python Academy is sponsor of PythonCamp Köln 2019.

[PythonCamp 2019]

The Python Academy is sponsor of PythonCon Nambia 2019.

[PythonCon Nambia 2019]

The Python Academy is sponsor of PyConIE 2018.

[PyConIE 2018]

The Python Academy is sponsor of PyCon.DE 2018.

[PyCon.DE  2018]

The Python Academy is sponsor of PyCon Spain 2018.

[PyCon ES 2018]

The Python Academy is sponsor of PyCon Ghana 2018.

[PyCon GH 2018]

The Python Academy is sponsor of EuroPython 2018.

[EuroPython 2018]

The Python Academy is sponsor of DjangCon Europe 2018.

[DjangCon Europe 2018]

The Python Academy is sponsor of PyCon US 2018.

[PyCon US 2018]

The Python Academy is sponsor of PythonCamp Köln 2018.

[PythonCamp 2018]

The Python Academy is sponsor of PyConIE 2017.

[PyConIE 2017]

The Python Academy is sponsor of EuroPython 2017.

[EuroPython 2017]

The Python Academy is sponsor of PyCon US 2017.

[PyCon US 2017]

The Python Academy is sponsor of PythonCamp Köln 2017.

[PythonCamp 2017]

The Python Academy is sponsor of Django Girls Leipzig 2016

[Django Girls Leipzig 2016]

The Python Academy is sponsor of PyCon DE 2016.

[PyCon DE 2016]

The Python Academy is sponsor of PyCon Ireland 2016.

[PyCon IE 2016]

The Python Academy is sponsor of EuroSciPy 2016.

[EuroSciPy 2016]

The Python Academy is sponsor of PyCon US 2016.

[PyCon US 2016]

The Python Academy is sponsor of PyData Berlin 2016.

[PyData Berlin 2016]

The Python Academy is sponsor of PyCon Sweden 2016.

[PyCon SE 2016]

The Python Academy is sponsor of Python Unconference 2015.

[PyUnconf 2015]

The Python Academy is sponsor of EuroSciPy 2015.

[EuroSciPy 2015]

The Python Academy is sponsor of EuroPython 2015.

[EuroPython 2015]

The Python Academy is sponsor of PyData Berlin 2015.

[PyData Berlin 2015]

The Python Academy is sponsor of PyCon Montréal 2015.

[PyCon Montréal 2015]

The Python Academy is sponsor of Python BarCamp Köln 2015.

[Python BarCamp 2015]https://www.euroscipy.org/2016/

The Python Academy is sponsor of Chemnitzer Linux-Tage 2015.

Chemnitzer Linux-Tage 2015 - 21. und 22. März 2015

The Python Academy is sponsor of Django Girls Wroclaw 2015.

[Django Girls Wroclaw 2015]

The Python Academy is sponsor of PyCon Ireland 2014.

[PyCon Ireland 2014]

The Python Academy is sponsor of EuroSciPy 2014.

[EuroSciPy 2014]

The Python Academy is sponsor of PyData London 2014.

[PyData London 2014]

The Python Academy is sponsor of EuroPython 2014.

[EuroPython 2014]

The Python Academy is sponsor of PyCon 2014 Montréal.

[PyCon 2014 Montréal]

The Python Academy is sponsor of Python BarCamp Köln 2014.

[Python BarCamp 2014]

The Python Academy is sponsor of PyConDE 2013.

[PyCon DE 2013]

The Python Academy is sponsor of EuroPython 2013.

[EuroPython 2013]

The Python Academy is sponsor of PyCon US 2013.

[PyCon US 2013]

The Python Academy is sponsor of EuroSciPy 2013.

[EuroSciPy 2013]

The Python Academy is sponsor of PyConPL 2012.

[PyCon PL 2012]