Study Guide

CSSLP study guide: Practise secure queries and testing

Prepare for CSSLP with all eight domains, a runnable parameterized-query example, practical review tasks and current exam and experience requirements.

Updated September 20266 min readStudy GuideCertBliss
Michael Parker

Michael Parker

CertBliss Editorial Team

Prepare for CSSLP across the whole software lifecycle, from requirements and design to testing, operations and supply chains. Use the eight-domain map and the runnable Python example to connect a secure implementation choice with its observable test results.

Which CSSLP outline should you use?

The current linked Certified Secure Software Lifecycle Professional (CSSLP) English outline is effective from 15 September 2023. Its eight domains cover security throughout the software development lifecycle (SDLC).

Review requirements, architecture, implementation, testing, deployment and supply-chain topics, as well as concepts and lifecycle management. A coding background may help with some areas without covering the entire outline.

ISC2’s current outline page also discusses AI security within the existing domains. It does not publish a ninth weighted AI domain.

Sources: CSSLP Certification Exam Outline (English), effective September 15, 2023 — ISC2 official exam outline PDF; Review the ISC2 CSSLP Certification Exam Outline — isc2.org exam outline page, including AI security context

What should you review in the eight domains?

Use all eight domains to organise your study. The published weights describe coverage, not exact item counts for an individual exam.

Use the detailed objectives to check your references and identify gaps. The tasks below are suggested practice activities.

DomainWeightA useful review task
Secure Software Concepts12%Review security properties, principles, controls and risk concepts.
Secure Software Lifecycle Management11%Connect security governance, processes, metrics, documentation and lifecycle decisions.
Secure Software Requirements13%Turn security needs into requirements and review compliance, privacy, abuse cases and traceability.
Secure Software Architecture and Design15%Review threat modeling, interfaces, secure design patterns and technology choices.
Secure Software Implementation14%Review secure coding, input handling, access controls, code analysis and build controls.
Secure Software Testing14%Review test strategies and methods, test data, vulnerability findings and verification evidence.
Secure Software Deployment, Operations and Maintenance11%Review release pipelines, configuration, secrets, monitoring, incident handling and updates.
Secure Software Supply Chain10%Review third-party components, software inventories, supplier risks and contractual requirements.

Sources: CSSLP Certification Exam Outline (English), effective September 15, 2023 — ISC2 official exam outline PDF

Practise binding SQL values and predicting results

A parameterized query passes the lookup value separately from the SQL statement. This local example lets you observe that separation for an ordinary name and a SQL-looking string.

Run this original study exercise with Python 3’s standard-library sqlite3 module. It creates only an in-memory database containing the two named rows; nothing else changes that database between statements. Output appears in loop order.

The example connects secure implementation and testing. It is a small learning exercise, not a coding task that you are required to perform during the exam.

import sqlite3

con = sqlite3.connect(":memory:")
cur = con.cursor()
cur.execute("CREATE TABLE accounts(name TEXT PRIMARY KEY)")
cur.executemany(
    "INSERT INTO accounts VALUES(?)",
    [("Mira",), ("Omar",)],
)

for sought in ("Mira", "' OR 1=1 --"):
    cur.execute(
        "SELECT name FROM accounts WHERE name = ?",
        (sought,),
    )
    print(cur.fetchall())

con.close()

Original practice

Before running the script above, predict its exact printed output for both lookup values, then explain why the second lookup returns no rows even though the string contains valid-looking SQL.

Show answer

The script prints [('Mira',)] on the first iteration and [] on the second, then closes the connection.

The first lookup binds Mira and finds its row. The second binds the complete string as a literal name; neither of the two rows has that name, so the result is empty. The question-mark placeholder keeps the supplied value separate from the SQL statement. Parameter binding handles values; it does not grant authorization, validate every business rule, safely substitute arbitrary table or column names, or secure the whole application. Python’s documentation and OWASP describe this technique and its limits.

Sources: CSSLP Certification Exam Outline (English), effective September 15, 2023 — ISC2 official exam outline PDF; sqlite3 — DB-API 2.0 interface for SQLite databases — Python documentation — How to use placeholders to bind values in SQL queries; SQL Injection Prevention - OWASP Cheat Sheet Series — Primary defenses and additional defenses sections

Are study questions enough preparation?

Use them to find gaps against the full outline, then study and apply the underlying concepts.

For each incorrect or uncertain answer, identify the objective and explain why the alternatives fail under the stated facts. Repeating a familiar question bank can hide gaps if you only remember the answer.

Connect related lifecycle work: a requirement, a design choice, an implementation and the evidence used to test it. The local query example covers one implementation and testing lesson; it does not replace the other domains.

Use current references to fill missing coverage and finish with timed mixed practice. A particular resource or practice percentage does not guarantee readiness or convert into the official passing score.

  • Check all eight domains and their detailed objectives.
  • Predict the code’s output before running it, then explain each result.
  • Practise reviewing scenarios beyond your strongest work area, including governance and supply-chain topics.

Sources: CSSLP Certification Exam Outline (English), effective September 15, 2023 — ISC2 official exam outline PDF; Review the ISC2 CSSLP Certification Exam Outline — isc2.org exam outline page, including AI security context

What do you need to earn CSSLP?

Passing the exam and completing certification are separate steps.

Certification requires four cumulative years of full-time experience in at least one of the eight current CSSLP domains. Qualifying part-time work and internships may also count.

A qualifying relevant degree can waive up to one year under the current requirements. CISSP is not a prerequisite.

If you pass without the experience, you can pursue Associate of ISC2 status and have five years to gain the required four years. This is separate from full CSSLP certification.

Submit the certification application within nine months of the exam date, after receiving official passing notification. Experience must be endorsed; an ISC2 professional in good standing can do this, or ISC2 can endorse with the required employment evidence. Complete the ethics and first annual maintenance fee requirements.

Sources: CSSLP Experience Requirements — isc2.org experience requirements page; Endorsement | Online Endorsement Application | ISC2 — isc2.org endorsement page, application timeline and audit note; What To Do After Your ISC2 Certification Exam — isc2.org after-your-exam page, results and retake policy

What should you expect on the exam?

CSSLP allows 180 minutes for 125 items at Pearson VUE testing centers. The outline lists multiple-choice and advanced item types. This is a knowledge exam, not a live coding assessment.

The published passing grade is 700 out of 1000; it is not a raw 70% or a fixed correct-answer count. ISC2 does not report numerical scores. Unsuccessful candidates receive domain proficiency information.

An unofficial result is normally provided at checkout, followed by official notification. Results can be delayed, so avoid planning around a guaranteed email turnaround.

Sources: CSSLP Certification Exam Outline (English), effective September 15, 2023 — ISC2 official exam outline PDF; What To Do After Your ISC2 Certification Exam — isc2.org after-your-exam page, results and retake policy

What should you check before booking?

Use ISC2’s current exam policies and your appointment instructions to check identification, accommodations and testing-center requirements.

Check regional pricing when you book. If a retake is needed, the waiting periods are 30 test-free days after the first attempt, 60 after the second and 90 after the third and subsequent attempts, with no more than four attempts per certification program in 12 months.

  • Make sure your registration details match the required identification.
  • Arrange any testing accommodations through ISC2 before scheduling.
  • Review arrival instructions, permitted items and break rules at your test center before your appointment.
  • After passing, keep the exam date and application deadline with your experience records.

Sources: How to Get Ready, Prepare for Your ISC2 Certification Exam — isc2.org before-your-exam page; What To Do After Your ISC2 Certification Exam — isc2.org after-your-exam page, results and retake policy

Sources

Facts checked against official ISC2 sources:

Next steps

FAQ

Frequently Asked Questions

Practical answers to help you apply the guidance for Certified Secure Software Lifecycle Professional (CSSLP).

How do you maintain CSSLP after certification?
Certified holders need 90 continuing professional education (CPE) credits over the three-year cycle, including at least 60 Group A credits; the remaining 30 may be Group A or B. Check the current policy for eligible activities and the annual maintenance fee. The policy’s annual CPE figures for certified holders are suggested pacing, not mandatory yearly minima. Associates follow separate annual requirements.

Keep Reading

Related Study Guides

Explore related guides and preparation topics.