Data Manipulation-ict

DATABASE MANAGEMENT SYSTEM DATA MANIPULATION

LEARNING OBJECTIVES Student should be able :  List down the basic operation of data manipulation correctly.  Define each basic operations.

BASIC OPERATION OF DATA MANIPULATION Update  Insert  Delete  Retrieve  Sort  Filter  Search 

Update  The process that saves changes to data in a record. Until the record is saved, changes are stored in a temporary record called the copy buffer. The UPDATE clause in an SQL statement changes data values in one or more records (rows) in a database table.

Delete  Useful when you want to delete many records

Insert  Adds a record or multiple records to a table.

Retrieve  To get back the data

Sort  A sequencing principle used to order data, alphabetically or numerically. The sort order can be either ascending or descending

Filter  A set of criteria applied to records in order to create a subset of the records.

Search  To find a record in database

CONCLUSION…??