Retrieving data is the first step in a data science project, and many datasets are stored in databases. Sometimes the database manager will grant access to the data scientist, sometimes creating a new database from scratch will be needed. This course aims at introducing the world of databases to students without any background in this area. We will first focus on the SQL paradigms and then on the NoSQL paradigms. MySQL and mongoDB will be employed for applications.
Course outline:
- SQL o Relational Database principles o Creating and updating a database o Vocabulary o Queries o Import and Export o Exercices
- NoSQL o Introduction o Definition and principles o NoSQL vs. SQL o NoSQL types o Exercices o Using connectors to load data in dataframes via python.