DBMS Notes
CSE DBMS Course

Learn Database Management Systems

Everything you need to understand databases—from basic concepts to advanced topics. Built to help you actually learn, not just memorize.

Jump into Unit 1View Full Syllabus

What you'll learn

The course covers everything from data modeling to transaction management.

Learning Goals

  • CLO01Have a broad understanding of database concepts and database management system software
  • CLO02Have a high-level understanding of major DBMS components and their function
  • CLO03Be able to model an application's data requirements using conceptual modeling tools like ER diagrams and design database schemas based on the conceptual model.
  • CLO04Be able to write SQL commands to create tables and indexes, insert/update/delete data, and query data in a relational DBMS.
  • CLO05Be able to program a data-intensive application using DBMS APIs.

Skills You'll Build

  • CO01Identify the basic concepts and various data model used in database design ER modelling concepts and architecture use and design queries using SQL
  • CO02Apply relational database theory and be able to describe relational algebra expression, tuple and domain relation expression from queries.
  • CO03Recognize and identify the use of normalization and functional dependency. indexing and hashing technique used in database design.
  • CO04Recognize/ Identify the purpose of query processing and optimization and also demonstrate the basic of query evaluation.
  • CO05Apply and relate the concept of transaction, concurrency control and recovery in database.
  • CO06Understanding of recovery system and be familiar with introduction to web database, distribute databases, data warehousing and mining.

Course content

Five units covering the complete DBMS curriculum

1

UNIT I: Introduction & Architecture

2 topics

Introduction to DatabaseDatabase System Architecture
2

UNIT II: Data Models & Query Languages

2 topics

Data ModelsRelational Query Languages
3

UNIT III: Relational Database Design

2 topics

Relational Database DesignQuery Processing and Optimization
4

UNIT IV: Storage & Transactions

2 topics

Storage StrategiesTransaction Processing
5

UNIT V: Security & Advanced Topics

2 topics

Database SecurityAdvanced Topics