Exam 98-364: Database Fundamentals/Manipulating Data
This lesson covers Manipulating Data. It looks at selecting, inserting, updating, and deleting data.
Activity 1 - Select Data
editThis objective may include but is not limited to: utilizing SELECT queries to extract data from one table; extracting data by using joins; combining result sets by using UNION and INTERSECT.
- Read SELECT Statement for Data Queries.
- Read SELECT.
- Read WHERE Clause.
- Read Query Fundamentals.
Activity 2 - Insert Data
editThis objective may include but is not limited to: understanding how data is inserted into a database; how to use INSERT statements.
Activity 3 - Update Data
editThis objective may include but is not limited to: understanding how data is updated in a database and how to write the updated data to the database by using the appropriate UPDATE statements; update by using a table.
- Read UPDATE.
- Read Using CASE.
Activity 4 - Delete Data
editThis objective may include but is not limited to: deleting data from single or multiple tables; ensuring data and referential integrity by using transactions.
- Read How to: Delete Records in a Database.
- Read Transactions.