- INSERT - insert data into a table
- UPDATE - updates existing data
- DELETE - deletes data, can determine what columns/types/or if all data but leave table/or if whole table
- SELECT - retrieve data from the a database (more on this later in part IV with joining tables)
Note when you put these into the SQL.. and you hit execute, it will execute everything ABOVE your cursor. If you only highlight a section and hit execute, only that part will be executed. So if you do half of it, execute, then add more, you will want to only highlight the new portion. It will be in yellow for SQL Server but definitely depends on what you are using (could be different years, Oracle, etc.). If you execute the entire file again, you will have duplicates of the beginning half.