Syllabus Detail

• Data manipulation. 12 ATAR

Background

• To manipulate data means to change or process information
• Data can be manipulated in order to make it easier to read, to organize certain elements or to change the information completely
• The manipulation of data is common in applications such as websites, where data is concurrently being selected and updated, or even inserted or deleted
• Data manipulation langauges (DML's) such as SQL are utilised to manipulate data from sources such as databases

Common DML Commands

• SELECT: This command is used to ouput a list of rows (or record) from a database.
  
  • Syntax: SELECT [x] FROM [y] WHERE [z]
• UPDATE: This command is used to alter the data from one or more tables.
  • Syntax: UPDATE [x] SET [y] WHERE [z]
• INSERT: This command is used to add one or more entries to a database table.
  • Syntax: INSERT INTO [x] [y] VALUES [z]
• DELETE: This command removes one or more entries from a database table depending on the conditions.
  • Syntax: DELETE FROM [y] WHERE [z]

Further Research

• Read more about Data Manipulation Languages here
• View from common DML commands from Microsoft here

Worksheet and Practice (yet to be added)

Found an error or have an enhancement? Please let us know via this contact form