I would add:

° How to apply updates to single rows, all rows or multiple chosen rows (UPDATE statement).

° How to delete single rows, all rows or multiple chosen rows (DELETE statement).

° How to return data in a specific ordering; both rows and columns (ORDER BY clause and SELECT statement).

I totally agree that once you know how and when to apply a technique it can be appropriate to need to check the "how" dependent on ones role.