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: 

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 [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-0

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