Section 15: Databases and SQL · Notes

Section notes

• SQL is a language for creating tables, inserting data and retrieving it.
• sqlite3 is built into Python and keeps a whole database in one file.
• The core statements are SELECT, INSERT, UPDATE and DELETE.
• Keys and relations between tables avoid duplicated data.

Your progress is saved in this browser. Accounts are coming so it follows you across devices.