Databases
Technical Aspects of Databases
I taught tutorials and practical courses about the technical aspects of databases to Master 1 students. The subjects include relational algebra, SQL, indexation, and optimizations.
- Master 1 students:
- 8 hours of tutorials in 2020-2021.
- 8 hours of practical courses in 2020-2021.
Large-scale Data Processing
I taught practical courses about large-scale data processing to Master 1 and Master 2 students. They concern the following data processing tools: Neo4J, Apache Hadoop, and Apache Spark. I taught similar practical courses to third year students of the ESIR engineering school, which included a mini-project on the analysis of a dataset chosen by the students.
- Master 1 and 2 students:
- 20 hours of practical courses in 2018-2019.
- 18 hours of practical courses in 2019-2020.
- 20 hours of practical courses in 2018-2019.
- ESIR students: 12 hours of practical courses in 2019-2020.
Teaching Materials
- 2019-2020: I wrote a practical course on Spark in French ( PDF and Markdown). Two solutions are available as Jupyter notebooks for the sample of the first 100 thousand lines and the first 2Go file.
- 2020-2021: I updated the practical course on Spark ( PDF and LaTeX) to use Dataframes instead of RDDs. The solution is available as a Jupyter notebook, as a Zeppelin notebook, and as a PDF document.
Database Security
I taught practical courses on database security to Master 1 students about database access control, database encryption, and database sanitization.
- Master 1 students: 10 hours of practical courses in 2018-2019.