DBMS Lab

This lab course is based on the Practical implementation of concepts of database taught in  Database Management Systems (MIT 222).

Exercises given will be covering entire syllabi as follows:

1. Introduction to DBMS.

2. To implement different types of DDL, DML and DCL statements in SQL.

3. To use constraints on the created database.

4. To explore ‘select’ clause using where, order by, between, like, group by, having etc.

5. To implement different in-built functions on the created database.

6. To implement nested and correlated queries.

7.  To create PL/SQL blocks, looping.