Last week I spent a lot of time with my students on the basics of INSERT/UPDATE/DELETE statements. Since they had already been exposed to the basic form of the statements, I was real excited to show them how to use all of these SELECT staements I had them doing earlier in the term with these statements. Sub-queries still have several of them confused, but they seemed to have grasped the concept of getting the SELECT working frist before marrying it to an INSERT / UPDATE / DELETE statement. Shortly, we will start getting these statements inside of transactions. That will really start to get them thinking! This week is fall break!
Here's to the future!