DEPARTMENT OF COMPUTER APPLICATIONS

ONLINE CERTIFICATE COURSE-ESSENTIALS OF DATABASE MANAGEMENT SYSTEMS

After the completion of this course the students should be able to

l  Understand how the DBMS eliminate redundant data.

l  Understand the access to the data easy for the user.

l  Understand how DBMS protect the data from physical harm and un-authorised systems.

 

UNIT 1:

      Introduction to DBMS Data and Information - Database Database Management System Objectives - Advantages Components - Architecture.

UNIT 2:

       SQL: Overview Databases Syntax Data types Operators Expressions. ER Model: Building blocks of ER Diagram Relationship Degree Classification ER diagram to Tables.

UNIT 3:

     Types of SQL Commands: DDL-Create, Alter, Drop, Truncate, Comment, rename; DML-Insert, Update, delete; DCL-Grant, Revoke; TCL-Commit, Rollback, save point, Set transaction.

UNIT 4:

     Structure of Relational Database: Introduction to Relational Database Design - Objectives Tools. Relational Data Model- Advantages-Limitations-Integrity.

UNIT 5:

     SQL Clauses: Group by clause-Having Clause-Order by clause. Transaction Processing Database Security.