Certificates shipped for course completion till 25th of the last month.

Select Your Style

Choose your layout

Color scheme

Fundamentals of Database System

Fundamentals of Database System

Fundamentals of Database System

About the course

Professor Arnab Bhattacharya, a faculty of the department of Computer Science and Engineering, Indian Institute of Technology, Kanpur, has designed this fundamental course on Database Systems. This course is all about the fundamentals database which forms the core of all successful digital systems. Dr. Bhattacharya has worked with our development team to create the quality course content for programming aspirants. This course comprises of video lectures which can be viewed online and offline as per the convenience of the user.

The unique thing about this course is that, this covers the the basics of database systems. In addition to the traditional relational database systems, it will also introduce briefly the new paradigm of NoSQL databases used in big data systems. The topics will cover all important aspects including normalization, query processing and transactions. Since database is the backbone of any desktop or web application, learning the fundamentals of database system will be greatest advantage for the users.


Advantages of learning this course
Target Audience
Why learn DBA/DBMS?
Course Features
Test & Evaluation
  • Timeline
  • Scholarship Details

Please Login or Register to fill the Scholarship form.

Scholarship Application

Under Graduate

Post Graduate



Other Information


*CGPA to percentage conversion formula:

Equivalent Percentage = CGPA obtained X 9.5 X (10/CGPA Scale)
Example: If CGPA obtained is 8.00 on the scale of 10, then Equivalent
percentage will be 8.00 X 9.5 X (10/10) = 76%,
or If CGPA is 3.7 out of 4, then Equivalent percentage will be 3.7 X 9.5 X (10/4) = 87.88%


We urge you to provide correct information to your best knowledge. Certificates will be withheld if found that you have misrepresented any data / information.


  1. Introduction to Databases

  2. Relational Data Model

  3. Relational Algebra - Basic Operators

  4. Relational Algebra - Composition of Operators

  5. Relational Algebra- Additional Operators

  6. Relational Algebra - Extended Relational Algebra

  7. Relational Algebra: Database Modifications

  8. SQL: Introduction and Data Definition

  9. SQL: Basic Queries

  10. SQL: Advanced Queries

  11. SQL: Updates, Joins, Views and Triggers

  12. Normalization Theory: Motivation

  13. Normalization Theory: 1 NF and 2NF

  14. Normalization Theory: 3NF

  15. Normalization Theory: BCNF

  16. Normalization Theory: MVD

  17. Physical Design

  18. Database Indexing: Hashing

  19. Database Indexing: Tree-based Indexing

  20. Query Processing: Selection

  21. Query Processing: Sorting

  22. Query Processing: Nested-Loop joins and Merge join

  23. Query Processing: Hash Join and Other Operations

  24. Query Optimization: Equivalent Expressions and Simple Equivalence Rules

  25. Query Optimization: Complex Equivalence Rules

  26. Query Optimization: Join Order

  27. Query Optimization: Heuristics and Sizes

  28. Database Transactions: Properties and failures

  29. Database Transactions: States and Systems

  30. Recovery Systems : Deferred Database Modification

  31. Recovery Systems : Immediate Database Modification

  32. Recovery Systems : Check pointing and Shadow Paging

  33. Schedules : Introduction

  34. Schedules : Conflict Serializability

  35. Schedules: View Serializability

  36. Schedules : Result Equivalence and Testing for Serializabitlity

  37. Schedules: Recoverability

  38. Concurrency Control: Locks

  39. Concurrency Control: Two-phase Locking Protocol

  40. Concurrency Control: Timestamp Ordering Protocol

  41. Concurrency Control: Validation-based Protocol

  42. Concurrency Control: Multiple Granularity for Locks

  43. Concurrency Control: Deadlock Prevention and Deadlock Detection

  44. Concurrency Control: Deadlock Recovery and Update Operations

  45. Fundamentals of Database System - Final Quiz