Home >>> Courses >>> Special Topics >>> Camelot

What customers say ...

The Python Summer Course was a very good opportunity to know almost all about Python. ... Highly recommended!!

Dr. Fabio Lamanna, Complex Transportation Networks, Trieste, Italy more...

[The trainer] knows well what scientists need, so his hints are very practical and valuable. The hands-on course [..] covers a wide range of examples and will be very helpful in my daily work. ..

Dorota Jarecka, University of Warsaw, Poland about the course "Python for Scientists and Engineers" more...

The standard Python for programmers and the customized "Python for Experts" course where a great success. ..

Bart Hillaert, Alcatel-Lucent, Belgium more...

Mike is an outstanding teacher ... I will look for his classes in the future.

Jennifer Trasti, Software/Systems Engineer, Sandia National Laboratories, Albuquerque, NM, USA 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...

Camelot 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


Camelot is a framework for developing desktop database applications at warp speed. It is to desktop applications what Django is to web applications. Some see it as a replacement for MS Access, but its tight integration with SQLAlchemy enables a vast amount of more advanced features and possibilities.

This tutorial style course will enable you to get started with your own Camelot project. We will tackle the hurdles met when going through the lifecycle of a desktop application

Course Content

First Example

We start our little Camelot project, have a look at the concepts and terminology used within Camelot. We go through the different parts of the application and look at the possibilities to customize them.

Declarative Models and Views

Then we move on by defining a relational model and use introspection together with a declarative definition of our view to generate table and form views. We look at the various options that can be used to create and reuse form and table definitions.

Actions and Reports

Next we'll dive into the details of actions the user can trigger, we discuss and experiment with the standard actions Camelot offers. One of those actions can be the generation of a nicely formatted Word document.

Advanced Model Definition

Once an application grows, more advanced model definition is needed. We will try out some advanced features of SQLAlchemy and see how they interact with the graphical interface.

Fine tuning of the GUI

Here we have a look at how Qt's model-view-delegate framework works and how it is used by Camelot. This will enable us to fully customize the graphical interface to our needs.

Deployment and Users

The last step of the development process is getting the application to the users. We will discuss the deployment options and list the things to be aware of when submitting an application to its users.

Q & A

Throw all Camelot questions you have in the group and try to resolve them together.

Course Duration

1 day


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.

Intended Audience

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.
  • The SQLAlchemy course is not mandatory, but is strongly recommended
  • QT or PyQt knowledge is not needed

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

[PyCon Montréal 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]


The next open cousers
details ...

Python Academy sponsors EuroPython conference 2013
details ...

Python Academy sponsors EuroSciPy conference 2013
details ...

Python Academy sponsors Python BarCamp in Cologne
details ...

Next Meeting of Leipzig Python User Group, November 12, 2013
details ...

Introduction to Django, November 11 - 13, 2013
details ...

Professional Testing with Python, November 25 - 27, 2013
details ...

Advanced Django, January 13 - 15, 2014
details ...

Python Academy sponsors PyCon US conference 2013
details ...

Python Academy founder receives PSF Community Service Award
details ...