Course module

DBMS (Technical) — AMCAT Superset

Explore the module outline and lessons below. Enroll free to begin studying here.

Lessons: 316
Duration: 23 hr 5 min
PYQs: 2
Practice: 34

Exam importance: 0.2% of the exam, based on section capacity, PYQ history and paper recency.

Syllabus index

Lessons in this module

316 linked lessons

Basics of DBMS

DBMS Fundamentals

Types & DBA Functions

Data Model, Architecture & Components

ER Diagram

ER Modeling Fundamentals

Cardinalities, Participation & Entity Strength

Conversion of ER Diagram into Relational Model

Relational Model & Functional Dependencies

Basics of Relational Model & Anomalies

Functional Dependencies & Axioms

Attribute Closure & Equivalence of Sets

Minimal Cover (Canonical Cover)

Keys & Integrity Constraints

Super Key, Candidate Key & Primary Key

Foreign Key & Referential Integrity

Composite & Alternate Keys

Normalization (1NF - BCNF)

Introduction to Normalization & 1NF

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Decomposition Properties & 4NF

Multivalued Dependency (MVD) & 4NF

Lossless Join Decomposition

Dependency Preserving Decomposition

File Organization & Indexing

Basics & Types of Indexing

B-Trees & B+ Trees (Structure & Insertion)

Deletion in B-Trees & B+ Trees

Relational Algebra

Introduction to Query Languages

Unary Operators (Selection & Projection)

Set Operations & Cartesian Product

Join Operations (Inner & Outer)

Rename Operation

Division Operator

Relational Calculus

Tuple Relational Calculus (TRC)

Domain Relational Calculus (DRC)

Safety of Expressions & Power

Transaction Management

Introduction & ACID Properties

Transaction States

Concurrency Problems

Schedules & Conflict Serializability

View Serializability

Recoverability, Cascadeless & Strict Schedules

Concurrency Control

Introduction to Concurrency Control

Timestamp Ordering Protocols

Lock-Based Protocols & Basic 2PL

Variations of 2PL (Strict, Rigorous, Conservative)

Database Recovery

Failure Types & Recovery Fundamentals

Log-Based Recovery Techniques

Advanced Recovery Algorithms

ORDBMS

Concepts and Features of Object-Relational Databases

ORDBMS - Introduction

Database Security & Authorization

Introduction to Database Security

Mandatory Access Control (MAC)

Role-Based Access Control (RBAC)

Query Processing & Optimization

Introduction to Query Processing and Query Life Cycle

Heuristic Optimization

Enhanced Data Models

Enhanced and Specialized Data Models

Temporal Databases

Multimedia Databases

Mobile and Internet Databases

Geographic Information Systems

Genome Data Management

Distributed Databases

Data Warehousing & Mining

Introduction to Data Mining and Data Warehouse

Data Warehousing

Data Mining Functionalities

Data Modelling in Warehouses

Data Mining Techniques

OLAP vs OLTP - Concept & Details

Advanced Data Mining Methods

Big Data Systems

Introduction and Characteristics of Big Data

Types and Sources of Big Data

Big Data Architecture

Hadoop Framework Overview

Hadoop Distributed File System (HDFS)

MapReduce and YARN

NoSQL

Introduction and Need for NoSQL Databases

Characteristics of NoSQL

Types of NoSQL Databases

Query Optimization and Aggregation Framework

NoSQL in Cloud and Distributed Environments

Multi-Topic Content (Cross-Concept Material)

Distributed vs Centralised Database systemsDrm Video

Previous-year questions

PYQ collectionPYQ Questions1 questions PYQ collectionPYQ Questions1 questions PYQ collectionPYQ Questions1 questions PYQ collectionPYQ Questions1 questions PYQ collectionPYQ Questions2 questions

Explore the course

Previous moduleOOPs (Technical)Next moduleSQL (Technical)

View course details