A compilation of resources for DBMS.
- Introduction to DBMS
- File system vs DBMS
- Data abstraction in DBMS
- Data independence in DBMS
- DBMS system architecture
- The database administrator
- Introduction to relational model in DBMS
- Introduction of relational model and codd rules in DBMS
- Relational schema in DBMS
- Types of keys in relational model
- Mapping from ER model to relational model
-
DDL commands
-
DQL commands
-
DML commands
-
DCL commands
-
TCL commands
- Transaction in DBMS
- Concurrency problems in DBMS transactions
- Concurrency control in DBMS
- Database recovery in DBMS
- Deadlock in DBMS
- Wait-Die scheme vs Wound-Die scheme
- Cascade in SQL
- WITH in SQL
- Cursor in SQL
- ROLLUP in SQL
- GROUP BY on multiple columns
- MySQL LIMIT x,y
- Difference between Hierarchical, Network and Relational Data Model
- What is Data Abstraction in DBMS and what are its three levels?
- The relational data model(video)
- Functional dependency in DBMS(video)
- Types of functional dependencies in DBMS
- Basic concept of normalization | Need of Normalization in DBMS(video)