← Course Detail

Database Management System (DBMS)

Computer Science

Chapter 1 — Introduction to DBMS

Progress: 0%

Lesson 1.1 : What is a Database?

Reading & Interactive Lesson

Lesson 1.1 FREE

What is a Database?

Reading Material & Notes

What is a Database?

A database is an organized collection of related data that can be stored, managed and retrieved efficiently.

Examples of Databases

Student records
Employee information
Bank account records
Library books and members
Online shopping products and orders

Characteristics of a Database

Stores organized information.
Allows data retrieval.
Supports data modification.
Can handle large amounts of information.
Provides controlled access to data.

Example

A college database may contain tables for students, teachers, courses, departments and examination results.

← Course Detail 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