Department of Information Science and Engineering offers database Laboratory in V semester. Students will learn all strong basic of VB SQL plus Languages.
Implement Basic DDL, DML and DCL commands
Understand Data selection and operators used in queries and restrict data retrieval and control the display order
Write sub queries and understand their purpose
Use Aggregate and group functions to summarize data
Join multiple tables using different types of joins
Understand the PL/SQL architecture and write PL/SQL code for procedures, triggers, cursors, exception handling etc
Reports generation is done using VB 6.0 application software
Facilities Available This lab consists of 30 Computers and individual Student is allotted a single Computer where each student can work efficiently and write the programs
individually for the problems statement. Students will be thought how to install SQLPLUS Software and VB 6.0 softwares.