Databases

Please find below some links to practical lectures in french on Databases. If you want my slides of theoretical lectures on Databases and more practical courses, please send me an e-mail.

• Simple Sqlite practical course

• Sqlite in python practical course: Data | Overleaf link

• Personal data, sensitive data and anonymization (based on Abel Betraoui's practical work subject) Overleaf link | Dataset

Here you can find some links to previous exams of the Bio-Informatics department at INSA Lyon.

• Exam of databases 2022 Bioinformatics department INSA

• Exam of databases 2015 Bioinformatics department INSA

• Exam of databases 2016 Bioinformatics department INSA

Hereafter you can find the most recent lectures used to teach Databases to the Bio-Informatics department students at INSA Lyon (english).

• Introduction

• Conceptual Model

• Relational Model

• Introduction to NoSQL

• Relational Algebra

• Normalization

Find below, the old lectures that I used to teach Databases to the Bio-Informatics department students at INSA Lyon (French).

• Introduction

• Modèle Conceptuel

• Modèle Relationnel

• Algèbre Relationnelle

• Normalisation