INTRO TO MANAGING DATA

INTERACTIVE SQL

• THE ORACLE DATATYPES
• DATA MANIPULATION IN DBMS
• THE ORACLE DATATYPES
• 2-D MATRIX CREATION
• INSERTION OF DATA INTO TABLES
• UPDATING THE CONTENTS OF A TABLE
• DELETION OPERATIONS
• THE MANY FACES OF THE SELECT COMMAND
• MODIFYING THE STRUCTURE OF TABLES
• REMOVING/DELETING/DROPPING TABLES
• DATA CONSTRAINTS
• LOGICAL OPERATORS
• RANGE SEARCHING

PL/SQL

• INTRO
• THE PL/SQL ENVIRONMENT
• THE PL/SQL SYNTAX
• ORACLE TRANSACTIONS
• LOCKS
• CURSORS

STORED PROCEDURES

STORED FUNCTIONS

DATABASE TRIGGERS

Project Work:

The candidate will have to complete its project work based on the above curriculum in the time specified for it. This would totally a candidate’s effort under thee supervision of respective faculty member.

Examination:

The candidate is required to appear for tests/exams (theory & practical) for it as per the specified schedule in the premises of the institute itself, failing which no certificate will be issued to him/her.