This course will use SQLite for studying. The contents of this course:
Week 1: Practical arrangments of the implementation. Introduction to the course topics Database table. Simple queries.
- Basic command for using SQLite
Week 2: Multiple tables. Dependencies between tables. Queries from several tables.
- Applying foreign keys for tables.
- Using Join operations on multiple tables
Week 3: Queries: same table several times in FROM clause. Basics of ER modelling. Mapping ER schema to SQL database schema.
Week 4: ER modelling Logical operations
Week 5: SQL queries: Set operations and aggregate functions.
Week 6: Nested queries. Arithmetic and other operations.
Week 7: Revision and some new topics