Days 18-19: SQL & Databases

Ideas:

• SQLite Browser
• Web IDEs for SQL: one, two
• Reading data from a database
  • SELECT … FROM … WHERE
  • JOIN (INNER, LEFT, RIGHT, OUTER)
• Transactions & Writes
  • BEGIN, COMMIT, ROLLBACK
  • INSERT
  • UPDATE
  • DELETE
• DDL
  • CREATE/DELETE DATABASE
  • CREATE TABLE
  • ALTER TABLE
  • DROP TABLE

Outcomes of this studying

You should:

• be able to speak to the purpose/meaning of the SQL concepts above (these are very common job interview questions)