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

Home > DBMS LAB

DBMS LAB [1]

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

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

  • Familiarize with creation of databases
  • Create database objects
  • Modify / Manipulate database objects
  • Retrieve the data from the database server

 

CONTENTS

  1. SQL data types, Operators, Literals, Constraints
  1. DDL Commands: Create Tables/Create Synonym /Create index /Views / Alter /                         Drop/Truncate/Comment/Rename/DBCC (Database Console Commands)
  1. DML Commands:  Insert / Update / Delete / Merge/Lock Table
  1. TCL Commands: Commit / Rollback / Save-Points /Set Transaction
  1. DCL Commands: Grant / Revoke/Deny
  1. Simple Queries: Select / From / Where
  1. Group By/Having Clause
  1. Order By clause
  1. SQL Operators: Arithmetic / Logical /In / Like / Between
  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

 

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/dbms-lab-7

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