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.
See this module's learning goals.
- 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