Chapter 1 : Introduction to Databases and Transactions
Topic : What is database system?
Content : Data Vs Information, Why Database?, Database Systems, Examples 46 MB ,24:52 MIN , THEORY

Chapter 1 : Introduction to Databases and Transactions
Topic : Purpose of database system
Content : Purpose of database system, DBMS, DBMS Responsibilities 43 MB ,24:33 MIN , THEORY

Chapter 1 : Introduction to Databases and Transactions
Topic : View of Data
Content : Data Abstraction, View of data - Physical level, Logical level, View level 29 MB ,15:25 MIN , THEORY

Chapter 1 : Introduction to Databases and Transactions
Topic : Database Architecture
Content : Introduction, Two-tier and three-tier architectures, Database architecture 26 MB ,14:38 MIN , THEORY

Chapter 1 : Introduction to Databases and Transactions
Topic : Transaction Management
Content : Transaction, Characteristics of transactions, ACID properties 18 MB ,10:22 MIN , THEORY

Chapter 1 : Introduction to Databases and Transactions
Topic : Transaction Management
Content : What is Transaction?, Characteristics of Transaction, ACID Properties, Transaction management 18 MB ,10:28 MIN , THEORY

Chapter 1 : Introduction to Databases and Transactions
Topic : Relational databases
Content : What is Relational database?, Example 14 MB ,7:45 MIN , THEORY

Chapter 2 : Data Models
Topic : The importance of data models
Content : Introduction, Database design, Data models, Data modeling, The importance of data models 23 MB ,13:7 MIN , THEORY

Chapter 2 : Data Models
Topic : Hierarchical and Network Models
Content : Hierarchical Model, Network Model, Definitions of standard database concepts 15 MB ,8:38 MIN , THEORY

Chapter 2 : Data Models
Topic : The Relational Model
Content : The Relational Model, RDBMS, SQL-based relational database application 21 MB ,11:12 MIN , THEORY

Chapter 3 : Database Design, ER Diagram and Unified Modeling Language
Topic : ER Model
Content : ER Model 51 MB ,28:46 MIN , THEORY

Chapter 3 : Database Design, ER Diagram and Unified Modeling Language
Topic : Constraints
Content : ER Model, Constraints 21 MB ,11:59 MIN , THEORY

Chapter 3 : Database Design, ER Diagram and Unified Modeling Language
Topic : Weak Entity set
Content : Weak Entity set, ER Model 15 MB ,8:34 MIN , THEORY

Chapter 3 : Database Design, ER Diagram and Unified Modeling Language
Topic : Entity Relationship Design Issues
Content : Entity Relationship Design Issues, Entity Set vs Attributes, Binary vs n-ary Relationship Sets, Relationship Attributes, 21 MB ,11:59 MIN , THEORY

Chapter 3 : Database Design, ER Diagram and Unified Modeling Language
Topic : Codd's Rules
Content : Codd's Rules for RDBMS 20 MB ,12:11 MIN , THEORY

Chapter 1 : Relational Database Model
Topic : Keys
Content : Keys, Super Key, Candidate Key, Primary Key, Alternate Key, Foreign Keys 28 MB ,17:7 MIN , THEORY

Chapter 1 : Relational Database Model
Topic : Relational Database Model - Logical view of data, Features of good RDD, Atomic Domain & 1NF
Content : Relational Database Model, Logical view of data, Features of good RDD, Atomic Domain & 1NF 22 MB ,12:17 MIN , THEORY

Chapter 2 : Relational Database Model
Topic : Normalization
Content : Normalization, Database design, Normal forms 48 MB ,26:24 MIN , THEORY

Chapter 2 : Relational Algebra and Calculus
Topic : Relational algebra
Content : Relational algebra, introduction, Selection and projection, set operations, Joins, Division, syntax, semantics. Operators, PROJECT, SELECT, PRODUCT, DIVIDE, UNION, INTERSECT, DIFFERENCE, JOIN 100 MB ,58:26 MIN , THEORY

Chapter 1 : Constraints, Views and SQL
Topic : SQL - Data Definition Language
Content : SQL, DDL, Data Definition Language, CREATE TABLE, ALTER TABLE, TRUNCATE TABLE, DROP TABLE 14 MB ,8:28 MIN , THEORY + PRACTICAL

Chapter 1 : Constraints, Views and SQL
Topic : Constraints
Content : SQL, Constraints, keys, Referential Integrity constraints, Value Constraints, Primary Key, Unique Key, Foreign Key, Check constraint, Not Null constraint 94 MB ,53:7 MIN , THEORY + PRACTICAL

Chapter 1 : Constraints, Views and SQL
Topic : DDL-ALTER Table
Content : DDL, ALTER Table, Data Definition Language, SQL, Oracle, Hands-on, demo 35 MB ,20:4 MIN , THEORY + PRACTICAL

Chapter 1 : Constraints, Views and SQL
Topic : NULL Values
Content : NULL Value, Handling Null value with IS NULL, NVL, NULL Value with arithmetic operators and group functions 19 MB ,10:55 MIN , THEORY + PRACTICAL

Chapter 1 : Constraints, Views and SQL
Topic : Joins
Content : SQL, Joins, Inner Join (Equi Join, Non-equi Join) , Outer Join (Left, right, full outer join) 20 MB ,11:49 MIN , THEORY + PRACTICAL

Chapter 1 : Constraints, Views and SQL
Topic : Aggregate Functions
Content : SQL, Aggregate Functions, GROUP BY, Having, Group Functions 42 MB ,23:40 MIN , THEORY + PRACTICAL

Chapter 1 : Constraints, Views and SQL
Topic : Nested Queries - Subqueries
Content : Nested Queries - Subqueries, SQL 17 MB ,10:49 MIN , THEORY + PRACTICAL

Chapter 1 : Constraints, Views and SQL
Topic : Views
Content : Views 58 MB ,32:9 MIN , THEORY + PRACTICAL

Chapter 1 : Constraints, Views and SQL
Topic : DDL - Create Table
Content : DDL - Create Table, SQL 39 MB ,24:32 MIN , THEORY + PRACTICAL

Chapter 1 : Transaction Management and Concurrency
Topic : Data Recovery
Content : Data Recovery, Crash Recovery, Recovery and Atomicity, Log-based Recovery, Checkpoint 31 MB ,18:24 MIN , THEORY

Chapter 1 : Transaction Management and Concurrency
Topic : Concurrency control
Content : Concurrency control, Methods for Concurrency control, Locking Methods, Time-stamp Methods, Optimistic Methods 14 MB ,7:51 MIN , THEORY

Chapter 1 : Transaction Management and Concurrency
Topic : Deadlock
Content : Concurrency Control, Deadlock, Deadlock detection & Prevention 18 MB ,10:27 MIN , THEORY

Chapter 1 : Transaction Management and Concurrency
Topic : File Organization
Content : File Organization, Types of File Organizations : Sequential File Organization, Heap File Organization, Hash File Organization, B+ Tree File Organization, Clustered File Organization 20 MB ,10:10 MIN , THEORY

Chapter 1 : Transaction Management and Concurrency
Topic : Concurrency control-Optimistic Method
Content : Concurrency control-Optimistic Method, Read phase, Validation or certification phase, Write phase 9 MB ,5:8 MIN , THEORY

Chapter 1 : Transaction Management and Concurrency
Topic : Concurrency Control - Lock Based Protocols
Content : Concurrency Control - Lock Based Protocols, Lock Granularity, Lock Types, Deadlocks, Binary Locking, Shared / Exclusive Locking, Two - Phase Locking (2PL) 30 MB ,15:31 MIN , THEORY

Chapter 1 : Transaction Management and Concurrency
Topic : Concurrency control-Timestamp based protocol
Content : Concurrency control-Timestamp based protocol, Timestamp Ordering Protocol, Thomas Write Rule 18 MB ,9:9 MIN , THEORY

Chapter 1 : PLSQL
Topic : PL/SQL Block Structure
Content : Introduction to PL/SQL Block structure, Types of PL/SQL Block, Anonymous Block 23 MB ,12:18 MIN , THEORY + PRACTICAL

Chapter 1 : PLSQL
Topic : Beginning with PL/SQL
Content : Why PL/SQL? Need of PL/SQL, Purpose, Introduction to PL/SQL Architecture 21 MB ,12:24 MIN , THEORY

Chapter 1 : PLSQL
Topic : Identifiers and Keywords
Content : PL/SQL Identifiers and Keywords 14 MB ,7:7 MIN , THEORY + PRACTICAL

Chapter 1 : PLSQL
Topic : Datatype
Content : Datatypes in PL/SQL, Inheriting column datatypes, %TYPE, %ROWTYPE 40 MB ,22:5 MIN , THEORY + PRACTICAL

Chapter 1 : Fundamentals of PL/SQL
Topic : Control Structures
Content : Control Structures, IF-ELSE, CASE 34 MB ,16:29 MIN , THEORY + PRACTICAL

Chapter 1 : PLSQL
Topic : PL/SQL Control Structures - Loop
Content : Iterative Control: LOOP and EXIT Statements, Simple loop, While Loop, For Loop 18 MB ,9:23 MIN , THEORY + PRACTICAL

Chapter 1 : PLSQL
Topic : Stored Procedures and Functions
Content : Stored Procedures and Functions 36 MB ,19:47 MIN , THEORY + PRACTICAL

Chapter 1 : PLSQL
Topic : Exception Handling
Content : PLSQL, Exception Handling, Named Exceptions, User-defined exceptions, OTHERS exception handler 71 MB ,39:15 MIN , THEORY + PRACTICAL