This week we learnt about the following SQL functionalities:
The update command allows you to add a column, alter a column, rename a column, drop a column and rename a table.
Allows you to update the contents of a table
Use this statement to insert or update data in database tables.
This allows you to delete data from a single table.
Delete using cascade
Using this method of delete must be done proactively while setting up foreign keys, the database itself then automatically deletes the appropriate entries.
Delete with join
This method of deleting entries is basically a manual version of the ‘delete using cascade’.
We also learnt about using C# with SQL, however this is something I need to look into more before I understand it better.