Course Purpose
The purpose of this course is to equip learners with skills for ensuring database availability, security and efficiency.
Course Learning Outcomes
Describe database administration concepts.
Protect a database from threats.
Improve the availability of database management system.
Evaluate the performance of a database management system.
Course Content
Database security
Security concepts: integrity; availability; confidentiality, data sensitivity; SQL Injection Security mechanisms
Access control: user accounts, roles, account creation; granting privileges, revocation of privileges, account level privileges, relation level privileges; privilege propagation, security classes, label security policy; statistical database security, views Data encryption:
Availability: Calculation of availability; causes of downtime, backups and restore; offline back- ups, online backups; clustering and replication, split mirroring, log shipping, failover, flashback
Efficiency: Size planning, replication, partitioning, Performance monitoring and tuning, query optimization, vacuuming