1. Unit : 1
   1. Database System Architecture
      1. What Is DBMS
      2. Data Abstraction
      3. Data Independece
   2. Data Models
      1. Conceptual Data Model
      2. Representational Data Model
      3. Physical Data Model
   3. SQL Commands
      1. DDL(Data Definition Language)
         1. Create
         2. Alter
         3. Drop
         4. Truncate
      2. DQL(Data Query Language)
         1. Select
      3. DML(Data Manipulation Language)
         1. Insert
         2. Update
         3. Delete
         4. Lock
      4. DCL(Data Control Language)
         1. Grant
         2. Revoke
      5. TCL(Transaction Control Language)
         1. Commit
         2. Rollback
         3. Savepoint
   4. Integrity Constraints
      1. Domain Constraints
      2. Entity Integrity Constraints
      3. Referential Integrity Constraints
      4. Key Constraints
2. Unit : 2
   1. Relational Database Models
      1. Relations & Attributes
      2. Primary Keys
      3. Relationships
      4. Normalization
      5. Advantages Of Relational Database Models
         1. Accurate
         2. Flexible
         3. Collabrative
         4. Trusted
         5. Secure
         6. Data is stored just once, which eliminates data deduplication.
         7. Complex queries are easy for users to carry out.
         8. Multiple users can access the same database.
         9. Relational database models are mature and well-understood.
         10. Data in tables within RDBMS can be limited to allow access by only particular users.
      6. The various tables and attributes related to each table are identified. The tables represent entities, and the attributes represent the properties of the respective entities.
      7. The attribute or set of attributes that help in uniquely identifying a record is identified and assigned as the primary key.
      8. The relationships between the various tables are established with the help of foreign keys. Foreign keys are attributes occurring in a table that are primary keys of another table.
   2. Query Processing and Optimization
   3. Relational Query Languages
      1. Procedural language
         1. Relational Algebra
            1. Select Operation (σ)
            2. Project Operation (∏)
            3. Union Operation (∪)
            4. Set Difference (−)
            5. Cartesian Product (Χ)
            6. Rename Operation (ρ)
      2. Non-Procedural language
         1. Relational Calculus
         2. Relational calculus is a non-procedural query language in which information is retrieved from the database without specifying sequence of operation to be performed.
3. Unit : 3
   1. Storage Strategies
4. Unit : 4
   1. Transaction Processing
5. Unit : 5
   1. Database Security
6. Unit : 6
   1. Advanced Topics