Database Fundamentals/Manipulating Data

This lesson introduces data manipulation.

Objectives and Skills

Objectives and skills for the data manipulation portion of Microsoft Exam 98-364 Database Fundamentals include:^[1]

• Manipulate data
  • Insert data
    • Understand how data is inserted into a database, how to use INSERT statements
  • Update data
    • Understand 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
  • Delete data
    • Delete data from single or multiple tables, ensure data and referential integrity by using transactions

Readings

1. Read Wikipedia: Insert (SQL).
2. Read Wikipedia: Update (SQL).
3. Read Wikipedia: Delete (SQL).

Multimedia

1. Watch Microsoft Virtual Academy: Using DML Statements.
2. Watch YouTube: SQL INSERT, UPDATE, and DELETE.
3. Watch YouTube: ACID Principles.

Activities

1. Use SQL Server to update record information in the Student table in your College database.
2. Write the following queries:
   • Watch YouTube: How to Insert Into Table In Database.
   • Watch YouTube: How to Update Query in Database.
   • Watch YouTube: How to Delete Query in Database.
   • Read Microsoft: Changing Data in a Database].
   • Apply the INSERT statement in a query to insert a new record into the Student table.
   • Apply the UPDATE statement in a query to update the first name field in the previous step in the Student table.
   • Apply the DELETE statement in a query to remove the record that you just added in the Student table.

Lesson Summary

• A DELETE statement removes one or more records from a table.^[2]
• An INSERT statement adds one or more records to any single table in a relational database.^[3]
• Referential integrity is a property of data which, when satisfied, requires every value of one attribute (column) of a relation (table) to exist as a value of another attribute (column) in a different (or the same) relation (table).^[4]
• A transaction symbolizes a unit of work performed within a database management system (or similar system) against a database. A transaction generally represents any change in database.^[5]
• An UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition.^[6]

Key Terms

insert

delete

referential integrity

transactions

update

References

Resource type: this resource is a lesson.