Engineering Graduate & sort of an IT guy.

Himanshu Prakash

Introduction to DBMS, and related topics/terms in the most simplest form possible.

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

Introduction to DBMS

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

Explanation of Primary,Candidate,Super,Composite keys in simple language with a example.

Table - Relation and Keys

foreign key,and foreign key constraints.
Explained with a little example.

Foreign Key

Functional Dependencies and Finding Candidate Keys

What's the need of Normal Forms, Why Decompose Table/Relations.
What kinds problems occur.

DBMS Normal Forms Part 1

Definition of some Basic terms that we will be using in coming lectures on Normal Forms.

DBMS Normal forms Intro Part 2

Trick / rule to convert into 2NF.
Indentify from FDs if given relation is in 2NF.
Find the candidate keys and apply the rule.

DBMS Normal Forms : 2nd Normal Form, 2NF

Definition of Transitive Dependency.
simple 2 step process to check 3NF.
Although we will not be using Transitive Dependency directly while determining 3NF,but one must know what it means.

DBMS : Normal Forms 3NF.

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 discusses Database Management System for GATE examination.

(Hindi) MCQs on Database Management System for GATE 2018

This course will cover NOSQL Databases in 60 Minutes.

(Hindi) Learn NOSQL Databases in 60 Minutes

This course will cover Big Data Tutorial in 60 Minutes. The course will be GATE Aspirants.

(Hindi) Big Data 60 Minutes Tutorial

I am grace.I am an MTECH Degree holder in computer and  IT. UGCNET qualified. I am having a teaching experience of 10 yrs.

Grace Maickel

This Course covers to discuss DBMS in detail for GATE 2020.

Database Management System: GATE 2020

This course will cover complete Concepts of ER Model with relevant PYQs.

(Hindi) ER Model Concepts With PYQs - GATE (CS and IT)

In this course, Sweta Kumari will cover 25 Awesome Tricks for Finding Keys in Databases.

Lessons

7 lessons • 1h 24m

Invalid Date

NaN

Table - Relation and Keys

Invalid Date

NaN

Foreign Key

Invalid Date

NaN

Functional Dependencies and Finding Candidate Keys

Invalid Date

NaN

DBMS Normal Forms Part 1

Invalid Date

NaN

DBMS Normal forms Intro Part 2

Invalid Date

NaN

DBMS Normal Forms : 2nd Normal Form, 2NF

Invalid Date

NaN

DBMS : Normal Forms 3NF.