Advanced Diploma Course in Information Technology
Diploma
In Amritsar
Description
-
Type
Diploma
-
Location
Amritsar
Facilities
Location
Start date
Start date
Reviews
Course programme
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
Basic Concepts;
What is Database Management system, overview, Database Independence Architecture Levels of Architecture, Database Models and comparative study of models.
Relational Model;
Domains and relations, Relational data integrity, relational algebra, calculus, SQL language.
Oracle 8
SQL * PLUS
Introduction to Oracle 8
SQL – DDL, DML, DCL
Simple queries, Sub queries, Union, Intersection, Minus
Built in Functions, Data types, views, Sequences.
PL/SQL
Introduction to PL/SQL
Cursors, Database Triggers
PRACTICALS OF SQL, PL/SQL
Advanced Diploma Course in Information Technology