Respected, I was wondering whether referring and learning the lecture slides, as for some parts i am not able to follow the lecture video and practicing the lab questions would be enough to get a good score for the midterms. Thanking you,

Hi, Format: MCQs (I will guide you in the lecture how to fill an MCQs sheet). There will NOT be any short-answer/long answer questions. Content: - Theory: Everything that we will cover till the Lecture in week 6 (26 Aug 2024). Topics include: Introduction to Databases Relational Model Relational Algebra ER Modeling (Wk 4) Enhanced ER Modeling (Wk 5-6) - SQL: Everything that we will cover till week 6, including Labs 1,2 & 3. Topics include: DML: Use compound WHERE conditions. Use aggregate functions. Sort query results using ORDER BY. Group data using GROUP BY and HAVING. Use basic subqueries. DDL: CREATE TABLE UPDATE TABLE INSERT INTO DROP TABLE DELETE FROM Material for both theory and SQL is available on LMS.