Database Lab Syllabus

A Hunt for Reaching Horizon of Science

Syllabus

1.SQL

1 a.Creating Database (Exercising commands like DDL,DML,DCL and TCL)

1 b.Exercising all types of Joins

1 c.Creating tables in I Normal, II Normal, III Normal and BCNF Form.

1 d.Creating table using combination of constraints.

1 e.Exercising Simple to Complex Queries

1 f.Usage of Stored Functions.

1 g.Creating Password and Security features for an Application.

1 h.Usage of File locking, Table locking facilities in an Applications

2 PL/SQL

 2 a)Demonstration of Blocks, Cursors, Procedures, Functions and Packages.

2 b)Demonstrate Exception Handling .

2 c)Usage of Triggers to perform operation on Single and Multiple Tables.

2 d)PL/SQL Procedures for data validation

3. Report Generation Using SQL Reports

 

4 Creation of Small Full pledged Database Application

 

Note : The creation of sample database for the purpose of the experiments is Expected to be pre-decided by the instructor.
Suggested Reading :
1.Nilesh Shah,
2.Rick F Van der Lans,
3.Benjamin Rosenzweig, Elena Silvestrova,
4.Albert Lulushi,