DATABASE MANAGEMENT SYSTEM
EasyExamNotes.com covered following topics in these notes.
EasyExamNotes.com covered following topics in these notes.
- Introduction to Database
- Introduction to DBMS
- Advantages and disadvantages of DBMS
- DML, DDL and DCL
- Domains
- Introduction to data models
- Entities and Attributes
- Relationship among entities
- Tuples
- Attributes
- Relation
- Keys
- Twelve rules of CODD
- Schemas
- Integrity Constraints
- Normalization
- Functional dependency
- Transaction processing concepts
- Schedule
- Serializability
- OODBMS vs RDBMS
- RDBMS
- SQL join
- SQL functions: SUM(), AVG(), MAX(), MIN(), COUNT().
- Block, Extent, Segment
- Oracle Background processes
- Trigger
- Oracle cursor
- Introduction to Concurrency Control
A list of Video lectures
References:
- Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
- Atul Kahate , “ Introduction to Database Management System”, Pearson Educations
This is helpful for me but upload now rgpv 2022 syllabus plize
ReplyDelete