Objective: Understanding of efficient database storage and query optimization methods

Tools Used: Oracle

Outcome: Students will be able to analyze and implement DDL, DML Queries, Procedures, conditional programming and loops, error handling, Checkpoints, triggers and cursors.

This lab helps the students to learn about managing Database Structure, Controls Access to Data and Structuring Queries and updation of the databases. We work on basically three types of commands DDl, DML and TCL. There are two essential purposes of a database language - to create & edit the database and to perform queries. These tasks are accomplished by users of SQL and SQL powered applications with generally greater ease and efficiency.