DBMS (DataBase Management System)

TCS NQT Registration Steps Large

Learn DBMS

DBMS again is very important subject of computer science courses and is well asked in various placement exams both in the online tests as MCQ’s and also in Interviews for various companies. Most Data Science companies have DBMS as requirement for you to learn.

Normalisation

TCS NQT Registration Steps Large
TCS NQT Registration Steps Large

Transaction Control and B Trees

  • Transactions and Concurrency Control :
    • Introduction(including transaction concurrency and Deadlock)
    • ACID Properties in DBMS | Oracle | SQL
    • Concurrency Control Protocols – Lock-Based Protocol
    • Conflict Serializability
    • View Serializability
    • Recoverability of Schedules
  • Indexing, B and B+ trees :
    • 1.Indexing and its Types
    • B-Tree Introduction
    • B-Tree Insert
    • B-Tree Delete

Important SQL Queries

————————————————————

  added by trishaank

  • SQL Alter in DBMS
  • Drop/Truncate/Rename in DBMS
  • SQL aggregate functions in DBMS

          SQL SET OPERATIONS IN DBMS 

  • UNION-UNION ALL
  • INTERSECT 
  • MINUS
TCS NQT Registration Steps Large

Please Login/Signup to comment