Week 1

In this session, trainees will be introduced to databases, including why we use them, how data is modeled, and how to interact with a relational database using SQL.

Learning Goals

See this module's learning goals.

Main Topics

• What is a database? Why we use databases, real-life data models, and the role of databases in software systems.

• Relational data terminology: Table, row, column, primary key, foreign key.

• Schemas and entities: How to design and understand simple schemas.

• Basic SQL operations:

  • SELECT: Retrieving data

  • INSERT: Adding data

  • UPDATE: Modifying data

  • DELETE: Removing data

• Filtering and sorting: WHERE, LIKE, ORDER BY, LIMIT