mca Syllabus

DBMS Lab
Code: IT 694
Contacts: 3P
Credits: 2

SQL :
1. Creating , altering and dropping tables with integrity constraints.
2. Retrieving and modifying data from a database .
3. Retrieving data from database using IN, BETWEEN, LIKE , ORDER BY, GROUP BY and HAVING clause .
4.Use of scalar and aggregate functions.
5.Retrieving data from a database using Equi , Non Equi , Outer and Self Join.
6.Using subqueries , rowid and rownum for retrieving data.
7. Use of views , indexes and sequences.

PL/SQL:
8. Introduction to PL/SQL , using output from server.
9. Use of implicit & explicit cursors in data handling.
10. Exception handling – Oracle defined and User defined.
11. Use of stored procedures & functions in data manipulation.
12. Use of trigger in data manipulation.

Text Books:
1. Ivan Bayross , SQL , PL /SQL – The Programming Language of Oracle , BPB Press.
2. Steven Feuerstein , Oracle PL/SQL Programming, Shroff Publishers ,Calcutta.

Reference:
1.Kevin Loney & George Koch ,Oracle 9i – The Complete Reference , Oracle Press .