In this class, students will learn how to use more complex SQL queries to retrieve information across tables, and interact with data including write operations.
Objective: Students should be able to build CRUD functionality using SQL statements, including INSERT INTO, UPDATE, etc.
Before arriving to class on Sunday, please watch all of the videos in this video playlist on Lynda.
- Inserting, Updating, and Deleting
- Understanding Write Conflicts
- Planning Your Database
- The Data Definition Language
- Understanding Stored Procedures and Injection Attacks
Also, please read the following page that explains the ACID database model.
- INSERT INTO
- UPDATE
- DELETE
- Writing SQL in your application
- Raw SQL strings
- Parameter validation
- Escaping
- Prepared statements
- Stored procedures
- Security
- SQL Injection
- User GRANTS
- Enumeration
- OWASP on SQL Injection
- Parameter Validation on Wikipedia
- Node MySQL Escaping Query Values
- Node MySQL Preparing Queries (automatic escaping)
- MySQL SHOW GRANTS
- Falsehoods Programmers Believe About Names
- Rewatch the previously recorded session: part 1
- Rewatch the previously recorded session: part 2
- Rewatch the previously recorded session: part 3