Data Analysis and Design: Comprehensive DML Commands and Functions

This report provides an overview of Data Manipulation Language (DML) commands used in data analysis and database management. It explains the purpose of DML in retrieving, updating, and deleting data, highlighting its advantages such as efficient data modification and portability. The report details key DML commands including SELECT, UPDATE, INSERT, and DELETE, along with their respective functions and practical applications. The INSERT command is explained with an example query. The DELETE and UPDATE functions are also discussed, demonstrating how to remove and modify data. Finally, the report provides examples of implementing these commands in SQL, along with references to relevant resources.

Data Analysis and Design

Introduction
It allows users to manipulate data in a database.
Data manipulation language can be used for the purpose
of retrieving, updating and deleting records of
database.
Record can insert into database by using "Insert
command”.

Advantages of DML
Modify the data stored in a database
Specify and search what data is needed.
Efficient human interaction with the system.
It runs in local systems, intranet and internet.
It is portable and can be moved from device
to another without any problems.
DML is widely used for the relational
databases.

Basic commands
SELECT: it is used to retrieve rows from a
table.
UPDATE: This command modifies data of one
or more records.
INSERT: it is employed to add one or more
records to a database table.
DELETE: it is applied to remove one or more

Operation perform by DML
Inserting data into database tables
Retrieving existing data
Deleting data from existing tables
Modifying existing data tables

Insert function
With help of this command, data can be
entered into database.
Query:
Insert into Speciliast_details values
(105,'Rocky Denam', 'Single', ‘Male’,
‘15/01/1975’, ‘Bermigam near loard stadium’,
400856428, ‘Passport and License’,
98256894231, ‘MBBS’, ‘Physician’, ‘NHS
certified’, £500 )

Delete function
By using this command, user will be able to
delete record from database.
DELETE FROM personal_info
WHERE Patient_id = 12345

Update function
It is used to modify information contained
within a table.
For example,
UPDATE personal_info
SET salary = salary * 1.03

Implementation of command in
SQLSelect * from Room_details
Insert into Room_details values (105,'Yes',
501, 4008534, ‘15/01/2015')
Delete from Room_details where Room_num
= 105;
Update Room_details
Set= Availability
Where Room_num= 105

References
Linoff, G., 2008. Data analysis using SQL. [Pdf].
Available through:<
http://www.temida.si/~bojan/MPS/materials/Data
%20Analysis%20Using%20SQL%20and%20Excel.pdf>.
[Accessed on: 4 November 2015].
Greenwals, R., Stackowiak, R. and Stern, J., 2013. Oracle
Essentials: Oracle Database 12c. O Reilly Media Inc.