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 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