DBMS

Database Management System

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

• Click here