Types of databases and roles of users
Components, architecture, and functions of DBMS
ER diagrams and relationships among data
Tables, keys, and relational concepts
Query languages and data retrieval operations
Structured Query Language basics and commands
Normalization and schema design principles
Transactions, ACID properties, and management
Methods to handle simultaneous transactions
Backup, recovery, and fault tolerance methods