Learning objectives

• Explain SQL Injection the way a junior AppSec engineer would
• Map the idea to login, checkout, or API flows you already use
• Know a safe lab way to observe the issue (Juice Shop / CYNARKS Labs)
• Pass the knowledge check without attacking real sites

1. In one sentence

SQLi = untrusted input becomes part of a database query so the DB does extra attacker-controlled work.

2. Why it matters (daily life)

Login bypass, dumped tables, sometimes OS impact in old stacks — still appears on legacy portals and CTFs.

3. How it works

Root fix: parameterized queries / ORM binds. Also least-privilege DB users, WAF as layer, never trust client.

4. Real-world / authorized lab example

Lab: ' OR 1=1-- style lesson on intentionally vulnerable login → then rewrite with parameters.

5. Fix mindset (builders)

Prefer input validation, parameterized queries / safe APIs, least-privilege sessions, security headers, and regression tests. “Patch later” is how IDOR and XSS become incidents.

6. Common mistakes

String-concat SQL; relying on WAF only; testing prod DBs.

7. Practical habit (authorized labs only)

1. Reproduce on an intentional vulnerable app in Labs.
2. Capture request/response notes (redact secrets).
3. Write the fix in one paragraph a developer can ship.
4. Retest after the fix — same steps, expect fail-closed.

8. Memory tip

Explain this using Gmail login, Instagram, PhonePe checkout, or a college portal — as a story, without attacking real sites.

Practice intercepts only on authorized lab apps (e.g. Juice Shop in Labs).

Knowledge Check

Q1. Best primary defense?

A. Test only on authorized lab apps and report clear remediations
B. Probe live banking / college sites without written permission
C. Ignore HTTPS and mishandle sessions on purpose in production
D. Disable logging so findings cannot be traced

Q2. Why least-privilege DB user?

A. Test only on authorized lab apps and report clear remediations
B. Probe live banking / college sites without written permission
C. Ignore HTTPS and mishandle sessions on purpose in production
D. Disable logging so findings cannot be traced

Q3. Is encoding enough alone?

A. Test only on authorized lab apps and report clear remediations
B. Probe live banking / college sites without written permission
C. Ignore HTTPS and mishandle sessions on purpose in production
D. Disable logging so findings cannot be traced

Answer Key

1. A
2. A
3. A

Lesson Summary

SQL Injection is a building block of modern web risk. Learn it deeply; practice only where you are allowed.

Coming next

Continue the Web Application Security syllabus. Keep your proxy pointed at lab targets only.

CYNARKS Academy – Learn to Understand. Practice to Defend.
Never test live PhonePe, Instagram, Razorpay merchant panels, or college portals without written permission.