EduRev

Get the App

Open App

Index

ER Model

Relational Model

Normalization

SQL

Transaction Management

All Exams > Computer Science Engineering (CSE) > Databases > All Videos

All videos of Databases for Computer Science Engineering (CSE) Exam

ER Model

ER Model Introduction

Attributes of Entity

Relationship in ER Model

One to Many Relationship

Many to Many and One to One Relationship

1 Crore+ students have signed up on EduRev. Have you? Download the App

Relational Model

Relational Model- 1

Relational Model- 2

Relational Model- 3

Strong and Weak Entity

Example Problem on ER Diagram and Relational Model

GATE Questions on ER Model- 1

GATE Questions on ER Model- 2

Recursive Relationship

Primary Key

Candidate Key

Super Key

Select and Project Operation

Rename Operation

Set Operations

Cartesian Product and Join operation

More Examples of Join Operation

Types of Join Inner Join (Theta Join)

Types of Join Inner Join (EQUI Join)

Types of Join Inner Join (Natural Join)

Outer Join

Gate 1999 Question on Relational Algebra

Gate 2004 Question on Relational Algebra

Gate 2019 Question on Relational Algebra

Divide Operation- 1

Divide Operation- 2

Gate 2017 Question on Divide Operation

Basic and Extended Operators in Relational Algebra

Gate 2012 question on Relational Algebra

Gate 2014 question on Relational Algebra

Gate 2015 question on Relational Algebra

Introduction to TRC

TRC Syntax- 1

TRC Syntax- 2

TRC Example- 1

TRC Example- 2

Normalization

Introduction to Normalization

Functional Dependency

More Examples of FD

Inference Rules for FD

Closure Set of Attributes

Gate 2006 Question on Closure Set of Attributes

Finding Candidate Key using FD

Gate Questions on Candidate Key- 1

Gate Questions on Candidate Key- 2

Equivalence of Two FD sets

Minimal Cover of FD set

Lossless Decomposition

FD Preserving Decomposition

Lossless and FD Preserving Decomposition Example- 1

Lossless and FD Preserving Decomposition Example- 2

Lossless and FD Preserving Decomposition Example- 3

Gate 2001 question on Lossless decomposition

Gate 2005 question on Lossless decomposition

Gate 2008 question on Lossless decomposition

First Normal Form

Second Normal Form Example- 1

Second Normal Form Example- 2

Second Normal Form Example- 3

Second Normal Form Example- 4

Second Normal Form Example- 5

Third Normal Form Example- 1

Third Normal Form Example- 2

Third Normal Form Example- 3

BCNF Example- 1

Facts about 3NF and BCNF

BCNF Example- 2

BCNF Example- 3

GATE Questions on Normalization- 1

GATE Questions on Normalization- 2

GATE Questions on Normalization- 3

GATE Questions on Normalization- 4

SQL

Understanding Schema

Create Database

Create Table- 1

Create Table- 2

Create Table- 3

Create Table- 4

Exercise for Create Database

Exercises on Select SQL- 1

Exercises on Select SQL- 2

Update Operation

View in DBMS

Delete Operation

Order by

Retrieve Data from Multiple Tables Exercise- 1

Retrieve Data from Multiple Tables Exercise- 2

Retrieve Data from Multiple Tables Exercise- 3

Retrieve Data from Multiple Tables Exercise- 4

Nested Query

Aggregate Functions

GATE 2011 Question on SQL

GATE 2012 Question on SQL

GATE 2010 Question on SQL

GATE 2005 Question on SQL

GATE 2005 Question on SQL Revised

Group By

Group By and Having Clause

GATE 2020 Question on SQL

Transaction Management

Transaction Management Introduction

Serial Schedules

Concurrent Schedule

Multiple Transactions Running Concurrently

States of Transaction

ACID Properties

Lost Update Problem W-W Conflict

Dirty Read Problem W-R Conflict

Unrepeatable Read Problem R-W Conflict

Recoverable Schedule

Cascading Aborts and Cascadeless Schedule- 1

Cascading Aborts and Cascadeless Schedule- 2

Strict Schedule

Serializability

Example 1 on Conflict Equivalent Schedules

Example 2 on Conflict Equivalent Schedules

Example 1 on Conflict Serializable Schedule

Example 2 on Conflict Serializable Schedule

Example 3 on Conflict Serializable Schedule

Example 4 on Conflict Serializable Schedule

Example 5 on Conflict Serializable Schedule

View Serializable Schedule- 1

View Serializable Schedule- 2

View Serializable Schedule- 3

Lock Based Protocols Introduction

Two Phase Locking Protocol

Disadvantage of 2 PL- 1

Disadvantage of 2 PL- 2

Strict 2-PL

Rigorous 2-PL

Conservative 2-PL

Timestamp Ordering Protocol- 1

Timestamp Ordering Protocol- 2

GATE 2010 Question on 2-PL

GATE 2016 Question on 2-PL

Databases

138 videos

Top Courses Computer Science Engineering (CSE)

General Aptitude for GATE

GATE Computer Science Engineering(CSE) 2023 Mock Test Series

Crash Course: Computer Science Engineering (CSE)

Question Bank for GATE Computer Science Engineering

Engineering Mathematics

Explore Courses

Signup to see your scores go up within 7 days!

Study with 1000+ FREE Docs, Videos & Tests

Continue with Google

10M+ students study on EduRev

Video lectures for Databases 2023 is part of Computer Science Engineering (CSE) exam preparation. The videos have been prepared according to the Computer Science Engineering (CSE) exam syllabus. The Video lectures, notes, tests & MCQs are made for Computer Science Engineering (CSE) 2023 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests here.

Video lectures of Databases in English & Hindi are available as part of Computer Science Engineering (CSE) exam. Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.

Chapters

Education Revolution