 I am Mrs. Sunita Dole, working as an assistant professor in the Computer Science and Engineering Department of the Vyalshan Institute of Technology, Sulapur. Topic covered here is Structured Query Language, Data Manipulation Language. Data Manipulation is Insertion of new information into database, Modification of information stored in the database, Deletion of information from the database and the Retrieval of information stored in the database. In this video, I am going to cover the Data Manipulation Language commands Update and Delete learning outcome. At the end of this session, students will be able to update and delete the data for given application using Update and Delete command. In previous video, I have covered the first DML command Insert, while in this video, I am going to cover the Data Manipulation Language command Update and Delete. Statement in SQL is used to update the data of an existing table in the database. We can update single column as well as multiple columns using Update statement as per our requirement. So here, I am going to cover the basic syntax of Update command, then updating the single column, updating multiple column and omitting where clause. The basic syntax of the Update command is Update table name set column 1 equals to value 1 comma column 2 equals to value 2 and so on where condition, where the set statement is used to set new values to the particular column and where clause is used to select the rows for which the columns are needed to be updated. If we have not used where clause, then the column in all rows will be updated. So the where clause is used to choose the particular rows. Now consider updating single column using Update command. For example, update the column name and set the value to Pratik Kumar in all the rows where city is Pune. SQL command is Update student set name equals to Pratik Kumar where city equals to Pune. This query will update first row of the table student and set the name Pratik Kumar for the city Pune as shown in table. Updating multiple columns using Update command. Example update the column name to Pratik Kumar and state to MP where row number is 1. Update student set name equals to Pratik Kumar comma state equals to MP where row number equals to 1. The above query will update two columns that is name and state in the first row and the table student will now look like as shown in the table student. Updating where clause. If we omit where clause from the update query then all of the rows will get updated. Example update student set name equals to Pratik Kumar. This query update the name to Pratik Kumar in all rows in the student table. Till now we consider updating the data in the table using data manipulation language Update command. Now pause this video and reflect on these questions for a minute or two minutes and write your response. Once you return the answer to these questions then you can restart playing this video. The question is which of the following options is or are correct about Update command. Questions are A. Update single column B. Update multiple column C. Both A and B. D. None of above. I hope all of you have completed this activity. So the question was which of the following option is or are correct about the Update command. As we can update single column as well as multiple column using Update statement as per our requirement. So the answer of this question is option C that is both A and B. The delete statement in SQL is used to delete existing record from a table. We can delete single record or multiple records depending on the condition we specify in the where clause. So in delete command I am going to cover the basic syntax, deleting single record, deleting multiple record and deleting all records. Basic syntax delete from table name where some condition. We can delete single as well as multiple records depending on the condition we provide in the where clause. If we omit the where clause then all of the records will be deleted and the table will be empty. Deleting single record using the delete command example. Delete the rows from the student table where city equals to Pune. SQL command is delete from student where city equals to Pune. The query will delete only the first row as shown in the student table after delete operation. Deleting multiple records using delete command. Example delete the rows from the table student where city is Sangly. SQL command is delete from student where city equals to Sangly. The query will delete two rows from the student table that are third row and the fourth row. Deleting all records example delete all the records of the table student. SQL command delete star from the student. All of the records in the table will be deleted. There are no records left to display. The table student will become empty. These are some references used to prepare this presentation. Thank you.