CB3412: Database Management Systems and Security Laboratory syllabus for Cyber Security 2021 regulation

Database Management Systems and Security Laboratory detailed syllabus for Cyber Security (Cyber Security) for 2021 regulation curriculum has been taken from the Anna University official website and presented for the Cyber Security students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.

For Cyber Security 4th Sem scheme and its subjects, do visit Cyber Security 4th Sem 2021 regulation scheme. The detailed syllabus of database management systems and security laboratory is as follows.

Course Objectives:

• To learn and implement important commands in SQL.
• To learn the usage of nested and joint queries.
• To understand functions, procedures and procedural extensions of databases.
• To understand attacks on databases and to learn to defend against the attacks on databases.
• To learn to store and retrieve encrypted data in databases

Practical Exercises:

1. Create a database table, add constraints (primary key, unique, check, Not null), insert rows, update and delete rows using SQL DDL and DML commands.
2. Create set of tables, add foreign key constraints and incorporate referential integrity.
3. Query the database tables using different where clause conditions and also implement aggregate functions.
4. Query the database tables and explore sub queries and simple join operations.
5. Query the database tables and explore natural, equi and outer joins.
6. Write user defined functions and stored procedures in SQL.
7. Execute complex transactions and realize DCL and TCL commands.
8. Write SQL Triggers for insert, delete, and update operations in database table.
9. Use SQLi to authenticate as administrator, to get unauthorized access over sensitive data, to inject malicious statements into form field.
10. Write programs that will defend against the SQLi attacks given in the previous exercise.
11. Write queries to insert encrypted data into the database and to retrieve the data using decryption.

Course Outcomes:

On completion of the course, the student will be able to:

1. Create databases with different types of key constraints.
2. Write simple and complex SQL queries using DML and DCL commands.
3. Realize database design using 3NF and BCNF.
4. Use advanced features such as stored procedures and triggers.
5. Secure databases and mitigate attacks on databases.

For detailed syllabus of all other subjects of Cyber Security, 2021 regulation curriculum do visit Cyber Security 4th Sem subject syllabuses for 2021 regulation.

For all Cyber Security results, visit Anna University Cyber Security all semester results direct link.