3. Oracle 8i on Linux
Duration: 1 month
Fees: Rs. 3,000/-
Eligibility: BTech/diploma/degree with basic database knowledge.
course contents:
Overview of ORACLE 8i- The relational database
User accounts and privileges Architecture of oracle rdbms
ORACLE DATA TYPES
MANIPULATING DATA WITH SQL
SQL PLUS - Sqlplus commands - DDL - CREATE, DROP, ALTER etc. commands.
DML - INSERT, UPDATE, DELETE etc. commands.
DCL - GRANT, REVOKE etc. commands.
DATA CONSTRAINTS: Primary key Foreign key References Check
SQL FUNCTIONS
VIEWS, SUBQUERIES GROUP BY AND HAVING JOINS UNION, INTERSECT, MINUS
PL/SQL programming
CURSOR MANAGEMENT DATABASES TRIGGERS SUBPROGRAMS
PROCEDURES, FUNCTIONS, Packages
Project.