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:

• 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. Wikipedia: Insert (SQL)
2. Wikipedia: Update (SQL)
3. Wikipedia: Delete (SQL)

Multimedia

1. Microsoft Virtual Academy: Using DML Statements
2. YouTube: SQL INSERT, UPDATE, and DELETE
3. 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 [1] 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.
• An INSERT statement adds one or more records to any single table in a relational database.
• 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).
• 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.
• 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.

Key Terms

insert

delete

referential integrity

transactions

update

References

Type classification: this is a lesson resource.

← Selecting Data

Database Fundamentals

Views →