SSD-3302:Database Programming and Security – OCT II

DescriptionThe purpose of this one-week on-campus-training module is to practice hands-on sessions on writing SQL language by introducing PL/SQL. The course introduces the fundamentals of PL/SQL which includes declaring variables, writing executable statements, control structures, handling exceptions, and stored procedures and functions. This course utilizes Oracle scenarios and step-by-step examples. It also teaches a comprehensive understanding of the database server architecture and administration with respect to database and server security, database backup and recovery. Students will experiment common threats to databases, identify and implement appropriate security measures to protect and secure databases and its server. The following topics are covered: security, profiles, password policies, privileges and roles, Virtual Private Databases, and auditing. The course also covers advanced topics such as SQL injection, database management security issues such as securing the DBMS, enforcing access controls, and related issues. Lab: 5 hrs/week.