Database Fundamentals/Manipulating Data
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:
- 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[edit | edit source]
Multimedia[edit | edit source]
- Microsoft Virtual Academy: Using DML Statements
- YouTube: SQL INSERT, UPDATE, and DELETE
- YouTube: ACID Principles
Activities[edit | edit source]
- 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  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 | edit source]
- 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[edit | edit source]
- referential integrity