Chapter 1 : Database system
Topic : Database system-concept
Content : Database system-concept
46 MB ,24:52 MIN , THEORY
Chapter 1 : Database System
Topic : Database Architecture
Content : Database Architecture
26 MB ,14:38 MIN , THEORY
Chapter 1 : Database system
Topic : Relational model
Content : Relational model
21 MB ,11:12 MIN , THEORY
Chapter 1 : Database system
Topic : Database system - Constraints
Content : Database system - Constraints
21 MB ,11:59 MIN , THEORY
Chapter 1 : Database system
Topic : Database system - Relational Database Model
Content : Database system - Relational Database Model
22 MB ,12:17 MIN , THEORY
Chapter 1 : Database system
Topic : Database system - Relational Database
Content : Database system - Relational Database
14 MB ,7:45 MIN , THEORY
Chapter 1 : Database system
Topic : Database system - Relational Algebra
Content : Database system - Relational Algebra
100 MB ,58:26 MIN , THEORY
Chapter 1 : Conceptual modelling and database design
Topic : Data modelling using the Entity Relationship model (ER)
Content : Data modelling using the Entity Relationship model (ER)
51 MB ,28:46 MIN , THEORY
Chapter 1 : Conceptual modelling and database design
Topic : Data modelling using the Entity Relationship model (ER)
Content : Issues in ER diagram
21 MB ,11:59 MIN , THEORY
Chapter 1 : Conceptual modelling and database design
Topic : Relational database design by ER and EER model
Content : Relational database design by ER and EER model
15 MB ,10:4 MIN , THEORY
Chapter 1 : Conceptual modelling and database design
Topic : The enhanced entity relationship model
Content : ER Diagram & EER Diagrams, Subclasses and Super class, Specialization and Generalization, Category or Union, Aggregation
10 MB ,7:12 MIN , THEORY
Chapter 1 : Conceptual modelling and database design
Topic : Practical database design methodology and use of UML diagrams
Content : Practical database design methodology and use of UML diagrams
45 MB ,27:35 MIN , THEORY
Chapter 1 : Database Design theory and normalization
Topic : Relational database design and further dependencies
Content : Relational database design and further dependencies
22 MB ,12:17 MIN , THEORY
Chapter 1 : Database Design theory and normalization
Topic : Basics of functional dependencies and normalization for relational databases.
Content : Basics of functional dependencies and normalization for relational databases.
48 MB ,26:24 MIN , THEORY
Chapter 1 : SQL
Topic : SQL-Complex queries
Content : SQL-Complex queries - Subqueries
17 MB ,10:49 MIN , THEORY + PRACTICAL
Chapter 1 : SQL
Topic : SQL-Complex queries
Content : SQL-Complex queries - Aggregate Function - group by
42 MB ,23:40 MIN , THEORY + PRACTICAL
Chapter 1 : SQL
Topic : SQL-joining database tables
Content : SQL-joining database tables
20 MB ,11:49 MIN , THEORY + PRACTICAL
Chapter 1 : SQL
Topic : SQL-schema modification
Content : SQL-schema modification - DDL (Data Definition Language)
14 MB ,8:28 MIN , THEORY + PRACTICAL
Chapter 1 : SQL
Topic : SQL-schema modification
Content : SQL-schema modification - Alter Table
35 MB ,20:4 MIN , THEORY + PRACTICAL
Chapter 1 : SQL
Topic : SQL-schema modification
Content : SQL-schema modification-Create Table
39 MB ,24:32 MIN , THEORY + PRACTICAL
Chapter 1 : File structure,
Topic : File structure
Content : File structure
20 MB ,10:10 MIN , THEORY
Chapter 1 : Transaction management and concurrency control and recovery
Topic : Transaction management and concurrency control and recovery
Content : Deadlocks Handling
18 MB ,10:27 MIN , THEORY
Chapter 1 : Transaction management and concurrency control and recovery
Topic : Concurrency control technique
Content : Concurrency control technique
14 MB ,7:51 MIN , THEORY
Chapter 1 : Transaction management and concurrency control and recovery
Topic : Introduction to transaction processing concepts and theory
Content : Introduction to transaction processing concepts and theory - ACID
18 MB ,10:28 MIN , THEORY
Chapter 1 : Transaction management and concurrency control and recovery
Topic : Database recovery technique
Content : Database recovery technique
31 MB ,18:24 MIN , THEORY