Advanced DBMS Lab

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

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: 
2018-19
  • Printer-friendly version