Database Fundamentals/Manipulating Data

From Wikiversity
Jump to navigation Jump to search

This lesson introduces data manipulation.

Objectives and Skills[edit | edit source]

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[edit | edit source]

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

Multimedia[edit | edit source]

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

Activities[edit | edit source]

  1. Use SQL Server to update record information in the Student table in your College database.
  2. Write the following queries:

Lesson Summary[edit | edit source]

  • 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[edit | edit source]

insert
delete
referential integrity
transactions
update

See Also[edit | edit source]

References[edit | edit source]

Type classification: this is a lesson resource.