| Lecture No. |
Description |
Lecture By |
| Lecture 1 |
Purpose, Advantages and Disadvantages of DBMS |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 2 |
Data Models |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 3 |
Schemas and Instances, |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 4 |
DBMS Architecture and Data Independence, |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 5 |
Types of DBMS – Hierarchical, Network, Relational, Object-Oriented and Object Relational. |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 6 |
ER-Model: Basic concepts |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 7 |
Design Issues |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 8 |
Mapping Constraints |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 9 |
Keys, E-R Diagram, :Design of an ER Database Schema |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 10 |
Reduction of E-R Schema to Tables |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 11 |
SQL: Background, Basic Structure, Set Operations |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 12 |
Aggregate Functions, Null Values |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 13 |
Nested Sub Queries, Derived Relations |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 14 |
Views, Modification of Database, Joined Relations |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 15 |
Data Definition Language, |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 16 |
Domain Constraints, Referential Integrity. |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 17 |
Oracle: Basic Architecture, Data Definition |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 18 |
Data Manipulation (LIKE Operator, String Commands, Numeric Function, Date Function, Translate and Decode ) |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 19 |
Introduction to PL/SQL |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 20 |
Conditional, Logic, Loops, Go to Statements |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 21 |
Exceptional Handling, Triggers, Procedures, Functions, Cursor, LOB’s |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 22 |
Relational Algebra |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 23 |
Functional Dependencies, Normal forms NF1, NF2, NF3 and BCNF |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 24 |
Multi valued Dependencies and Fourth Normal Form |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 25 |
Join Dependencies and Fifth Normal Form |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 26 |
Transaction, Concurrency: ACID Properties |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 27 |
Transaction State, Locks, Deadlock Condition |
Lecture by , Lecture by , Lecture by , Lecture by |
| Lecture 28 |
Two- Phase Locking Protocol |
Lecture by , Lecture by , Lecture by , Lecture by |