Course module
DBMS (Computer Science) — LTI MINDTREE Superset Course
Explore the module outline and lessons below. Enroll free to begin studying here.
Return to /learn/LTI-MINDTREE-PREPARATION/dbms-sql after enrolling
- Lessons
- 111
- Duration
- 8 hr 28 min
- PYQs
- 3
- Practice
- 20
2% 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
Conversion of ER Diagram into Relational Model
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)
Transaction Management
Introduction & ACID Properties
Transaction States
Concurrency Control
Introduction to Concurrency Control
Timestamp Ordering Protocols
Lock-Based Protocols & Basic 2PL
Database Security & Authorization
Introduction to Database Security
Mandatory Access Control (MAC)
Role-Based Access Control (RBAC)
Previous-year questions
Explore the course
- English Comprehension/Verbal Ability
- Logical Ability
- Quantitative Ability
- Basic Analytical Ability
- Computer Programming
- SQL (Computer Science)
- OS (Computer Science)
- Computer Networks (Computer Science)
- Data Structures (Computer Science)
- OOPs (Computer Science)
- Software Engineering (Computer Science)
- SVAR Conversational - Spoken English
- HR Interview