Important Topics of DBMS and Notes for GATE & Computer Science Engineering Exams

By Aditi Verma|Updated : September 27th, 2021

DBMS comes under the core subjects of the Computer Science branch. So, it is very important for CSE people to go through this subject. This subject is quite vast and covers so many concepts. In this article, DBMS is divided into topics, which are further divided into subtopics. Here is the list of important topics in DBMS one can refer while preparing the subject:

DBMS comes under the core subjects of the Computer Science branch. So, it is very important for CSE people to go through this subject. This subject is quite vast and covers so many concepts. In this article, DBMS is divided into topics, which are further divided into subtopics. Here is the list of important topics in DBMS one can refer to while preparing the subject:

IMPORTANT TOPICS ARE:

  • Database Design

    • Introduction to keys
    • Codd rules
    • Overview of Functional Dependencies and Armstrong rules
    • Closure and Canonical covers
    • Lossless Join and Dependency Preserving Decomposition
    • Normal Forms

  • ER Model

    • Basic Terminologies
    • Mapping Constraints
    • Decomposition into Higher Normal Form

  • Relation Algebra 

    • Basic Operators
    • Derived Operators
    • Deriving Expression for Queries

  • Relational Calculus

    • Tuple Relational Calculus
    • Domain Relational Calculus

  • SQL (Structured Query Language)

    • Data Definition lanuage
    • Data Manipulation Language
    • Nested Queries
    • Aggregate Functions

  • File Organisation

    • Types of index
    • Multilevel Indexing
    • B/B+ tree

  • Transaction and Concurrency Control

    • ACID properties and state transition diagram
    • Checkpoints
    • Schedules and Types of Schedules
    • Serializability
    • Recoverability
    • Locking Protocols

You can follow the detailed champion study plan for GATE CS 2022 from the following link:

Detailed GATE CSE 2022 Champion Study Plan

Candidates can also practice 110+ Mock tests for exams like GATE, NIELIT with BYJU'S Exam Prep Test Series check the following link:

Click Here to Avail GATE CSE Test Series!(100+ Mock Tests)

Get unlimited access to 21+ structured Live Courses all 112+ mock tests with Online Classroom Program for GATE CS & PSU Exams:

Click here to avail Online Classroom Program for Computer Science Engineering

Thanks

Comments

write a comment
vaibhav

vaibhavJul 2, 2018

Then What is left ?
Mutyalaiah Paricherla
Please provide DBMS video lectures by Deepthi Mittal

Follow us for latest updates