I am initially doing B.Tech in IT from IIIT Allahabad. I am good in mathematics and I love it. I got 93% marks in class 12.

Aman Dokania

In this course we study about Relational model , and how ER model changes into Relational model, and Relation Algebra with all operations and their examples.

GATE (Graduate Aptitude Test in Engineering) 2020 & 2021 complete preparation with best educators. Know about the detailed syllabus, best books, exam pattern and dates, previous year question papers a

GATE - Iconic Pro

Hindi

(Hindi) Relation Model and Relation Algebra

Relational Algebra

Database Management System

CS & IT

GATE - CSIT, DSAI & Interview Preparation

GATE, ESE and IIT-JAM

Ace the toughest competitive and government exams in India 

Test Preparation

In this lesson we learn about relational model basics. It's need and it's attributes.

Relational Model (in Hindi)

In this lesson we learn about relation schema, relation instance and database.

Relational Model: Part 2 (in Hindi)

In this lesson we learn about changing of  ER model  to Relational model. We also learn about keys in this lesson.

ER to Relational Model (in Hindi)

In this lesson we learn about query languages and two basic relation algebra operations select and project with examples.

Relation Algebra (in Hindi)

In this lesson we study about two basic operation of Relational algebra i.e union and set difference with examples.

Union and Set Difference (in Hindi )

In this lesson we learn about Cartesian product, composition and rename operation with examples.

Cartesian product, composition and rename

In this lesson we do some examples on basic operations of Relational algebra.

Examples on basic operations of Relational algebra.

In this lesson we learn about additional operations of Relational algebra. We learn about intersection and natural join with examples.

Set intersection and natural join

In this lesson we learn about the division and assignment operations with examples.

Division and assignment operation

In this lesson we learn about the aggregate functions and their operations.

Aggregate functions and operations.

In this lesson we learn about outer join with examples.

Outer join

In this lesson we learn about null values. At which point null creates confusion. And which operations doesn't take null.

Null values

Mentored 81,000+ Students | My Multiple Students secured AIR Below 100 in GATE | Joined top IISc, IITs & NITs | Joined PSUs | 5+ Years Exp.

Sweta Kumari

This course will cover Transactions and concurrency control in Databases for GATE CS / IT students with detailed analysis and explanation.

(Hindi) Transactions and Concurrency Control for Databases: GATE (CS/IT)

In this course , I will cover The concepts of Relational model with all topics covered in GATE Syllabus.

(Hindi) Relational Model GATE Syllabus with PYQs

Teaching experience of 4+ years as GATE faculty with some prestigious GATE institutions,Qualifying GATE from 2014,Qualifyied UGC NET 2018(ju

Megha 

This course will introduce the concept of relational algebra which is predominant application-level query language.With the help of examples the concept will be applied to different Gate questions.

Relational Algebra: Procedural Query Language for GATE(CS and IT)

Today is that tomorrow you talked about yesterday 🌿.


Ansha P

This course covers all the topics from Relational Algebra. This Course is beneficial for GATE (CS and IT) aspirants.

Relational Algebra: GATE (CS and IT)

M.Tech @ NSIT Delhi/GATE (CS) 2017&2018 qualified ...Not a teacher but a medium of sharing my knowledge 

Akshay Mandhare

In this course we'll study about the structured query language (SQL) and we'll see some examples of its query

(Hindi) Database (DBMS) - SQL Part 2 for GATE

This course will cover Joins topic in SQL. I will describe type of joins in this course with important examples.

Lessons

12 lessons • 1h 44m

Invalid Date

NaN

Relational Model (in Hindi)

Invalid Date

NaN

Relational Model: Part 2 (in Hindi)

Invalid Date

NaN

ER to Relational Model (in Hindi)

Invalid Date

NaN

Relation Algebra (in Hindi)

Invalid Date

NaN

Union and Set Difference (in Hindi )

Invalid Date

NaN

Cartesian product, composition and rename

Invalid Date

NaN

Examples on basic operations of Relational algebra.

Invalid Date

NaN

Set intersection and natural join

Invalid Date

NaN

Division and assignment operation

Invalid Date

NaN

Aggregate functions and operations.

+ See all lessons