What customers say ...
Mike is a great professor. He has an amazing knowledge of Python. It has been a pleasure to be his student for 3 days!
David Doblas about the course "Python for Scientists and Engineers" more...
Good content, thorough explanation, and practice sessions. It will be useful in my day-to-day work. Thank you, Mike!!
Ameya Tipnis, QSpin Vlaanderen bvba about the course "Python for Programmers" more...
We had a wide range of Python experience in our group and each person gained something valuable to take away....
Dr. Ryan Woodard, Chair of Entrepreneurial Risks, ETH ETH Zurich, Switzerland more...
Good course. Very competent trainer for this introduction. The course offers wide spectrum of topics and goes into depth were participants need it most.
Helmut Dittrich, CEO DiFis-Engineering UG, arrow-fix.com, about the German introduction to Django "Einstieg in Django" more...
Very competent trainer. Highly recommended training.
Raout Femmali, German Aerospace Stuttgart about the course "Python für Programmierer und Python für Wissenschaftler und Ingenieure" more...
Dates for Open Courses
Course available as open and in-house training. Currently no dates for open courses. Please ask us at email@example.com
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.
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.
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.
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.
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.
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.
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.
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.
Every participant receives comprehensive printed materials that cover the whole course content as wells as a CD with all source codes and used software.
Programmers with basic Python knowledge or after taking other courses such as Python for Programmers .
- 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.
The Python Academy is sponsor of Python Unconference 2015.
The Python Academy is sponsor of EuroSciPy 2015.
The Python Academy is sponsor of EuroPython 2015.
The Python Academy is sponsor of PyData Berlin 2015.
The Python Academy is sponsor of PyCon Montréal 2015.
The Python Academy is sponsor of Python BarCamp Köln 2015.
The Python Academy is sponsor of Chemnitzer Linux-Tage 2015.
The Python Academy is sponsor of Django Girls Wroclaw 2015.
The Python Academy is sponsor of PyCon Ireland 2014.
The Python Academy is sponsor of EuroSciPy 2014.
The Python Academy is sponsor of PyData London 2014.
The Python Academy is sponsor of EuroPython 2014.
The Python Academy is sponsor of PyCon 2014 Montréal.
The Python Academy is sponsor of Python BarCamp Köln 2014.
The Python Academy is sponsor of PyConDE 2013.
The Python Academy is sponsor of EuroPython 2013.
The Python Academy is sponsor of PyCon US 2013.
The Python Academy is sponsor of EuroSciPy 2013.
The Python Academy is sponsor of PyConPL 2012.
The next open cousers
Python Academy sponsors EuroPython conference 2013
Python Academy sponsors EuroSciPy conference 2013
Python Academy sponsors Python BarCamp in Cologne
Next Meeting of Leipzig Python User Group, November 12, 2013
Introduction to Django, November 11 - 13, 2013
Professional Testing with Python, November 25 - 27, 2013
Advanced Django, January 13 - 15, 2014
Python Academy sponsors PyCon US conference 2013
Python Academy founder receives PSF Community Service Award