A typical RDBMS syllabus for a B.Tech course covers database concepts, relational model, SQL, database design, and transaction management. It includes topics like ER modeling, relational algebra and calculus, normalization, and concurrency control. Practical aspects like SQL querying and database design using tools are also usually included. 

I. Introduction to DBMS

• Fundamentals:
  Data, Database, Database Management System (DBMS), DBMS vs. File System, Data Abstraction, Data Independence, Instances and Schemas, Three-schema architecture. 
• Data Models:
  Entity-Relationship (ER) Model, Relational Model, Network Model, Object-Oriented Data Models, Mapping ER Model to Relational Model. 
• Database System Architecture:
  Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL). 

II. Relational Model

• Relational Model Concepts: Relation, Attributes, Tuples, Domains, Keys (Primary, Foreign, Candidate), Integrity Constraints.
• Relational Algebra: Basic Operations (Select, Project, Union, Set Difference, Cartesian Product, Rename), Extended Operations (Join, Division).
• Relational Calculus: Tuple Relational Calculus, Domain Relational Calculus. 

III. Structured Query Language (SQL)

• SQL Basics:
  DDL (CREATE, ALTER, DROP), DML (SELECT, INSERT, UPDATE, DELETE), DCL (GRANT, REVOKE), Data Types, Constraints.
• Advanced SQL:
  SQL Functions (Aggregate, Numeric, Date, String), Set Operations, Subqueries, Correlated Subqueries, Joins, Views, Cursors, Stored Procedures, Triggers, Transactions (COMMIT, ROLLBACK, SAVEPOINT). 

IV. Database Design

• ER Diagram: Converting ER Diagrams to Relational Schema, Advanced ER Diagram Concepts. 
• Normalization: Functional Dependencies, Armstrong's Axioms, Normal Forms (1NF, 2NF, 3NF, BCNF), Dependency Preservation, Lossless Join Decomposition. 
• Schema Refinement: Introduction to Schema Refinement, Reasoning about Functional Dependencies, Case Studies. 

V. File Organization and Indexing

• File Organization: Sequential, Direct Access, Hashing.
• Indexing: Clustered and Non-Clustered Indexes, B+ Trees. 

VI. Transaction Management and Concurrency Control

• Transactions: ACID Properties, Transaction States, Concurrent Execution, Serializability.
• Concurrency Control: Lock-based protocols, Timestamp-based protocols, Validation-based protocols.
• Recovery System: Log-based Recovery, Failure with Loss of Non-Volatile Storage. 

VII. Advanced Topics (Optional, depending on the course)

• Distributed Databases: Client-Server Architecture, Distributed Database Design.
• Database Security: Access Control, Authorization.
• NoSQL Databases: Introduction to NoSQL Databases.
• Data Warehousing and Data Mining: Basic Concepts.