DBMS LAB

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