Advanced Diploma Course in Information TechnologyGuru Nanak Dev University
Price on request
The Guru Nanak Dev University's Faculty of Engineering and Technology offers Advanced Diploma Course in Information Technology to its students. The course structure for it is as follows:
DATABASE MANAGEMENT SYSTEMS THROUGH ORACLE 8
PROGRAMMING IN VISUAL BASIC AND ACTIVE – X
What is Database Management system, overview, Database Independence Architecture Levels of Architecture, Database Models and comparative study of models.
Domains and relations, Relational data integrity, relational algebra, calculus, SQL language.
SQL * PLUS
Introduction to Oracle 8
SQL – DDL, DML, DCL
Simple queries, Sub queries, Union, Intersection, Minus
Built in Functions, Data types, views, Sequences.
Introduction to PL/SQL
Cursors, Database Triggers
PRACTICALS OF SQL, PL/SQL