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