In this session, trainees will be introduced to the core concepts of databases, including why we use them, how data is modeled, and how to interact with a relational database using SQL.
| Week | Topic | Preparation | Assignment | Session Plan |
|---|---|---|---|---|
| 1. | Introduction to databases | Preparation | Assignment | Session Plan |
- Explain what a database is and why we use them
- Understand basic relational data terminology: table, row, column, primary key, foreign key
- Perform basic SQL operations: SELECT, INSERT, UPDATE, DELETE
- Use simple filtering and sorting techniques
- Understand simple database design & schemas