PLAYLISTS FOR DBMS:
~BY IGDTUW RESOURCE
Gate Smashers complete dbms:
https://youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y
Asha Khilrani complete dbms:
https://youtube.com/playlist?list=PLz8TdOA7NTzToibk7WXtD5qvBMnkZkwh7
CodeHelp Placement series of DBMS:
https://youtube.com/playlist?list=PLDzeHZWIZsTpukecmA2p5rhHM14bl2dHU
Jenny’s lectures CS & IT:
https://youtube.com/playlist?list=PLdo5W4Nhv31b33kF46f9aFjoJPOkdlsRc
NESO Academy :
https://youtube.com/playlist?list=PLBlnK6fEyqRiyryTrbKHX1Sh9luYI0dhX
Education 4u:
https://youtube.com/playlist?list=PLrjkTql3jnm-CLxHftqLgkrZbM8fUt0vn
SCROLL DOWN TO GET THE
LIST OF TOPICS FROM GFG
LIST OF TOPICS OF DBMS ON GFG
There might be chances that few topics are from unit 2 in unit 1, but all topics are
covered. This document is made by considering the general syllabus.
~BY IGDTUW RESOURCE
UNIT 1:
Database design: https://www.geeksforgeeks.org/significance-of-database-design/
Characteristics of database:
https://www.geeksforgeeks.org/characteristics-of-the-database-approach/
Database architecture: https://www.geeksforgeeks.org/dbms-architecture-2-level-3-level/
File System v/s dbms :
https://www.geeksforgeeks.org/difference-between-file-system-and-dbms/
Database administrators and database users :
https://www.geeksforgeeks.org/different-types-of-database-users/
Data models: https://www.geeksforgeeks.org/data-models-in-dbms/
Schemas and Instances:
https://www.geeksforgeeks.org/difference-between-schema-and-instance-in-dbms/
Data independence & data abstraction :
https://www.geeksforgeeks.org/data-abstraction-and-data-independence/
Database languages: https://www.geeksforgeeks.org/sql-ddl-dql-dml-dcl-tcl-commands/
Database interfaces: https://www.geeksforgeeks.org/interfaces-in-dbms/
Entity-Relationship Model: https://www.geeksforgeeks.org/introduction-of-er-model/
Strong and weak entity sets in dbms :
https://www.geeksforgeeks.org/difference-between-strong-and-weak-entity/
Generalization, specialization & aggregation :
https://www.geeksforgeeks.org/generalization-specialization-and-aggregation-in-er-model/
UNIT 2 :
Relational model : https://www.geeksforgeeks.org/relational-model-in-dbms/
Relational model constraints : https://www.geeksforgeeks.org/relational-model-in-dbms/
Translating er model to relational model :
https://www.geeksforgeeks.org/mapping-from-er-model-to-relational-model/
Relational Algebra : https://www.geeksforgeeks.org/introduction-of-relational-algebra-in-dbms/
SQL intro : https://www.geeksforgeeks.org/structured-query-language/
Database definition and database manipulation :
https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
SQL indexes : https://www.geeksforgeeks.org/sql-indexes/
SQL Commands :
https://www.geeksforgeeks.org/sql-ddl-dql-dml-dcl-tcl-commands/
SQL Views : https://www.geeksforgeeks.org/sql-views/
SQL Queries: https://www.geeksforgeeks.org/sql-concepts-and-queries/
Practicing SQL commands: https://www.geeksforgeeks.org/basic-sql-commands/
UNIT 3:
Functional dependencies:
https://www.geeksforgeeks.org/types-of-functional-dependencies-in-dbms/
Database normalization: https://www.geeksforgeeks.org/introduction-of-database-normalization/
Normal forms: https://www.geeksforgeeks.org/normal-forms-in-dbms/
4th & 5th normal form:
https://www.geeksforgeeks.org/introduction-of-4th-and-5th-normal-form-in-dbms/
Lossless join : https://www.geeksforgeeks.org/lossless-decomposition-in-dbms/
Dependency preserving decomposition:
https://www.geeksforgeeks.org/data-base-dependency-preserving-decomposition/
Multivalued dependency: https://www.geeksforgeeks.org/multivalued-dependency-mvd-in-dbms/
Transaction management: https://www.geeksforgeeks.org/transaction-management/
Transaction states : https://www.geeksforgeeks.org/transaction-states-in-dbms/
ACID Properties: https://www.geeksforgeeks.org/acid-properties-in-dbms/
Concurrency control: https://www.geeksforgeeks.org/concurrency-control-in-dbms/
Lock based protocols:
https://www.geeksforgeeks.org/lock-based-concurrency-control-protocol-in-dbms/
Timestamp based protocols:
https://www.geeksforgeeks.org/timestamp-based-concurrency-control/
Recovery from transaction failures:
https://www.geeksforgeeks.org/database-recovery-techniques-in-dbms/
Log based recovery: https://www.geeksforgeeks.org/log-based-recovery-in-dbms/
Checkpoints: https://www.geeksforgeeks.org/checkpoints-in-dbms/
Deadlock handling: https://www.geeksforgeeks.org/deadlock-in-dbms/
UNIT 4:
Query processing overview: https://www.geeksforgeeks.org/sql-query-processing/
Measures of query cost: https://www.geeksforgeeks.org/measures-of-query-cost-in-dbms/
Object oriented database model:
https://www.geeksforgeeks.org/basic-object-oriented-data-model/
Exceptions: https://www.geeksforgeeks.org/exception-handling-plsql/
Cursors: https://www.geeksforgeeks.org/cursors-in-dbms-definition-types-attributes-uses/
Procedures:https://www.geeksforgeeks.org/sql-procedures/
Triggers & procedures:
https://www.geeksforgeeks.org/difference-between-trigger-and-procedure-in-dbms/
Triggers: https://www.geeksforgeeks.org/sql-trigger-student-database/
