Undergrad @ IIIT Gwalior. Machine Learning enthusiast. Qualified JEE Mains and Advanced. Gate Aspirant.
Excellent orator.

Surya Pratap Singh

This course is part 2 of my course series. Part 1 is in the introduction category. Learners are recommended to watch part 1 before moving on to this part. This part contains working of all the operations done in Relational algebra over Database. Several practice questions and previous year's GATE questions have been included to strengthen learner's concepts and boosting his/her confidence in DBMS. No matter your background in academics is, whether you are just a novice at DBMS, you can still do this course series and become an expert.

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

English

Relational Algebra Made Easy: GATE

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

Topics of study for this course; Why you should choose this course; What will you get after completing it.

Introduction

Basic structure and must-know definitions before moving further.

Basic structure for Relational Algebra

Selection operation; Projection operation; Union, Intersection & Set difference operation; Problem solving approach.

Operations Part 1

Concept building and important practice questions.

Problem Solving

Cartesian product; Rename operation; Natural Join. With examples.

Operations Part 2

Concept building problems on selection, projection, Cartesian product and rename operations.

Problem solving part 1

Part 2 of problem solving with more challenging problems.

Problem solving part 2

Division operation and some nice problem solving.

Operations part 3 and PS - 1

Problem solving part 3

Generalized Projection and Aggregate functions with problem solving

Operations part 4

Concept of null value and Outer join with examples

Null Value & Outer Join

Deletion and Insertion Operation with examples

Modification of database part 1

Modification of database part 2

Solving some more interesting problem and seeing how to use Distinct feature in one of the question.

A very interesting problem where we need to draw the result of Cartesian product in order to understand the question. We'll also see how taking an example relation can sometimes make problem much more easier.

Theta join; Equi join; Semijoin; Anti join; All with examples.

Types of Joins

Code HELLOSONU01 | 8+ Years Teaching Exp. in GATE CS IT & GATE DS AI on Unacademy | Mentored 2 Lakh+ Students | Produced Rankers Under 500

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

17 lessons • 1h 57m

Invalid Date

NaN

Introduction

Invalid Date

NaN

Basic structure for Relational Algebra

Invalid Date

NaN

Operations Part 1

Invalid Date

NaN

Problem Solving

Invalid Date

NaN

Operations Part 2

Invalid Date

NaN

Problem solving part 1

Invalid Date

NaN

Problem solving part 2

Invalid Date

NaN

Operations part 3 and PS - 1

Invalid Date

NaN

Problem solving part 2

Invalid Date

NaN

Problem solving part 3

+ See all lessons