KEMBAR78
Dbms Index | PDF | Databases | Sql
Scribd
Upload
26 views4 pages

Dbms Index

This document is a laboratory completion certificate for a student in the B.Tech program at JSPM University Pune, specifically for the Database Management System course. It outlines various SQL experiments that the student has completed, including DDL and DML commands, functions, operators, joins, and database management tasks. The document includes sections for signatures from course teachers and examiners, as well as an index of experiments with corresponding details.

Uploaded by

sonawanelitesh92
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
26 views4 pages

Dbms Index

This document is a laboratory completion certificate for a student in the B.Tech program at JSPM University Pune, specifically for the Database Management System course. It outlines various SQL experiments that the student has completed, including DDL and DML commands, functions, operators, joins, and database management tasks. The document includes sections for signatures from course teachers and examiners, as well as an index of experiments with corresponding details.

Uploaded by

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

Class: _____ B.Tech.

(CSE/IT/AIML/DS)
Course Name: ____________________
Course Code: _____________________

Semester: ___ Academic Year: _________

Name:

Division:

PRN No.:
JSPM UNIVERSITY PUNE
FACULTY OF SCIENCE AND TECHNOLOGY
SCHOOL OF COMPUTATIONAL SCIENCES

This is to satisfy that Mr./Ms _________________________ having


PRN _____________ of class T.Y. BTech (CSE/IT/AIML/DS) DIV (E)
semester from School of Computational Sciences has
satisfactorily completed_________________laboratory with the
course code during academic year 2024-2025

Course Teacher Program Coordinator

Internal Examiner External Examiner


INDEX

PRN No: Course Name: Database Management System


Course Code :

Exp. Sign of
No. Title of Experiment Page No. Date Course
Teacher

01. Implementation of DDL commands of SQL with


suitable examples
• Create able
• Alter Table
• Drop Table
02. Implementation of DML commands of SQL with
suitable examples
• Insert
• Update
• Delete

03. Implementation of different types of function with


suitable examples
• Number function
• Aggregate Function
• Character Function
• Conversion Function
• Date Function

04. Implementation of different types of operators in SQL

• Arithmetic Operators
• Logical Operators
• Comparison Operator
• Special Operator
• Set Operation
05. Implementation of different types of Joins

• Inner Join
• Outer Join
• Natural Join etc..

06. Study and Implementation of

• Group By & having clause


• Order by clause
• Indexing

07. Study & Implementation of

• Sub queries
• Views

08. Study & Implementation of different types of


constraints.

09. Study & Implementation of Database Backup &


Recovery commands. Study & Implementation of
Rollback, Commit, Savepoint.

10. Creating Database /Table Space

• Managing Users: Create User, Delete User


• Managing roles:-Grant, Revoke.

You might also like