Module 2: Databases

Last revised: 31/10/2021

Summary

Web applications that persist data between visits inevitably use a database. Students familiarize themselves with the relational and non-relational databases used in today's ecosystem and their query languages: MySQL, PostgreSQL, MongoDB. Students explore the advantages and disadvantages of each technology, understanding the appropriate use cases for each one.

Outline

• 1 Introduction to databases [R]

• 1.1 Introduction to relational databases [R]

• 1.2 Relational database structure [R]

• 1.3 Querying in SQL [R]

• 1.4 SQL queries practice [L]

• 2 Introduction to NoSQL databases [R]

• 2.1 Introduction to MongoDB [R]

• 2.2 Querying in MongoDB [R]

• 2.3 MongoDB queries practice [L]

• 3 ORM and ODM [R]

• 3.1 Sequelize practice [L]

• 4 Other popular databases [R]

• 4.1 Elasticsearch practice [R]

• 5 Summary [R]