In the previous segment, you learnt how to create a table and add the necessary columns with the required data types. However, to start analysing data, you need the data in the first place. This is where Data Manipulation Language statements come into the picture. In the first video of this segment, you will learn how to insert values in a table using the insert into and values keywords in a query.
So, now that you have inserted values into the table, you may feel the need to update or delete them (in case of incorrect entries). You can do this using the update – set – where and the delete – from – where commands. So, let us go ahead and learn about these in the next video.
2479616
Now, do you remember what you learnt about primary and foreign keys? A value that is a primary key in a table cannot be deleted if another table has that same value as a foreign key. Let’s watch this in action in the next video.
In this way, you have learnt about the DML statements. In the next segment, you will have hands-on of modifying the coloumns.