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)  Insert (SQL)
 * 2)  Update (SQL)
 * 3)  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:
 * 3) * Watch YouTube: How to Insert Into Table In Database.
 * 4) * Watch YouTube: How to Update Query in Database.
 * 5) * Watch YouTube: How to Delete Query in Database.
 * 6) * Read Microsoft: Changing Data in a Database].
 * 7) * Apply the INSERT statement in a query to insert a new record into the Student table.
 * 8) * Apply the UPDATE statement in a query to update the first name field in the previous step in the Student table.
 * 9) * 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