Database Management System

Video Lessons & Revision Notes

1. DBMS - Introduction

Video Lessons - 3
Revision Notes - 1

Basic concepts, Advantages of a DBMS over file-processing systems, Data abstraction, Database Languages, Data Models: Introduction to ER, and Object Relational Model, Data Independence, Components of a DBMS and overall structure of a DBMS, Multi-User DBMS Architecture, System Catalogs

All Lessons and Notes
Featured Lesson in DBMS - Introduction
Database, File based sytems and need for DBMS
39 mins Video Lesson

Data, Database, Properties of Database, Database Management System, File Systems, Drawbacks of File Systems, and other topics.

2. Entity Relationship Model

Video Lessons - 5
Revision Notes - 2

Basic Concepts, entity, attributes, relationships, constraints, keys, ER and EER diagrams: Components of ER Model, conventions, converting ER diagram into tables, EER Model components, converting EER diagram into tables

All Lessons and Notes
Featured Lesson in Entity Relationship Model
Entity Relationship Model - Basic Concepts
33 mins Video Lesson

Introduction, Entity, Entity Set, Entity Type, Attributes, Null Values, Relationships, and other topics.

3. Relational Data Model and Relational Algebra

Video Lessons - 4
Revision Notes - 2

Basic concepts, Attributes and Domains, Relational Integrity: Domain, Entity, Referential Integrities, Enterprise Constraints, Views, Schema Diagram

Relational Algebra

All Lessons and Notes
Featured Lesson in Relational Data Model and Relational Algebra
Relational Data Model
27 mins Video Lesson

Introduction, Degree / Arity, Domain, Domain Constraint, Key Constraint, Entity Constraint, Referntial Integrity, Integrity Constriants, and other topics.

4. SQL

Video Lessons - 6
Revision Notes - 2

Characteristics and advantages, SQL Data Types and Literals, DDL, DML, SQL Operators, Tables: Creating, Modifying, Deleting, Views: Creating, Dropping, Updating using Views, Indexes, Nulls

SELECT Query and clauses, Set Operations, Predicates and Joins, Set membership, Tuple Variables, Set comparison, Ordering of Tuples, Aggregate Functions, Nested Queries, Database Modification using SQL Insert, Update and Delete Queries, concept of Stored Procedures, Cursors, Triggers, assertions, roles and privileges Programmatic SQL: Embedded SQL, Dynamic SQL.

All Lessons and Notes
Featured Lesson in SQL
SQL - Basic Concepts and Queries
56 mins Video Lesson

Introduction, Data Types, Schema And Catalog, Select-From-Where, Cross Product, Aliasing / Rename, Star Symbol (*), SQL results as MultiSet, Set Operations, Generalized Projection - Use of Math. Ops, Order By, String Comparison - Like, and other topics.

5. File Organization and Database Index

Video Lessons - 3
Revision Notes - 2

File Organization, Organization of records in files, Indices, Static and Dynamic Hashing

All Lessons and Notes
Featured Lesson in File Organization and Database Index
File Organization
51 mins Video Lesson

Introduction to Files and Blocks, Fixed Length Records, Variable Length Records, Byte Strings, Slotted Page Structure, Reserved Space Representation, List Representation, Organization Of Records, and other topics.

6. Transactions

Video Lessons - 3
Revision Notes - 1

Basic concept of a Transaction, Properties of Transactions, Concept of Schedule, Serial Schedule, Serializability: Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules

All Lessons and Notes
Featured Lesson in Transactions
Concurrency and Concept of Schedules
40 mins Video Lesson

Introduction, Concurrency, Advantages of Concurrency, Schedule, Serial Schedule, Equivalence of Schedules, Conflicting Set of Operations, Conflict Serializability, Serializability, and other topics.

7. Concurrency Control and Recovery Management

Video Lessons - 5
Revision Notes - 2

Concurrency Control: Need, Locking Methods, Deadlocks, Timestamping Methods, Optimistic Techniques, Multi-Version Concurrency Control, Different Crash Recovery methods such as Shadow-Paging and Log-Based Recovery: Deferred and Immediate, Checkpoints

All Lessons and Notes
Featured Lesson in Concurrency Control and Recovery Management
Timestamp based and Optimistic Protocols
46 mins Video Lesson

Timestamp based Protocols, Timestamp Ordering protocol, Thomas' Write Rule, Optimistic/ Validation Based Protocols, Multiversion Scheme, and other topics.

Subscription Information

Please Subscribe to one of these Packs to get full Access to video lessons & revision notes in this subject
Silver
Extra 40% off till 24th of September
Rs 485
Rs 291
8.68
5.21
You get full Access to
This Subject
20 Hours Video watch time
90 Days Validity
Platinum
Extra 40% off till 24th of September
Rs 900
Rs 540
16.11
9.67
You get full Access to
This Subject
45 Hours Video watch time
135 Days Validity
Diamond
Extra 40% off till 24th of September
Rs 1650
Rs 990
29.54
17.72
You get full Access to
All Subjects on Site
99 Hours Video watch time
180 Days Validity

In this Subject
  • Around 20 Hours of Videos
  • 29 Video Lessons
  • 12 Revision Notes
  • 7 Modules
Tell your Friends about this Subject

Member's Zone