EthicsComputerCourses
Join training

Web Development Build websites and web apps, from your first HTML page to React and Next.js.

Backend Development Server-side apps and APIs with Node.js, PHP, Django, Spring Boot and ASP.NET Core.

Programming Languages Core languages for college, coding interviews and real projects.

Mobile Development Build Android and iOS apps with Flutter and Swift.

Computer Science Core Operating systems, networks, DBMS and system design for college, GATE and interviews.

Databases Store, query and design data with SQL, PostgreSQL and MongoDB.

Data Science & AI Statistics, data analysis, dashboards and machine learning.

Cloud, DevOps & Testing Containers, Kubernetes, the cloud and software testing.

Security & Systems Protect systems and work confidently on Linux servers.

IoT & Electronics Build smart devices with Arduino, sensors and Raspberry Pi.

Office, Accounts & Career Computer basics, Excel, Tally with GST and digital marketing for jobs and business.

New to coding? Start with Intro to Programming Browse all 68 tutorials
EthicsComputerCourses
Join training +91 90532 10052
  1. Tutorials
  2. DBMS Tutorial

DBMS Tutorial

Understand how databases really work: ER design, keys, normal forms, transactions, indexing and recovery, with SQL you can run.

32 free lessons Beginner to Advanced Covers University and GATE DBMS syllabus with SQL examples (2026)

Start the first lesson

Getting Started Beginner

  1. 1DBMS Introduction
  2. 2File Systems vs DBMS
  3. 3DBMS Architecture & Data Independence
  4. 4Data Models, Schemas & Instances

The ER Model Beginner

  1. 5ER Model: Entities & Attributes
  2. 6Relationships, Cardinality & Participation
  3. 7Weak Entities, Generalisation & Aggregation
  4. 8Converting an ER Diagram to Tables

The Relational Model Beginner

  1. 9The Relational Model
  2. 10Keys: Super, Candidate, Primary, Foreign & Alternate
  3. 11Integrity Constraints
  4. 12Relational Algebra: Select, Project & Set Operations
  5. 13Relational Algebra: Joins & Division
  6. 14Relational Calculus
  7. 15SQL: The Practical Side of DBMS

Normalisation Intermediate

  1. 16Functional Dependencies
  2. 17Attribute Closure & Canonical Cover
  3. 18Normal Forms: 1NF, 2NF & 3NF
  4. 19BCNF, 4NF & 5NF
  5. 20Lossless Join & Dependency Preservation

Transactions & Concurrency Intermediate

  1. 21Transactions & ACID Properties
  2. 22Schedules, Serialisability & Recoverability
  3. 23Concurrency Control: Locks & Two-Phase Locking
  4. 24Timestamp Ordering & Deadlocks
  5. 25Recovery: Logs, Checkpoints & Shadow Paging

Storage, Indexing & Queries Advanced

  1. 26File Organisation & Indexing
  2. 27B-Trees, B+ Trees & Hashing
  3. 28Query Processing & Optimisation

Beyond One Database Advanced

  1. 29NoSQL vs Relational Databases
  2. 30Distributed Databases & the CAP Theorem

Exam Practice & Project Project

  1. 31GATE-style DBMS Problems Explained
  2. 32Project: College Management Database

Learn DBMS with a mentor

Free lessons get you started. Our Computer Science Fundamentals training adds real projects and code reviews from working developers.

  • Project-based learning
  • Mentor code reviews
  • Free counselling call
Get course details +91 90532 10052