1 | To install MySQL Database Management System and understand its basic components | | 30/12/2025 | 01/01/2026 |
2 | To create a basic database and perform simple operations | | 01/01/2026 | 06/01/2026 |
3 | To study and implement various data types in SQL | | 06/01/2026 | 08/01/2026 |
4 | To study and implement various data constraints in SQL | | 08/01/2026 | 13/01/2026 |
5 | To write SQL queries for table creation and modification | | 13/01/2026 | 16/01/2026 |
6 | To demonstrate the use of various DML operations i.e., insertion, deletion, and updating | | 16/01/2026 | 27/01/2026 |
7 | To demonstrate the use of various DML operations i.e., select, where, and, or, not, order by, and insert into | | 27/01/2026 | 03/02/2026 |
8 | To demonstrate the use of aggregate functions i.e., min, max, count, sum, and average | | 03/02/2026 | 06/02/2026 |
9 | To demonstrate the use of aggregate functions i.e., like, wildcards, in, and between | | 06/02/2026 | 10/02/2026 |