PROFESSIONAL PRACTICES USING DATABASE (3360702)  

4
Credit
0 + 0 + 4
Lect + Tuto + Pract
Teaching Scheme
0 + 0 + 0
ESE + PA + ALA
Theory Marks
40 + 0 + 60
ESE + OEP + PA
Practical Marks
ESE - End Semester Examination, PA - Progress Assessment, ALA - Active Learning Assignments, OEP -Open Ended Problem


Rationale
The course is associated with database administration and with those developers who want to use maximum functionalities of the MySQL database. The pass out of this course will be able to implement user privileges, set resource limitations, and access controls. In addition, students will learn to apply new features such as creating and using stored procedures, triggers and views of MySQL database, applying backup and security features of MySQL database management. Thus this course would help students in administration of database in a more professional way.
Course Outcome
The theory should be taught and practical should be carried out in such a manner that students are able to acquire different learning out comes in cognitive, psychomotor and affective domain to demonstrate following course outcomes.
i. Perform various database operations using MySQL GUI tools
ii. Implement triggers, and stored routines of MySQL
iii. Implement event handling
iv. Perform User Management in MySQL
v. Apply database backup and recovery techniques

Active Learning
MySQL (open source), SQLyog, MySQL Query Browser and other Administrative tools.