Course: Database Management Systems (SQL/Oracle/DBMS/RDBMS):

Contents:

1. Introduction to Database Management Systems.
2. Basic SQL.
3. Relational Algebra. Entity-Relationship Model.
4. Relational Database Design, Integrity Constrainst and Normal Forms.
5. Indexing and Hashing. Query Processing.
6. Advanced SQL, Joins, Nested Queries.
7. Query Optimization. Transactions (Serializability and Recoverability)
8. Concurrency Control. Recovery Systems.

Duration: 30 hours Theory, 90 hours Practical (Recommended)