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
- History of DBMS
- Disadvantages of file system data managemen
- Database system application
- Advantages and disadvantages of DBMS
- DML, DDL and DCL
- Domains
- Introduction to data models
- Entities and Attributes
- Relationship among entities
- Tuples
- Attributes
- Relation
- Characterstic of Relation
- Keys
- Relational Database
- Schemas
- Integrity Constraints
- Referential Integrity
- Numerical One
- Normalization
- Functional dependency
- Transaction processing concepts
- Serializability
- Conflict Serializability
- Schedule
- Schedule recoverability
- Schedule example
- OODBMS vs RDBMS
- RDBMS
- SQL join
- Defining primary keys, foreign keys in a table
- CHECK constraints
- SQL functions: SUM(), AVG(), MAX(), MIN(), COUNT().
- Block, Extent, Segment
- Oracle
- Oracle Background processes
- Trigger
- Create Trigger
- Oracle cursor
- Oracle cursor types
- Create Explicit cursor
- Introduction to Transaction
- Introduction to Concurrency Control
- Data Mining and Data Warehousing
A list of Video lectures