Practical Syllabus
Lab Cycles — DBMS
Master practical programming with structured lab cycles, full source code solutions, algorithm logic workflows, and line-by-line code breakdowns.
4
Total Cycles
13
Lab Questions
Cycle 01
4 Questions
Lab Cycle 1 — DDL Commands, Schema Management & Constraints
Questions in this Cycle:
- 1 DDL Schema Definition and Table Alterations
- 2 Table Creation with Comprehensive Integrity Constraints
- 3 DML Data Population, Retrieval, and Filtering
- +1 more questions
Cycle 02
3 Questions
Lab Cycle 2 — SQL Operators, Aggregate Functions, Grouping & Joins
Questions in this Cycle:
- 1 Complex Queries using Comparison, Range, and List Operators
- 2 Aggregate Functions, GROUP BY, HAVING, and Sorting
- 3 Comprehensive Relational Joins (Inner, Natural, Outer)
Cycle 03
4 Questions
Lab Cycle 3 — Set Operations, Advanced/Recursive CTEs & TCL
Questions in this Cycle:
- 1 Set Theory Operators and Set-Based Queries
- 2 Analytical Window Functions & Department Salaries
- 3 Hierarchical & Recursive Queries (WITH RECURSIVE)
- +1 more questions
Cycle 04
2 Questions
Lab Cycle 4 — NoSQL Database Operations with MongoDB
Questions in this Cycle:
- 1 MongoDB Document Insertion, Selection, and Filtering
- 2 MongoDB Document Updates, Deletions, Projections & Pagination