L20: SQL

Use the raw slides (pdf) before lecture to take notes. The material here will help you with crafting a sql injection attack in Project 6.

Summary

  • Basic SQL commands like CREATE, INSERT, UPDATE, SELECT
  • How to filter results using WHERE
  • How to join results using UNION
  • The basic idea behind sql injection
  • Examples