What customers say ...
Good course. Very fast progress without any prior Python knowledge.
Daniel Fuchs, GIGATRONIK Ingolstadt GmbH,
about the German version of the course "Python for Programmers"
more ...
Very nice course, got many useful suggestions.
Dr.-Ing. Ralf Wieland, Institut für Landschaftssystemanalyse,
Leibniz-Zentrum für Agrarlandschaftsforschung e.V.
about the German version of the course "Python for Scientists and Engineers"
more ...
Mike is an outstanding teacher ... I will look for his classes in the future.
Jannifer Trasti, Software/Systems Engineer, Sandia National Laboratories, Albuquerque, NM, USA
more ...
The Python Summer Course was a very good opportunity to know almost all
about Python. ... Highly recommended!!
Fabio Lamanna, Ph.D. Complex Transportation Networks, Trieste, Italy
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 Zurich, Switzerland
more ...
I can absolutely recommend this course to everybody who wants become productive
with Python very quickly. ...
Dr. med. Beat Meister, Bern, Switzerland
more ...
The standard Python for programmers and the customized "Python for Experts"
course where a great success. ...
Bart Hillaert, Alcatel-Lucent Belgium
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 about the course
"Python for Scientists and Engineers"
more ...
The course "Python for Scientists and Engineers" is a very useful
introduction to Python programming for scientific applications ...
Dr Mihai Duta, Oxford Supercomputing Centre
more ...
Very good introduction to the programming language.
Matthias Enderle, freelancer programmer
more ...
SQLAlchemy Course
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 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 .
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 nessary.
The Python Academy is sponsor of PyCon US 2012.
News
Python Academy founder receives PSF Community Service Award
details ...
Course: "Python for Scientists and Engineers" (English) in Chicago (USA) February 28 - March 2, 2012
details ...
Tutorial: "Faster Python Programs through Optimization" (English) in Santa Clara (USA) March 7 at PyCon US 2012
details ...
Tutorial: "Plotting with matplotlib" (English) in Santa Clara (USA) March 8 at PyCon US 2012
details ...
Presentation: "Python and HDF5 - Fast Storage for Large Data" (Englisch) in Santa Clara (USA) March 10 at PyCon US 2012
details ...
Next Meeting of Leipzig Python User Group, March 20, 2012
details ...
Course: "Python für Programmierer" (German) in Leipzig April 16 - 18, 2012
details ...
Course: "Python für Wissenschaftler und Ingenieure" (German) in Leipzig April 19 - 21, 2012
details ...
Course: "Einstieg in Django" (German) in Leipzig April 23 - 25, 2012
details ...
Course: "Django für Fortgeschrittene" (German) in Leipzig April 26 - 27, 2012
details ...
Python for Programmers (English) in Leipzig June 5 - 7, 2012
details ...
Python Power Course (English) in Leipzig June 8 - 15, 2012
details ...
Advanced Python (English) in Leipzig June 8 - 10, 2012
details ...
High-Performance Computation with Python (English) in Leipzig June 11 - 15, 2012
details ...