The Queries to be implemented on DBMS by using SQL.

Write the queries for Data Definition and Data Manipulation language.
Write SQL queries using Logical operators (=,<,>,etc.).
Write SQL queries using SQL operators (Between…. AND, IN(List), Like, ISNULL and also with negating expressions ).
Write SQL query using character, number, date and group functions.
Write SQL queries for Relational Algebra (UNION, INTERSECT, and MINUS, etc.).
Write SQL queries for extracting data from more than one table (Equi-Join, Non-Equi-Join , Outer Join)
Write SQL queries for sub queries , nested queries.
Write programs by the use of PL/SQL.
Concepts for ROLL BACK, COMMIT & CHECK POINTS.
Create VIEWS, CURSORS, and TRIGGRS & write ASSERTIONS.
Create FORMS and REPORTS .
* Students are advised to use Developer 2000/Oracle-9i version or other latest version for above listed experiments. However depending upon the availability of software’s, students may use Power Builder /SQL SERVER. Mini Project may also be planned & carried out through out the semester to understand the important various concepts of Database.