Published on Computer Science & IT (https://www.csit.iisuniv.ac.in)

Home > Advanced DBMS LAB

Advanced DBMS LAB [1]

Paper Code: 
MCA 328
Credits: 
02
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

Objectives of the Laboratory:

Upon successful completion of this lab the student of this lab will be able to:

  1. Familiarize with creation of databases with constraints.
  2. To query the underlying database and perform DML operations.
  3. To understand the concepts of PL/SQL Programming.
  4. To be able to apply advanced concepts of PL/SQL like cursors, procedures and triggers.

 

CONTENTS

  1. SQL data types, Operators, Literals, Constraints
  1. DDL, DML, TCL, DCL Commands
  1. Queries: Select / From / Where/ Group By/Having Clause/ Order By Clause/ SQL Operators
  1. Functions: Aggregate / Numeric / String / Date & Time / Logical
  1. Joins: Equi-Join / Natural Join / Self Join / Inner Join / Outer Join
  1. Unions / Intersection / Minus
  1. Subqueries or Nested Queries
  1. PL/SQL Block Structure
  1. Conditional Statements
  1. Iterations
  1. Database Programming with record variables
  1. Cursors
  1. Procedures & Functions
  1. Triggers
  1. Packages

 

Academic Year: 
2015-16 [2]

Follow Computer Science & IT on:

IIS (Deemed to be University)

Gurukul Marg, SFS, Mansarovar, Jaipur 302020, (Raj.) India Phone:- +91-141-2400160-61, 2397906-07, Fax: 2395494, 2781158

Source URL: https://www.csit.iisuniv.ac.in/courses/subjects/advanced-dbms-lab-2

Links:
[1] https://www.csit.iisuniv.ac.in/courses/subjects/advanced-dbms-lab-2
[2] https://www.csit.iisuniv.ac.in/academic-year/2015-16