Advanced DBMS LAB

Paper Code: 
MCA 328
Credits: 
02
Periods/week: 
04
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.
Unit I: 
CONTENTS
  1. SQL data types, Operators, Literals, Constraints
  2. DDL, DML, TCL, DCL Commands
  3. Queries: Select / From / Where/ Group By/Having Clause/ Order By Clause/ SQL Operators
  4. Functions: Aggregate / Numeric / String / Date & Time / Logical
  5. Joins: Equi-Join / Natural Join / Self Join / Inner Join / Outer Join
  6. Unions / Intersection / Minus
  7. Subqueries or Nested Queries
  8. PL/SQL Block Structure
  9. Conditional Statements
  10. Iterations
  11. Database Programming with record variables
  12. Cursors
  13. Procedures & Functions
  14. Triggers
  15. Packages

 

Academic Year: 
2017-18
  • Printer-friendly version