| Sr. No | Unit No. | Exercise/Practical | Read |
| 1 | I | Install and configure MySQL database. | Click Here |
| 2 | I | Install and use of SQLyog. | Click Here |
| 3 | I | Install and use of phpmyadmin. | Click Here |
| 4 | I | Install and Use of MySQL Browser. | Click Here |
| 5 | I | Install and use of MySQL Administration. | Click Here |
| 6 | II | Create table and perform various task such as Create a product and product_price_history table. The price of product change constantly. Write a trigger for updating product_price_history table when product price change in product table and such other database can be explored. | Click Here |
| 7 | II | Implement and manipulate trigger such as Create a trigger for deleting all the products of particular product type when that product type is deleted and similar for other databases. | Click Here |
| 8 | II | Write stored routines such as write a routine for counting all product types and other such routines can be performed. | Click Here |
| 9 | II | Manipulate on routines such as write a routine for updating price of all product by 5% and other such routines can be performed. | Click Here |
| 10 | III | Create cursors such as create a cursor for selecting all product whose price is more than 1000 and other such cursors can be implemented. | Click Here |
| 11 | III | Perform various event handling operations such as create an event that checks the product types having quantity less than 20 in stack at every ten minutes and such other procedure can be done. | Click Here |
| 12 | III | Implement precise events such as create an event that checks the product which has been sold maximum in a day and same exercises can be performed | Click Here |
| 13 | IV | Create and manage user accounts in MySQL. | Click Here |
| 14 | IV | Practice with GRANT and Revoke Command. | Click Here |
| 15 | V | Practice with database backup and recovery operations as well security operations. | Click Here |
