Data Analysis and Design

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.