CSE Roadmap

Core tier · about 3 hours · 5 parts

Part 1 of 5 · 1 min read

Why this page comes first

In this module you will

  • Write an INSERT with multiple rows in one statement.
  • Write an UPDATE that computes a new value from the row's own existing values.
  • Write a DELETE that removes rows based on a join condition against another table.
  • Wrap a multi-statement change in a transaction, and undo it with ROLLBACK before committing.

This is the last module of Level 1. It closes out the core SQL statements with the patterns actually used in practice, not just the single-row versions shown in Level 0.