This repo contains SQL exercises and homework for my database course.
NOTE: I'm not sure whether my program is working properly, perhaps there are a few logical bugs, please feel free to contact me or open issues to fix these bugs. Thank you so much!
PLEASE GIVE MY CREDIT OR MENTION ME @teddythinh WHEN USING. THANKS !
Contributions are not encouraged here because these are my homework. Thank you for understanding.
| Number | Context | Description |
|---|---|---|
| 1 | Week 1 | Create database, attach/detach database, export database to Excel spreadsheet using Microsoft SQL Server. |
| 2 | Week 2 | Create database named "Quản lý chuyến bay", tables, set primary keys, foreign keys and insert data. |
| 3 | Week 3 | Create database named "Quản lý đề tài", tables, set primary keys, foreign keys and insert data, run some basic queries on the "Quản lý chuyến bay" database. |
| 4 | Week 4 | Run some basic queries on the "Quản lý đề tài" database and some queries on the "Quản lý chuyến bay" database using aggregate functions and conditions on groups. |
| 5 | Week 5 | Mid-term exam. |
| 6 | Week 6 | Run some nested queries on the "Quản lý chuyến bay" database. |