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

Home > DBMS LAB

DBMS LAB [1]

Paper Code: 
MCA 127
Credits: 
2
Periods/week: 
4
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

1. SQL data types, Operators, Literals, Constraints
2. DDL Commands: Create Tables/Create Synonym /Create index /Views / Alter / Drop/Truncate/Comment/Rename/DBCC (Database Console Commands)
3. DML Commands:  Insert / Update / Delete / Merge/Lock Table
4. TCL Commands: Commit / Rollback / Save-Points /Set Transaction
5. DCL Commands: Grant / Revoke/Deny
6. Simple Queries: Select / From / Where
7. Group By/Having Clause
8. Order By clause
9. SQL Operators: Arithmetic / Logical /In / Like / Between
10. Functions: Aggregate / Numeric / String / Date & Time / Logical
11. Joins: Equi-Join / Natural Join / Self Join / Inner Join / Outer Join
12. Unions / Intersection / Minus
13. Subqueries or Nested Queries
 

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

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