Home Database Management Systems : MCA-108

Database Management Systems : MCA-108

Lecture No.DescriptionLecture By
Lecture 1 Basic concepts: database & database users, characteristics of the databaseLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 2 database systems, concepts and architectureLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 3 date modelsLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 4 Schemas & instancesLecture by Ms. Arti Bajaj,    Lecture by ,    Lecture by ,    Lecture by
Lecture 5 DBMS architecture & data independenceLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 6 database languages & interfacesLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 7 data modelling using the entity-relationship approachLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 8 Overview of hierarchical, Network & Relational Data Base Management Systems-1Lecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 9 Overview of hierarchical, Network & Relational Data Base Management Systems-2Lecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 10 Relational model, languages & systemsLecture by Ms. Arti Bajaj,    Lecture by ,    Lecture by ,    Lecture by
Lecture 11 relational data modelLecture by Ms. Arti Bajaj ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 12 relational algebra: relational model conceptsLecture by Ms. Arti Bajaj ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 13 relational model constraints, Data ModelLecture by Ms. Arti Bajaj ,    Lecture by Ms. Arti Bajaj,    Lecture by ,    Lecture by
Lecture 14 relational algebraLecture by Ms. Arti Bajaj ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 15 SQL- a relational database language: date definition in SQL-1Lecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 16 SQL- a relational database language: date definition in SQL-2Lecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 17 view and queries in SQLLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 18 Specifying constraintsLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 19 Indexes in sqlLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 20 Oracle Architecture,  Logical Data StructuresLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 21 Physical Data StructureLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 22 Instances, Table Spaces, Types of Table spacesLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 23 Internal Memory StructureLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 24 Background ProcessesLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 25 Data Types, Roles & PrivilegesLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 26 Stored Procedures, User Defined FunctionsLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 27 CursorsLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 28 Error HandlingLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 29 TriggersLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 30 Relational data base designLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 31 function dependenciesLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 32 normalization for relational databasesLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 33 normal forms based on primary keysLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 34 1NF, 2NF, 3NF & BCNFLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 35 lossless join and dependency,  preserving decompositionLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 36 Concurrency controlLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 37 concurrency control techniquesLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 38 locking techniquesLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 39 time stamp orderingLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 40 granularity of data itemsLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 41 recovery techniquesLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 42 recovery conceptsLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 43 database backup and recovery from catastrophic failuresLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 44 Concepts of object oriented database management systemsLecture by ,    Lecture by ,    Lecture by ,    Lecture by
Lecture 45 Distributed Data Base Management SystemsLecture by ,    Lecture by ,    Lecture by ,    Lecture by
[whatsapp]