Syllabus – Total Marks: 10%
Test is conducted by HEC and Virtual University of Pakistan and following topics will be covered for 10% marks.
- Introduction to Database Systems
- Database System Architecture
- Data Models
- Relational Database Concepts
- Relational Algebra & Calculus
- Structured Query Language (SQL)
- Advanced SQL
- Database Design & Normalization
- Transaction Management
- Concurrency Control
- Recovery Management
- Indexing & File Organization
- Query Processing & Optimization
- Database Security
- Distributed Databases
- NoSQL & Modern Databases
- Data Warehousing & Data Mining (Introductory)