Database Systems
Lecture, National University of Science and Technology - Department of Computer Science, 2024
3 + 1 Credit Hours - Spring 2024
Welcome to Database! The course material and lectures will be posted on this site and students will be notified accordingly.
The assignments are there to help you to learn to THINK. do not copy/ use other resources to complete them. if you have trouble, please visit me or discuss with fellows. NO SHARING Some of this course content uses the course Databases by META. Feel free to Follow along!
The following resources are some additional reading material that introduces you to the concept of a database, different types of databases, about relational databases in specific and also about the history of databases. These will add to the knowledge that you’ve got on these areas throughout this lesson.
Reference Book(s):
- Ramez Elmasri, Shamkant Navathe - Fundamentals of Database Systems
- Hoffer - Modern database management
Lectures
| Date | Lecture No. (Download Link) | Topic | Assignment | supplementary content/Video links | |
|---|---|---|---|---|---|
| 12/02/2024 (Week 1) | Lecture 1 | Introduction to Database System Concepts | Design a Database where customer is unique. Assignment due wed, 28 feb 2024 | Intro to Databases - week 1-META | |
| 19/02/2024 (Week 2) | Lecture 2 | SQL Data types, DDL Commands | Quiz on Monday, March 4, 2024 for materials to prepare from please refer to google classroom | CRUD - week 2-META | |
| 26/02/2024 (Week 3) | Lecture 3 | SQL Operators and Filtering Data | week 3 videos-META | ||
| 4/03/2024 (Week 4) | Lecture 4 | Designing Database Schema and Data modeling | Assignment due Monday March 18, 2024, | Part 1-META | |
| 11/03/2024 (Week 5) | Lecture 5 | Retrieving data with group by, Aggregation | |||
| 18/03/2024 (Week 6) | [Lecture 6] | Joins in Database | Part 3-META | ||
| <!— | 25/03/2024 (Week 7) | Lecture 7 | |||
| 25/03/2024 (Week 8) | Lecture 8 | ||||
| 25/03/2024 (Week 9) | Lecture 9 | ||||
| 25/03/2024 (Week 10) | Lecture 10 | ||||
| 25/03/2024 (Week 11) | Lecture 10 | –> |
Updates *Office Hours on Thursday 11am - 1.30am and 3pm to 5pm. *meanwhile for questions or scheduling a meeting, please email.