Ir al contenido

📅 TRAINING PLAN: FROM NOVICE TO SQL INJECTION EXPERT

Estimated Duration: 8 Weeks Methodology: "Learn by doing" Main Lab: bWAPP v2.2 (Configured in local VM) Secondary Lab...

0views

Estimated Duration: 8 Weeks Methodology: “Learning by doing” Primary Lab: bWAPP v2.2 (Configured on local VM) Secondary Lab: PortSwigger Web Security Academy (Free online)

🗓️ WEEKS 1-2: SOLID FOUNDATIONS (In-Band Phase)

Sección titulada «🗓️ SEMANAS 1-2: FUNDAMENTOS SÓLIDOS (Fase In-Band)»

Objective: We will understand SQL syntax and overcome the fear of the single quote.

  • Reading: Modules 1.1 (GET) and 1.2 (POST/Error).
  • Practice (bWAPP - Low Level):
    • We will break SQL Injection (GET/Search) manually.
    • We will use ORDER BY until we find the number of columns.
    • We will extract the version and the user.
    • Challenge: We will extract the ENTIRE users table using GROUP_CONCAT (as we will see in the manual).
  • Practice (bWAPP - Medium Level):
    • We will try the same. We will see that mysql_real_escape_string blocks us.
    • Research: Why does our payload fail? (We will understand sanitization).

🗓️ WEEKS 3-4: THE “VIETNAM” (Blind Phase)

Sección titulada «🗓️ SEMANAS 3-4: EL “VIETNAM” (Fase Blind)»

Objective: We will learn to work without seeing. Patience and Scripting.

  • Reading: Modules 3.1 (Boolean) and 3.2 (Time-Based).
  • Practice (bWAPP):
    • We will face SQL Injection - Blind - Boolean-Based.
    • We won't use SQLMap yet. We will guess the first letter of the database name manually.
  • Coding (Python):
    • We will write our own Python script to automate the Boolean-Based attack.
    • Goal: To have the script automatically extract the DB name. (This will teach us more programming and HTTP than any course).

Objective: Speed and industry tools.

  • Reading: Modules 5.2 (Polyglots) and 6.2 (CMS).
  • Practice (SQLMap):
    • We will revisit the previous bWAPP exercises and destroy them with SQLMap.
    • We will learn how to use the flags -technique, -level, -risk, and -tamper.
    • We will use -os-shell in bWAPP and understand what it does under the hood (uploads a PHP file).
  • Practice (Drupal):
    • We will perform the Drupal exercise in bWAPP. We will search for the exploit on the internet, launch it, and gain admin access.

🗓️ WEEK 6: PERSISTENCE & OOB (Advanced Phase)

Sección titulada «🗓️ SEMANA 6: PERSISTENCIA & OOB (Fase Avanzada)»

Objective: Attacks that persist and bypass firewalls.

  • Reading: Modules 4.1 (OOB) and 5.1 (Stored).
  • Practice (bWAPP):
    • In SQL Injection - Stored (Blog), we will inject an XSS that steals our own cookie.
    • We will configure Burp Collaborator (or Interactsh) and attempt an OOB injection (even if it is difficult in local bWAPP, we will practice the syntax).

Objective: Full server compromise.

  • Reading: Modules 3.3 (Stacked), 7.1 (Web Shells), and 7.2 (MSSQL).
  • Advanced Practice:
    • In bWAPP, we will use INTO OUTFILE to create our own shell.php backdoor.
    • We will connect to it with Netcat (Reverse Shell).
    • Extra: If possible, we will install a VM with “Metasploitable 3” (Windows) to practice MSSQL attacks (xp_cmdshell) which are vital in the real working world.

Once we master this, we will be ready for serious certifications:

  1. eWPT (eLearnSecurity Web Penetration Tester): Highly focused on web and reporting.
  2. OSCP (Offensive Security Certified Professional): The gold standard. Our manual SQLi knowledge will save our lives here.
  3. PortSwigger Labs: When we finish bWAPP, we will go to PortSwigger. They have free SQLi labs that are excellent and modern.

Final Advice from the Red Team Lead: We will not obsess over memorizing payloads. We will understand the LOGIC.

  • Why do we put a quote here?
  • Why do we need a comment at the end?
  • Why does the server sleep for 5 seconds?

If we understand the “why”, we can create our own payloads when the ones in the manual don't work.

Happy hunting!