Database Administrative Security

CBS 214/ Database Administrative Security
Lecturer: Ms. Halal

Lecture Notes	Practical Sessions	Question Bank
Theoretical Lecture 1 – Security Fundamentals	Lecture 1 – Introduction to Databases
Theoretical Lecture 2 – Database Security Principles	Lecture 2 – SQL Server Fundamentals
Theoretical Lecture 3 – Database Control Frameworks	Practical Lecture 3- Database Design
Theoretical Lecture 4 – SQL Server Security Architecture	Practical Lecture 4- SQL Inhection (SQLi)
Theoretical Lecture 5- SQL Injection	Practical Lecture 5 – Types of SQL Injection (SQLi)
Theoretical Lecture 6 & 7 – Types of SQL Injection & Their Preventions	Practical Lecture 6- SQL Injection (SQLi) Preventions
Theoretical Lecture 8 – Input Validation & Information Leakage	Practical Lecture 7- Authentication & Authorization
Theoretical Lecture 9 – Database Monitoring, Logging, and Auditing	Practical Lecture 8 – Monitoring, Logging & Auditing in MS SQL Server
Theoretical Lecture 10 – Database Backup and Recovery	Practical Lecture 9 – Database Backup in MS SQL Server