Scribd
Upload
9 views

Dbms Lab_list of Experiments

The document outlines the experiments for the Database Management Systems Lab (CAP1231) in the Department of Computer Applications. It includes a list of 12 experiments covering various SQL concepts such as DDL, DML, constraints, joins, subqueries, views, and PL/SQL program development. Each experiment focuses on specific skills and commands essential for database management.

Uploaded by

8c45969zp6
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views

Dbms Lab_list of Experiments

The document outlines the experiments for the Database Management Systems Lab (CAP1231) in the Department of Computer Applications. It includes a list of 12 experiments covering various SQL concepts such as DDL, DML, constraints, joins, subqueries, views, and PL/SQL program development. Each experiment focuses on specific skills and commands essential for database management.

Uploaded by

8c45969zp6
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

-Database Management Systems Lab (CAP1231)

Department of Computer Applications

LIST OF EXPERIMENTS

LAB NO. Name of Experiment


1-2 Introduction to basic DDL, DML commands and domain types in SQL.
DDL statements to create, drop, alter, view and rename the Database.
3 DDL
• Creating Tables • Using Data Types • Modifying a Table
4-5 Constraints
• Intro to Constraints; NOT NULL and UNIQUE Constraints
• PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
• Managing Constraints
6 DML
• INSERT Statements
• Updating Column Values and Deleting Rows
• DEFAULT Values, MERGE, and Multi-Table Inserts
7 SELECT and WHERE
• Columns, Characters, and Rows • Limit Rows Selected • Comparison
Operators
8 WHERE, ORDER BY, and Intro to Functions
• Logical Comparisons and Precedence Rules
• Sorting Rows
• Introduction to Group Functions
• COUNT, DISTINCT, NVL, AVG, MAX, MIN
• Using Group By and Having Clauses
9 JOINs
• Cross Joins and Natural Joins • Inner Joins • Self-Joins
• Equijoin and Cartesian Product • No equijoins and Outer Joins
10 Subqueries
• Fundamentals of Subqueries • Single-Row Subqueries
• Multiple-Row Subqueries • Correlated Subqueries
11 Views
• Creating Views • DML Operations and Views • Managing Views Triggers
• Stored Procedure
• Database Transactions

12 PL/SQL: Program Development

You might also like