SQL injection: how it works and how parameterized queries stop it
9 steps · about 5 h 2 min · Beginner
- Hacking Websites with SQL Injection - Computerphile (video, Computerphile (YouTube), 10 min)
A plain-language first look at how a PHP site ends up injectable.
- Running an SQL Injection Attack - Computerphile (video, Computerphile (YouTube), 15 min)
Shows a real attack step by step, so you can see how bad a vulnerable site can get.
- SQL Injection (article, W3Schools, 10 min)
Short examples of how always-true conditions and batched statements change a query.
- SQL Injection (article, OWASP, 15 min)
The standard definition with worked examples of how concatenation breaks a query.
- Parameterized Queries - The Only Real Fix for SQL Injection and What Developers Get Wrong About Them (article, DEV Community, 12 min)
Explains why parameters work and covers common mistakes, such as mixing them with concatenation.
- Query Parameter Injection (tutorial, CodeSignal Learn, 25 min)
Practise breaking a Python query, then fix it with placeholders.
- Query Parameterization - OWASP Cheat Sheet Series (reference, OWASP, 15 min)
Copy-ready parameterized query patterns for Java, .NET, Ruby, PHP and more.
- SQL Injection Prevention - OWASP Cheat Sheet Series (reference, OWASP, 20 min)
Covers what parameters can't protect (identifiers, stored procedures, ORMs) and the extra defenses: allow-lists and least privilege.
- SQL injection - PortSwigger (interactive, PortSwigger Web Security Academy, 3 h)
Finish with the full learning path (UNION, blind, error-based, second-order), then the prevention lessons.