KEMBAR78
SQL Lab Guide for Students | PDF
Scribd
Upload
92 views6 pages

SQL Lab Guide for Students

This document is a lab file submitted by a student named Arnav Preet for the Database Management Systems lab course at Delhi Technological University. It details Experiment 5 which aims to implement the Data Manipulation Language (DML) in SQL. The key DML commands - SELECT, INSERT, UPDATE, DELETE - are explained and examples are provided of creating a table and using each command to retrieve, add, modify and remove records from the table. The conclusion states that this experiment taught the use of DML commands to work with a database based on an entity-relationship model.

Uploaded by

arnav preet
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
92 views6 pages

SQL Lab Guide for Students

This document is a lab file submitted by a student named Arnav Preet for the Database Management Systems lab course at Delhi Technological University. It details Experiment 5 which aims to implement the Data Manipulation Language (DML) in SQL. The key DML commands - SELECT, INSERT, UPDATE, DELETE - are explained and examples are provided of creating a table and using each command to retrieve, add, modify and remove records from the table. The conclusion states that this experiment taught the use of DML commands to work with a database based on an entity-relationship model.

Uploaded by

arnav preet
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/ 6

DELHI TECHNOLOGICAL UNIVERSITY

CO203 – DATABASE MANAGEMENT


SYSTEMS LAB FILE

Submitted to: Rohit Beniwal Submitted by: Arnav Preet


COE Department
2k18/CO/089
G1/A2 , COE
INDEX

S.NO. EXPERIMENT DATE REMARKS SIGNATURE


Experiment 5

Objective:
To implement data manipulation language (DML)
REQUIREMENTS:

Relational Schema, Web Browser- Google Chrome, SQL Tryit Editor v1.6 - W3Schools

THEORY:

SQL is a standard language for storing, manipulating and retrieving data in databases.

● SQL stands for Structured Query Language


● SQL lets you access and manipulate databases
● SQL became a standard of the American National Standards Institute (ANSI) in
1986, and of the International Organization for Standardization (ISO) in 1987
What Can SQL do?
● SQL can execute queries against a database
● SQL can retrieve data from a database
● SQL can insert records in a database
● SQL can update records in a database
● SQL can delete records from a database
● SQL can create new databases
● SQL can create new tables in a database
● SQL can create stored procedures in a database
● SQL can create views in a database
● SQL can set permissions on tables, procedures, and views

SQL Commands:

The standard SQL commands to interact with relational databases are CREATE,
SELECT, INSERT, UPDATE, DELETE and DROP. These commands can be
classified into the following groups based on their nature –
Data Manipulation
Language
Comman Descriptio
d n
SELECT Retrieves certain records from one or more tables.

UPDATE Modifies records.

INSERT Creates a record.

DELETE Deletes records.

Creating Table:

Inserting Values:
Delete Command:

Update Command:
CONCLUSION:
In this experiment, we learnt about SQL and the various commands available. We made
use of DML commands in order to create and make changes in the database according to
the ER model created. We saw how we can create, update, insert values into and delete
certain values from the table using various SQL commands.

You might also like