PPUD (3360702)

Syllabus

Link to download

click here

PRACTICAL LIST

1	Install and configure MySQL database.
2	Install and use of SQLyog.
3	Install and use of php myadmin.
4	Install and Use of MySQL Browser.
5	Install and use of MySQL Administration.
6	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.
7	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.
8	Write stored routines such as write a routine for counting all product types and other such routines can be performed.
9	Manipulate on routines such as write a routine for updating price of all product by 5% and other such  routines can be performed.
10	Create cursors such as create a cursor for selecting all product whose price is more than 1000 and other such cursors can be implemented.
11	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.
12	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.
13	Create and manage user accounts in MySQL.
14	Practice with GRANT and Revoke Command.
15	Practice with database backup and recovery operations as well security operations.

Join Our Community

• Learn to Get Knowledge •