Database Management Essentials
Mr. Om Ashrit Patel (RA2211026030067)
Mr. Chiranjit Dutta
May 2025
NPTEL COURSE
On
Database Management Essentials
Course Overview
• Authorized by: University of Colorado System
• Instructor: Professor Michael Mannino
• Platform: Coursera
• Focus: Fundamentals of database systems,
design, and management
Why Learn Database Management?
• Ubiquity of data-driven systems
• Essential for data analysis, applications, and
business decisions
• Backbone of information systems
Database Concepts
• What is a database?
• Database vs Spreadsheet
• Types: Relational, NoSQL, Object-oriented
Relational Database Model
• Tables (Relations)
• Rows (Tuples)
• Columns (Attributes)
• Primary & Foreign Keys
Database Management System
(DBMS)
• Functions of a DBMS
• Examples: MySQL, PostgreSQL, Oracle, SQL
Server
• Data abstraction and independence
Entity-Relationship (ER) Modeling
• Purpose of ER Models
• Entities, Attributes, Relationships
• Example ER Diagram
ER to Relational Mapping
• Converting entities and relationships into
tables
• Handling one-to-many, many-to-many
relationships
• Example conversion
Keys and Constraints
• Super Key, Candidate Key, Primary Key
• Foreign Key
• Referential Integrity
SQL - Structured Query Language
• Purpose and importance
• Categories: DDL, DML, DCL, TCL
• Overview of syntax
SQL Queries – Basics
• SELECT, FROM, WHERE
• Filtering and Sorting data
• Aggregate functions: COUNT, SUM, AVG
Advanced SQL
• JOIN types: INNER, LEFT, RIGHT, FULL
• Subqueries and Nested queries
• GROUP BY, HAVING
Normalization
• Purpose: eliminate redundancy
• 1NF, 2NF, 3NF (with examples)
• Trade-offs of normalization
Transaction Management
• What is a transaction?
• ACID Properties (Atomicity, Consistency,
Isolation, Durability)
• Example of a transaction
Concurrency Control
• Issues in concurrent transactions
• Locking mechanisms
• Deadlocks and prevention
Database Security
• User roles and permissions
• SQL injection and prevention
• Encryption and access controls
Indexing and Performance
• What is an index?
• Types of indexing
• Impact on performance
Backup and Recovery
• Backup strategies
• Recovery techniques
• Importance in business continuity
Real-World Applications
• E-commerce databases
• Banking systems
• Health care information systems
Course Reflection & Certificate
• Summary of key learnings
• Skills gained: data modeling, SQL,
normalization, transactions
• Display of certificate and verification link