Course module
DBMS (Technical Assessment) — CAPGEMINI Superset
- Lessons
- 168
- Duration
- 12 hr 56 min
- PYQs
- 1
- Practice
- 1038
3% of this course's PYQ weight is covered in this module.
Syllabus index
Lessons in this module
Basics of DBMS
DBMS Fundamentals
Types & DBA Functions
ER Diagram
ER Modeling Fundamentals
Cardinalities, Participation & Entity Strength
Relational Model & Functional Dependencies
Basics of Relational Model & Anomalies
Functional Dependencies & Axioms
Attribute Closure & Equivalence of Sets
- Attribute Closure & Equivalence of SetsPdf
- Closure Set of AttributesDrm Video
- Practice Questions Functional DependencyDrm Video
- Comparing Two Set Of Functional DependenciesDrm Video
- Practice QuestionsDrm Video
- Practice Questions on Functional DependenciesDrm Video
- Practice Questions Functional DependencyDrm Video
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)
Decomposition Properties & 4NF
Lossless Join Decomposition
Dependency Preserving Decomposition
File Organization & Indexing
Basics & Types of Indexing
- Basics & Types of IndexingPdf
- BackGround of IndexingDrm Video
- What is IndexingDrm Video
- Practice Question - Primary IndexingDrm Video
- Practice Question - Primary Indexing Cont...Drm Video
- Important Terminology of IndexingDrm Video
- Primary IndexingDrm Video
- Clustered IndexingDrm Video
- Practice Question - Clustered IndexingDrm Video
- Secondary IndexingDrm Video
- Practice question on secondary indexingDrm Video
- Multilevel Indexing notesPdf
- Multilevel indexingDrm Video
Relational Algebra
Introduction to Query Languages
Unary Operators (Selection & Projection)
Set Operations & Cartesian Product
Relational Calculus
Tuple Relational Calculus (TRC)
Domain Relational Calculus (DRC)
Safety of Expressions & Power
Transaction Management
Introduction & ACID Properties
Transaction States
Concurrency Control
Introduction to Concurrency Control
Database Recovery
Failure Types & Recovery Fundamentals
Log-Based Recovery Techniques
Advanced Recovery Algorithms
- Advanced Recovery AlgorithmsPdf
- Checkpoints & Shadow PagingDrm Video
- Deferred UpdateDrm Video
- Example (Deferred Approach)Drm Video
- Immediate UpdateDrm Video
- Example (Immediate Approach)Drm Video
- Example (Immediate DB Update)Drm Video
- ARIES Recovery Algorithm - Part 1Drm Video
- ARIES Recovery Algorithm - Part 2Drm Video
Database Security & Authorization
Data Warehousing & Mining
NoSQL
Introduction and Need for NoSQL Databases
Characteristics of NoSQL
Types of NoSQL Databases
Previous-year questions
Explore the course
- English Communication
- Artificial Intelligence (AI Literacy)
- Programming, Logic & Problem Solving (Technical Assessment)
- DSA (Technical Assessment)
- Software Engineering (Technical Assessment)
- OOPs (Technical Assessment)
- SQL (Technical Assessment)
- Networking (Technical Assessment)
- Modern Engg Awareness (Technical Assessment)
- Debugging Assessment
- Cognitive Assessment
- HR Interview
Loading lesson…