Database Fundamentals/Manipulating Data
This lesson introduces data manipulation.
Objectives and Skills
editObjectives 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
- Insert data
Readings
editMultimedia
editActivities
edit- Use SQL Server to update record information in the Student table in your College database.
- 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
edit- 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- insert
- delete
- referential integrity
- transactions
- update