← Course Detail

Database Management System (DBMS)

Computer Science

Chapter 1 — Introduction to DBMS

Progress: 2%

Lesson 1.2 : What is DBMS?

Reading & Interactive Lesson

Lesson 1.2 FREE

What is DBMS?

Reading Material & Notes

What is DBMS?

DBMS stands for Database Management System. It is software used to create, store, organize, retrieve and manage data in databases.

Functions of DBMS

Data storage and retrieval
Data modification
User authentication
Data security
Backup and recovery
Transaction management
Concurrency control

Examples of DBMS

MySQL
PostgreSQL
Oracle Database
Microsoft SQL Server
SQLite

Simple Example

A student management system can use a DBMS to store student names, roll numbers, courses, marks and attendance.

← Previous Lesson Next Lesson →

Course Curriculum

10 Chapters • 50 Lessons

View Course

Chapter 1 — Introduction to DBMS

5 Lessons

FREE

Lesson 1.1 : What is a Database?

Lesson 1.2 : What is DBMS?

Lesson 1.3 : Advantages of DBMS

Lesson 1.4 : File System vs DBMS

Lesson 1.5 : DBMS Applications

Chapter 2 — Database Architecture and Models

5 Lessons

FREE

Lesson 2.1 : Database Architecture

Lesson 2.2 : Three-Level Database Architecture

Lesson 2.3 : Database Models

Lesson 2.4 : DBMS Components

Lesson 2.5 : DBMS Advantages and Limitations

Chapter 3 — ER Model and ER Diagrams

5 Lessons

FREE

Lesson 3.1 : Introduction to the ER Model

Lesson 3.2 : Entities and Attributes

Lesson 3.3 : Relationships and Cardinality

Lesson 3.4 : ER Diagrams

Lesson 3.5 : Converting ER Diagrams to Tables

Chapter 4 — Relational Model and Keys

5 Lessons

LOCKED

Lesson 4.1 : Introduction to the Relational Model

ENROLL

Lesson 4.2 : Primary Keys and Candidate Keys

ENROLL

Lesson 4.3 : Foreign and Composite Keys

ENROLL

Lesson 4.4 : Integrity Constraints

ENROLL

Lesson 4.5 : Relational Algebra Basics

ENROLL

Chapter 5 — SQL Fundamentals

5 Lessons

LOCKED

Lesson 5.1 : Introduction to SQL

ENROLL

Lesson 5.2 : DDL Commands

ENROLL

Lesson 5.3 : DML Commands

ENROLL

Lesson 5.4 : DCL and TCL Commands

ENROLL

Lesson 5.5 : Creating Tables with SQL

ENROLL

Chapter 6 — SQL Queries and Functions

5 Lessons

LOCKED

Lesson 6.1 : SELECT Queries

ENROLL

Lesson 6.2 : WHERE, ORDER BY and GROUP BY

ENROLL

Lesson 6.3 : Aggregate Functions

ENROLL

Lesson 6.4 : String, Date and Numeric Functions

ENROLL

Lesson 6.5 : SQL CASE and Conditional Expressions

ENROLL

Chapter 7 — Joins, Subqueries and Views

5 Lessons

LOCKED

Lesson 7.1 : Introduction to SQL Joins

ENROLL

Lesson 7.2 : INNER and OUTER JOINS

ENROLL

Lesson 7.3 : Subqueries

ENROLL

Lesson 7.4 : Views

ENROLL

Lesson 7.5 : Practical Queries Using Joins and Subqueries

ENROLL

Chapter 8 — Normalization

5 Lessons

LOCKED

Lesson 8.1 : Introduction to Database Normalization

ENROLL

Lesson 8.2 : First Normal Form

ENROLL

Lesson 8.3 : Second Normal Form

ENROLL

Lesson 8.4 : Third Normal Form

ENROLL

Lesson 8.5 : Normalization and Denormalization

ENROLL

Chapter 9 — Transactions and Database Security

5 Lessons

LOCKED

Lesson 9.1 : Database Transactions

ENROLL

Lesson 9.2 : ACID Properties

ENROLL

Lesson 9.3 : Concurrency Control

ENROLL

Lesson 9.4 : Database Security

ENROLL

Lesson 9.5 : Backup and Recovery

ENROLL

Chapter 10 — Database Design and Practical Project

5 Lessons

LOCKED

Lesson 10.1 : Database Design Process

ENROLL

Lesson 10.2 : Designing a Student Database

ENROLL

Lesson 10.3 : Implementing the Database

ENROLL

Lesson 10.4 : Testing and Optimization

ENROLL

Lesson 10.5 : DBMS Practical Project

ENROLL

Database Management System (DBMS)

Chapters

Lessons

View Course Details