Database management systems notes

Querying & Changing Rows

SELECT, WHERE, ORDER BY, and the three statements that change data. Every section is a drawn page beside a clear written explanation, about 20 minutes in all.

  • Chapter 8 of 34
  • About 20 minutes
  • 8 sections
Sign in to open it See plans

Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.

The first drawn page of Querying & Changing Rows: INSERT
The chapter's first page: INSERT

In this chapter

  • INSERT
  • SELECT, and why SELECT * is a habit to break
  • WHERE: filtering rows
  • ORDER BY and LIMIT
  • The order a query is actually evaluated in
  • UPDATE
  • DELETE, and its two dangerous neighbours
  • INSERT ... ON CONFLICT: the upsert

Next chapters

Read the whole chapter

Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.

Sign in to open itSee plans

DSA comes with the all labs plan and every ChaiCode batch.