Module 1: Introduction to Databases Characteristics and advantages of the DBMS approach. Data models, schemas, and instances; three-schema architecture. Conceptual Data Modelling: Entity-Relationship (ER) diagrams, entity types, and structural constraints. Module 2: Relational Model & Algebra Relational model concepts, constraints, and update operations. Relational Algebra: Unary and binary operations (Select, Project, Join, Union). Mapping ER designs to a logical relational database design. Module 3: Database Design Theory & SQL Normalization: Functional dependencies, Normal Forms (1NF, 2NF, 3NF, BCNF), and multivalued dependencies. SQL Fundamentals: Data definition (DDL), data types, and basic retrieval queries. Module 4: Advanced SQL & Transaction Processing Complex retrieval queries, triggers, views, and schema modifications. Transactions: ACID properties, system concepts, and serializability. Module 5: Concurrency Control & NoSQL Concurrency Control: Two-phase locking, timestamp ordering, and multiversion techniques. NoSQL: Introduction to Big Data storage, CAP theorem, and MongoDB (CRUD operations).
Posts