New batches start 11 August 2026. Enrol now →
Maruti AI Technology Enrol now

← Programming & Computer Science Foundations

Programming & Computer Science Foundations

DBMS

Database fundamentals through Oracle SQL, PL/SQL, and transaction management

Build a strong grip on database theory — data modelling, database design, and relational algebra — then apply it hands-on in Oracle, from retrieving and sorting data to joins, subqueries, DDL, DML, and constraints. The course closes with PL/SQL, transaction management, NoSQL databases, and data warehousing concepts.

39h
of content
23
modules
204
lessons
Fees from
₹3,000

per level · 3 levels · complete programme ₹12,500

Duration
4 mo
Enrol now Talk to us first

Fees by level

Start at any level, or take the complete programme. The fee you pay for a level is locked for you.

LevelWhat it coversDurationFee
Beginner Start from zero 1 mo ₹3,000
Intermediate Build working projects 1 mo ₹4,000
Advanced Get job-ready 2 mo ₹5,500
Complete programme (all levels) ₹12,500

All fees are in Indian Rupees and include applicable taxes. See our pricing & payment terms.

The complete curriculum

This is the entire syllabus — all 23 modules and 204 lessons, in the order you'll learn them. Nothing hidden.

↓ Download full curriculum (PDF)
01 Introduction 3 lessons ▶
  1. 1.1Concepts and Characteristics of DBMS
  2. 1.2History and Evolution of Database
  3. 1.3Database System Architecture
02 Data Modelling 20 lessons ▶
  1. 2.1Relational Database Model
  2. 2.2Entity Relationship Model
  3. 2.3Types of Attributes and their Symbols
  4. 2.4Connectivity of Relationships
  5. 2.5Degree of a Relationship
  6. 2.6Designing an ER Model
  7. 2.7Conversion from ER Model to Relational Model
  8. 2.8Conversion from ER Model to Relational Model_Composite Attributes
  9. 2.9Conversion from ER Model to Relational Model - Derived and Multi-valued Attributes
  10. 2.10Many to Many Relationship
  11. 2.11Many to One Relationships
  12. 2.12One to Many Relationships
  13. 2.13One to One Relationships
  14. 2.14Strong and Weak Entity Sets
  15. 2.15Strong and Weak Entity Sets_2
  16. 2.16Cardinality of a Relationship
  17. 2.17Total and Partial Participation
  18. 2.18Cardinality and Participation
  19. 2.19Examples
  20. 2.20Codd's Rules
03 Database Design 19 lessons ▶
  1. 3.1Data Independence
  2. 3.2Keys in DBMS
  3. 3.3Functional Dependence
  4. 3.4Inference Rules
  5. 3.5Closure of Functional Dependencies
  6. 3.6Minimal Cover
  7. 3.7Fully Functional Dependency
  8. 3.8Transitive Dependency
  9. 3.9Multi Valued Dependency
  10. 3.10Normalization Process
  11. 3.11Computer Center Case Study
  12. 3.12First Normal Form_1
  13. 3.13Anomalies of the First Normal Form
  14. 3.14First Normal Form_2
  15. 3.15Second Normal Form
  16. 3.161Third Normal Form
  17. 3.171Boyce Codd Normal Form
  18. 3.181Fourth Normal Form
  19. 3.191Fifth Normal Form
04 Relational Algebra 12 lessons ▶
  1. 4.1Relational Query Languages
  2. 4.2Basics of Relational Algebra
  3. 4.3Select Operation
  4. 4.4Projection Operation
  5. 4.5Rename Operation
  6. 4.6Union Operation
  7. 4.7Intersection Operation
  8. 4.8Set Difference Operation
  9. 4.9Cartesian Product Operation
  10. 4.10Joins
  11. 4.11Relational Algebra Queries_1
  12. 4.12Relational Algebra Queries_2
05 Oracle Introduction 3 lessons ▶
  1. 5.1Introduction
  2. 5.2DESCRIBE Command
  3. 5.3SQL Statement Basics
06 Oracle Retrieving Data 6 lessons ▶
  1. 6.1Select Statements
  2. 6.2Column Aliases
  3. 6.3Quote Operator
  4. 6.4DISTINCT and UNIQUE Operator
  5. 6.5Concatenation Operator
  6. 6.6Arithmetic Expressions
07 Oracle Receiving 8 lessons ▶
  1. 7.1WHERE Clause
  2. 7.2Comparison Operators
  3. 7.3BETWEEN ... AND Operator
  4. 7.4IN Operator
  5. 7.5LIKE Operator
  6. 7.6IS NULL Operator
  7. 7.7Logical Operators
  8. 7.8Rules of Precedence
08 Oracle Sorting Data 4 lessons ▶
  1. 8.1ORDER BY Clause
  2. 8.2ASC and DESC Operators
  3. 8.3NULLS FIRST and NULLS LAST
  4. 8.4ROWID and ROWNUM
09 Oracle Single-Row Functions 10 lessons ▶
  1. 9.1Single Row Functions
  2. 9.2Case Conversion Functions
  3. 9.3Character Manipulation Functions
  4. 9.4Numeric Functions
  5. 9.5Nested Functions
  6. 9.6Date Values and Formats
  7. 9.7Date Format Models
  8. 9.8Date Functions and Arithmetic Operators
  9. 9.9Date Manipulation Functions
  10. 9.10Number Format Models
10 Oracle Conversion Functions 4 lessons ▶
  1. 10.1Oracle Conversion Functions
  2. 10.2Implicit Conversion Examples
  3. 10.3TO_CHAR Function
  4. 10.4NVL, NVL2, NULLIF and COALESCE Functions
11 Oracle Group Functions 8 lessons ▶
  1. 11.1Group Functions
  2. 11.2AVG Function
  3. 11.3COUNT Function
  4. 11.4MAX Function
  5. 11.5MIN Function
  6. 11.6SUM Function
  7. 11.7LISTAGG Function
  8. 11.8Overview of Group Functions
12 Oracle Grouping Data 4 lessons ▶
  1. 12.1GROUP BY Clause - 1
  2. 12.2GROUP BY Clause - 2
  3. 12.3HAVING Clause
  4. 12.4Nested Group Functions
13 Oracle Joins 13 lessons ▶
  1. 13.1Join
  2. 13.2Creating a Join
  3. 13.3Natural Join
  4. 13.4Join with USING Clause
  5. 13.5Handling Ambiguous Column Names
  6. 13.6INNER Join
  7. 13.7Multiple Join Operations
  8. 13.8Restricting Joins
  9. 13.9SELF Join
  10. 13.10Non-Equijoins
  11. 13.11OUTER Joins
  12. 13.12CROSS Join
  13. 13.13Join Types
14 Oracle Subqueries 4 lessons ▶
  1. 14.1Subqueries
  2. 14.2Single Row Subqueries
  3. 14.3Multiple Row Subqueries
  4. 14.4Multiple Column Subqueries
15 Oracle Set Operators 7 lessons ▶
  1. 15.1SET Operators
  2. 15.2UNION and UNION ALL Operators
  3. 15.3INTERSECT Operator
  4. 15.4MINUS Operator
  5. 15.5Matching Unmatched Queries
  6. 15.6ORDER BY with SET Operators
  7. 15.7Combining Multiple Queries with SET Operators
16 Oracle DDL Commands 7 lessons ▶
  1. 16.1Data Definition Language
  2. 16.2Database Object Naming Rules
  3. 16.3CREATE TABLE Statement
  4. 16.4ALTER TABLE Statement
  5. 16.5DROP TABLE Command
  6. 16.6TRUNCATE TABLE Statement
  7. 16.7RENAME TABLE Statement
17 Oracle DML Commands 5 lessons ▶
  1. 17.1Data Manipulation Language
  2. 17.2INSERT Statement
  3. 17.3INSERT INTO SELECT Statement
  4. 17.4UPDATE Statement
  5. 17.5DELETE Statement
18 Oracle Constraints 6 lessons ▶
  1. 18.1Constraints
  2. 18.2NOT NULL Constraint
  3. 18.3UNIQUE Constraint
  4. 18.4Primary Key Constraint
  5. 18.5Foreign Key Constraint
  6. 18.6Check Constraint
19 Oracle PLSQL 4 lessons ▶
  1. 19.1Introduction
  2. 19.2Procedure
  3. 19.3Trigger
  4. 19.4Functions
20 Storage and Querying 15 lessons ▶
  1. 20.1Disk Management
  2. 20.2Pages and Blocks
  3. 20.3Time to Access a Page
  4. 20.4Heap Files
  5. 20.5Index and Index Structure
  6. 20.6Sorted Files
  7. 20.7Storage Structure
  8. 20.8Clustered Index
  9. 20.9Unclustered Index
  10. 20.10Problem on Cost of Range Search
  11. 20.11Sparse Versus Dense Index
  12. 20.12Two Level Index
  13. 20.13Multi Level Index
  14. 20.14Query Processing
  15. 20.15Query Optimization
21 Transaction Management 31 lessons ▶
  1. 21.1Transactions
  2. 21.2Concurrent Execution of Transactions
  3. 21.3Inconsistency Problem
  4. 21.4States of a Transaction
  5. 21.5ACID Properties
  6. 21.6Schedules
  7. 21.7Lost Update Problem
  8. 21.8Dirty Read Problem
  9. 21.9Unrepeatable Read Problem
  10. 21.10Phantom Read Problem
  11. 21.11Recoverable and Non-Recoverable Schedule
  12. 21.12Cascadeless and Cascading Schedules
  13. 21.13Recoverable and Cascadeless Schedules
  14. 21.14Example Problem
  15. 21.15Strict Schedule
  16. 21.16Recoverable, Cascadeless and Strict Schedules
  17. 21.17Important Point
  18. 21.18Equivalence of Schedules
  19. 21.19Conflicting Actions
  20. 21.20Conflict Equivalence and Equivalence of Schedules
  21. 21.21Conflict Serializability of a Schedule
  22. 21.22Test for Conflict Serializability
  23. 21.23Number of Conflict Serializable Schedules
  24. 21.24Example Problems
  25. 21.25View Equivalence and View Serializability
  26. 21.26Problems on View Serializability
  27. 21.27Additional Problems on View Serializability
  28. 21.28Shared and Exclusive Locking Protocol
  29. 21.29Two Phase Locking
  30. 21.30Strict and Rigorous Phase Locking Protocols
  31. 21.31Recovery Techniques
22 NoSQL Databases and Big Data Storage Systems 5 lessons ▶
  1. 22.1Introduction to NoSQL Databases
  2. 22.2Types of NoSQL Databases
  3. 22.3BASE Properties
  4. 22.4CAP Theorem
  5. 22.5Big Data
23 Data Warehousing 6 lessons ▶
  1. 23.1Introduction
  2. 23.2Components of Data Warehouse
  3. 23.3Data Warehouse Architecture
  4. 23.4Online Analytical Processing
  5. 23.5Online Transaction Processing
  6. 23.6OLAP Versus OLTP

Tools you'll use

SQL

Every course includes

Live, instructor-led classes Course materials & lab access Doubt-clearing sessions Final assessment + one free re-attempt Verifiable certificate

How certification works

Related courses

Programming & Computer Science Foundations

C++

Master C++ fundamentals — OOP, STL, and file streams — with hands-on practice

from ₹2,200· 3 levels
4 mo
Programming & Computer Science Foundations

Competitive Programming

Sharpen your competitive programming edge with STL, graphs, and dynamic programming

from ₹4,500· 3 levels
5 mo
Programming & Computer Science Foundations

DSA with C++

Data structures and algorithms in C++ — from arrays and linked lists to AVL trees

from ₹4,000· 3 levels
5 mo