List of Experiments / Activities
- 1Install oracle/ MYSQL.
- 2Create Entity-Relationship Diagram using case tools.
- 3Write SQL statements Using ORACLE /MYSQL: a) Write basic SQL SELECT statements. b) Restrict and sort data. c) Display data from multiple tables. d) Aggregate data using group function. e) Manipulate data. f) Create and manage tables.
- 4Create cursor.
- 5Create procedure and functions.
- 6Create packages and triggers.
- 7Design and implement any one: a) Payroll Processing System. b) Library Information System. c) Student Information System.
- Note: The instructor may add/delete/modify experiments, wherever he/she feels in a justified manner.
Course Outcomes (COs)
After completion of the course student will be able to:
- CO1Write SQL commands for DDL, DML and DCL.K5
- CO2Write SQL commands to query a database.K3
- CO3Write PL/SQL programs for implementing stored procedures, stored functions, cursors, trigger and packages.K4
Official AKTU syllabus
This subject is on page 37 of the original AKTU PDF.