Skip to main content

Teaching

During my doctoral studies at Paris-Cité University and the École Normale Supérieure, I taught a variety of subjects (such as programming, algorithms, networks, databases, etc.). During my postdoctoral fellowship in Prague, I taught advanced courses in combinatorics and graph theory at Charles University. Please contact me if you would like the corresponding materials.

I also served as a coach at the École Normale Supérieure Paris-Saclay for European university algorithmics competitions, preceding the excellent Jill-Jenn! In the future, the goal is to hold training sessions in the Paris area; contact me if you’re interested.

Database at Melun
#

In 2025–2026, I am the professor for the Database course at Université Paris-Panthéon-Assas. You can find my course materials here:

And the corresponding tutorial sheets:

Solutions :

To practice SQL at home, I recommend SQLiteonline. Some files that may be useful for the tutorials:

Information on the Second Exam
#

The exam will be held during your tutorial session for the week of Monday, April 13, in the usual tutorial room, at the time of your tutorial. We strongly recommend that you take it during your official tutorial time slot: since the tutorial room is small, you may find yourself without a seat on the day of the exam, in which case priority will be given to students officially registered for that tutorial.

The exam will last one hour and fifteen minutes. It will cover MySQL, Access, relational algebra, and entity-relationship models, in roughly equal proportions. You can familiarize yourself with the ACCESS database here.

No reference materials are permitted.

If you have been granted extra time by the Relais Handicap Santé, you must inform the lab instructor in advance via email, along with the corresponding supporting documents.

Information about the first test
#

The test will take place during your tutorial session in the week of Monday, March 9, in the usual tutorial room, at the time of your tutorial. We strongly advise you to take it during your official tutorial slot: since the tutorial room is small, you may not find a seat on the day of the test. In that case, priority will be given to students officially registered in the corresponding tutorial group.

The test will last one hour and fifteen minutes. It will mainly involve SQL, with a small amount of Excel.

You can familiarize yourself with the SQL database here.

No documents are allowed.

If you are granted extra time accommodations by the Relais Handicap Santé, you must inform the tutorial instructor in advance by email, including the appropriate supporting documents.

Guillaume Aubian Guillaume Aubian
Author
Guillaume Aubian
A computer science and math enthusiast!