IES Officer, Ministry of Skills and Entrepreneurship Development, Govt. of India. AIR 48 in UPSC ESE 2018.

Danish Aggarwal

In this course, we will look into the DBMS introduction and it’s three tier - Architecture. We will start Functional Dependency also which is considered to be very important topic for ESE and in the end we will look into all the Theory and the possible questions on Normalization that can come in the ESE Exam.

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) Functional Dependencies And Normalization: ESE - E&T Engineering

DBMS and SQL

Computer Organization & Arch.

GATE & ESE - EE, EC

GATE, ESE and IIT-JAM

Ace the toughest competitive and government exams in India 

Test Preparation

In this lesson, we will see the course overview of the entire course.

Course Overview (in Hindi)

In this lesson, we will see the three-tier Architecture of the database.

Three - Tier Schema (in Hindi)

In this lesson, we will see the introduction to DBMS.

Introduction to DBMS (in Hindi)

In this lesson, we will see the various database design techniques.

Database Design Techniques (in Hindi)

In this lesson, we will see the introduction to Functional dependencies and we will also see one example to understand it in detail.

Introduction to Functional Dependency (in Hindi)

In this lesson, we will see the types of Functional dependencies and we will also see the inference rules to be used to solve the numerical on Functional dependencies!

Types of FD and inference rules (in Hindi)

In this lesson, we will see how to find the closure of set of Functional dependencies and how to find closure of Attributes of a given relation.

Finding Closure of Attributes

In this lesson, we will see how to perform the membership test for a given set of Functional dependencies.

Membership Test for FD

In this lesson, we will see how to check the equivalence of the given set of Functional dependencies.

Equivalence of set of Functional Dependencies

In this lesson, we will see how to find the canonical cover of the set of Functional dependencies.

Canonical Cover of set of Functional dependencies

In this lesson, we will see how to find the candidate key for a given relation.

How to find the Candidate Key

In this lesson, we will see the introduction to 2NF and 3NF in detail along with examples.

2NF and 3NF

In this lesson, we will see the definition to Normalization and we will also discuss First Normal Form in detail.

Normalization and 1NF

In this lesson, we will discuss the BCNF and we will also see some practice questions on Normalization process.

BCNF & Practice Questions on Normalization

In this lesson we will see the lossless join decomposition and we will also see some practice questions to see this topic in detail.

Lossless Join Decomposition

In this lesson, we will see how to find dependency preserving decomposition for a given relation. We will discuss one ESE PYQ here also.In the end, there is a practice question also.

Dependency Preserving Decomposition

III year UG. Information Science Student. Love teaching. 

Sanjetha K S

The course deals with various problems that uses the concept of dynamic programming

Dynamic Programming

Failed GATE & secured under 1000 rank in 2nd attempt- self study | 
MTech (IT- IIITM Gwalior) | Technical content writer @ geeksforgeeks

Nitika Bansal

I will be covering introduction to transaction, ACID property, serial & concurrent schedule, concurrency problem in transaction, classification of scheduls based on serializability, classification of schedules based on recoverability, precedence graph, topological sequence, view serializability schedule, locking protocol, multi mode locking, timestamp ordering protocol, Thomas write rule timestamp ordering protocol, multilevel locking protocol

(Hindi) Transaction and Concurrency Control - ESE E&T /GATE CSE

An engineering student trying to utilise her time. 

Process management, deadlock, memory management and file management are covered in this course.

Operating System

I am an IT technocrat pursuing my B-tech and my hobbies are teaching, reading novels, dancing.

Bhavana Tadikamalla

This course contains synchronization mechanisms - lock variables, test and set local variables.

Synchronization Mechanisms GATE (CS and IT)

This course contains Turn variables,interested variables.

Synchronization Mechanisms: Part 2 Gate (CS &IT)

btech graduate from miet meerut .Gate qualified

Geetika Sharma

This course will explain Scheduling for Operating System. This course is for  DMRC recruitment.

Lessons

16 lessons • 3h 35m

Invalid Date

NaN

Course Overview (in Hindi)

Invalid Date

NaN

Three - Tier Schema (in Hindi)

Invalid Date

NaN

Introduction to DBMS (in Hindi)

Invalid Date

NaN

Database Design Techniques (in Hindi)

Invalid Date

NaN

Introduction to Functional Dependency (in Hindi)

Invalid Date

NaN

Types of FD and inference rules (in Hindi)

Invalid Date

NaN

Finding Closure of Attributes

Invalid Date

NaN

Membership Test for FD

Invalid Date

NaN

Equivalence of set of Functional Dependencies

Invalid Date

NaN

Canonical Cover of set of Functional dependencies

+ See all lessons