LAB 222 – Defending Python Applications Against SQL Injection

Course Overview

This lab simulates an Injection vulnerability found in the Gold Standard Cyber Range. The challenge includes a Web App developed in Python that fails to implement the security principle of “Establish Secure Defaults”.

Using Visual Studio Code, participants will analyze code to identify and mitigate instances of “Failure to validate input and improper use of user input in SQL statements”. The objective of this lab is to find the vulnerable code and fix the weakness.

Upon completion of this lab participants will:

• Apply strategic principles to keep Python applications safe
• Demonstrate the skills needed to discover and exploit SQL Injection attacks
• Fix a vulnerable SQL query in Python