AIEM-P : One of the Best Private Polytechnic College in West Bengal

Creating & Executing DDL in SQL.
Creating & Executing Integrity constraints in SQL.
Creating & Executing DML in SQL. Executing relational, logical and mathematical set operators using SQL.
Executing group functions Executing string operators & string functions.
Executing Date & Time functions. Executing Data Conversion functions. Executing DCL in SQL.
Executing Sequences and synonyms in SQL.
Program for declaring and using variables and constant using PL/SQL.
Program using if then else in PL/SQL.
Program using for loop & while loop in PL/SQL.
Program using nested loop in Pl/SQL.
Employee database display an employee matching a given condition, duplicate records, delete rows using triggers,insert and update records, find net salary, etc.
Students' Academic database consisting of relevant tables to handle simple queries with PL/SQL.
Inventory Management System database. Do related activities such as prepare E-R Model, Relational Model, do Normalization, Create Tables, Insert data, Delete Data, Query database, create stored procedures, etc.
Bus Operator (Roadways) Do related activities such as prepare E-R Model, Relational Model, do Normalization, Create Tables, Insert data, Delete Data, Query database, create stored procedures, etc.

back

ESTD-2015
EIET
AIEM-P