Course module

DBMS + SQL- Professional KnowledgeIBPS SO IT Mains

Lessons: 232
Duration: 18 hr 6 min
PYQs: 36
Practice: 1314

2% of this course's PYQ weight is covered in this module.

Syllabus index

Lessons in this module

232 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)

File Organization & Indexing

Basics & Types of Indexing

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

Deletion in B-Trees & B+ Trees

SQL

Introduction, Components & Structure

Select, Where, Distinct

Datatypes, Operators & Null

DDL, DML, DCL, TCL & Desc

Order By & Rename Operation (Alias)

Library Functions (Math, Aggregate, String, Date)

Set Operations & Cartesian Product

Join Operations (Inner & Outer)

Group By Clause

Nested & Correlated Subqueries

Views & PLSQL Basics

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)

Relational Algebra

Set Operations & Cartesian Product

Relational Calculus

Tuple Relational Calculus (TRC)

NoSQL

NoSQL in Cloud and Distributed Environments

Data Warehousing & Mining

Introduction to Data Mining and Data Warehouse

Data Warehousing

Data Modelling in Warehouses

OLAP vs OLTP - Concept & Details

Previous-year questions

Lessons in this module

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)

File Organization & Indexing

Basics & Types of Indexing

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

Deletion in B-Trees & B+ Trees

SQL

Introduction, Components & Structure

Select, Where, Distinct

Datatypes, Operators & Null

DDL, DML, DCL, TCL & Desc

Order By & Rename Operation (Alias)

Library Functions (Math, Aggregate, String, Date)

Set Operations & Cartesian Product

Join Operations (Inner & Outer)

Group By Clause

Nested & Correlated Subqueries

Views & PLSQL Basics

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)

Relational Algebra

Set Operations & Cartesian Product

Relational Calculus

Tuple Relational Calculus (TRC)

NoSQL

NoSQL in Cloud and Distributed Environments

Data Warehousing & Mining

Introduction to Data Mining and Data Warehouse

Data Warehousing

Data Modelling in Warehouses

OLAP vs OLTP - Concept & Details

Previous-year questions

Explore the course