This subject will allow students to develop understanding of the basic concepts of data in general and Relational Database System in particular.

Database Management System or DBMS in short refers to the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures. It explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure and much more.

  • Undergraduates
  • Graduates
  • Working Professionals
  • Engineers

Database Concepts:

  • Overview of DBMS
  • Components of DBMS
  • Database Architecture
  • Types of Database Model
  • ER Model
  • The Extended ER Model
  • Codd’s 12 rule of RDBMS
  • Basic Concepts of RDBMS
  • Relational Algebra & Relational Calculus
  • ER Model to Relational Model
  • Introduction to Normalization

Basic SQL

  • SQL Intoduction
  • Create query
  • Alter query
  • Truncate, Drop and Rename query
  • All DML command, TCL Command, DCL Command
  • ORDER BY clause
  • Group BY clause
  • AND & OR operator
  • DIVISION operator

Advanced SQL

  • SQL Constraints
  • SQL function
  • SQL Join
  • SQL Alias
  • SQL SET operation
  • SQL Sequences
  • SQL Views
  1. Week Days: 8 WKS
  2. Week Ends: 5 WKS
  3. Tailored: Can be tailored as per batch requirement subject to possibility of time adjustment.
  • There is no pre-requisite to learn DBMS.