CS09-04 Computer Science Watch
Brute force, denial of service and SQL injection
In this lesson
Brute force, dos and SQL injection for GCSE Computer Science, with worked examples and the mistakes examiners report. OCR J277 GCSE. Cyber security 4 of 8. Full Cyber security playlist: https://www.youtube.com/playlist?list=PLJVDXoq6lOTg More at https://scholafly.com
By the end: For each of brute-force attacks, denial of service attacks, data interception and theft, and SQL injection, describe how the attack is used and what its purpose is, in OCR's two-part form.
What it covers
- 0:00 Intro: brute force, dos and SQL injection
- 0:39 Brute force
- 1:44 Denial of service
- 3:18 Interception and theft
- 4:16 SQL injection
- 5:18 Describe the threat
- 7:22 Spot the attack
Key words
About this video
Brute Force, DoS and SQL Injection | GCSE Computer Science | CS09-04
Brute force, dos and SQL injection for GCSE Computer Science, with worked examples and the mistakes examiners report.
OCR J277 GCSE. Cyber security 4 of 8.
Full Cyber security playlist: https://www.youtube.com/playlist?list=PLJVDXoq6lOTg
More at https://scholafly.com
Watch first: CS09-01 - https://youtu.be/gw7Pe3XzvxE
Video code: CS09-04 (search "ScholaFly CS09-04")
#GCSEComputerScience #CyberSecurity
For teachers
This GCSE Computer Science lesson teaches brute force, denial of service and SQL injection. By the end, students should be able to for each of brute-force attacks, denial of service attacks, data interception and theft, and SQL injection, describe how the attack is used and what its purpose is, in OCR's two-part form. It works through four worked examples and the mistakes examiners report.
Exam board specification references:
OCR J277
- 1.4.1
Read the transcript
Someone types a line of odd text into a website's login box, with no password, and gets in. How can typing do that? It sounds like a clever hacking program, but nothing was installed. The trick is in what the website does with the typing. It is one of four attacks here, each told apart by how it is used and what it is for. The answer to that typing trick waits in act four.
Only one course names these four attacks. The video Protecting systems, networks and data matches a defence to each, though, so they are worth knowing by name on any course. A brute-force attack tries every possible password, or a long list of common ones, until one works. Software does the guessing automatically, thousands of tries a second, not a person at a keyboard. Its purpose is to gain access to an account or a system. Now, which falls fastest: a long random password, a pet's name, or an eight-word phrase? The pet's name. Names and everyday words sit on the guessing lists, so it is found almost at once.
A denial of service attack floods a server with so many requests that it cannot answer real users. A server is the computer that provides a service, such as a website. A distributed denial of service attack sends those requests from many computers at once, often ones taken over by malware, harmful software hidden on them. That makes it far harder to block, because there is no single source. What does the attacker get from a denial of service attack: passwords, data, or an outage? Only the outage. Nothing is taken, and the purpose is to stop the service working. Written out in two parts: an attacker floods a server with requests, often from many computers at once, so it cannot respond. The purpose is to stop that service for its real users. One examiner's report notes: "DDOS was often described appropriately, although some responses described it as being an attack on an individual's device instead of a server." The fix is one word: name the server, every time, as the thing being flooded.
The fourth attack is the one the title leaves out: data interception and theft. It means capturing data as it travels across a network, then reading or stealing it. Data crosses a network in packets, small pieces sent one by one. Packet-sniffing software can copy every packet that passes a point on the network, and the sender and receiver may never notice. Its purpose is to steal information, such as passwords or bank details, while it is on the move. Encryption, scrambling data so only someone with the key can read it, does not stop this. Encrypted data can still be intercepted, but it is meaningless without the key. Encryption across a network explains how that works.
Behind many login boxes sits a database, and SQL injection goes for it. SQL is the language many websites use to ask their database for data. SQL injection is typing database code into an input box, so the website runs it as part of its own instruction. The website builds that instruction from whatever is typed, and the attacker types something that is itself an instruction. What could the attacker achieve once the database runs what they typed? Read records they should never see, change or delete them, or log in without any password. Nothing is installed. It is typed into an ordinary box, and the weakness is the website trusting whatever it is given.
Here is a student's answer to a question about brute force: you can stop it by locking the account after three wrong tries. Why does 'lock the account after three wrong tries' not describe a brute-force attack? It describes a defence. The rewrite: software tries password after password automatically, until one works, to get into the account. A line from that same report says: "Some responses described how to prevent the threat instead of describing the threat itself." The habit that fixes it: two parts, how it is used and what it is for, and neither part is a defence. Defences belong in a different column. Now the four attacks go into one table, with two columns: how it is used, and what it is for. Fill in both columns of the table, for all four attacks. Brute force: automated password guessing, to gain access. Denial of service: flooding a server with requests, to stop the service. Interception: copying packets as they travel, to steal information. SQL injection: typing database code into an input box, to read, change or delete data. There is a third column, headed defence, and it stays empty for now. The video Protecting systems, networks and data fills it in.
Two parts each, how it is used and what it is for, on four cases. An online shop is down for a day, though nothing was taken. Which attack is most likely? Denial of service, most likely distributed. The purpose was the outage itself. A different place, a hotel: someone copies everything crossing its network. Which attack, and what for? Data interception and theft. The purpose is to steal information, such as passwords, while it is on the move. Try this: odd text typed in a search box reveals every customer's address. Which attack? SQL injection. The site ran the typed text as part of its own database instruction. Now the login box from the start: what was the website mistaking for an instruction? What the attacker typed. The site built its instruction from the input, so typed code became part of it.
Marks run down the chapter as far as this video. Name all four attacks and their purposes, then press thumbs up and move past this one. If it has not stuck, put it on a list to return to. The video on protecting systems brings all four back, each with its defence.
Next in the chapter: Pharming, weak passwords and removable media. Hopefully that's next in your feed, but if not, search for ScholaFly C S oh nine, oh five.
Every other video is on scholafly.com too, easy to search by video code or by keyword. Whatever you're revising, go there and have a look, or, watch the next video.
Related terms
For: OCR GCSE J277
On the specification
| Board | Spec | Statement |
|---|---|---|
| OCR GCSE J277 | 1.4.1 | Threats to computer systems and networks |
For teachers
This GCSE Computer Science lesson teaches brute force, denial of service and SQL injection. By the end, students should be able to for each of brute-force attacks, denial of service attacks, data interception and theft, and SQL injection, describe how the attack is used and what its purpose is, in OCR's two-part form. It works through four worked examples and the mistakes examiners report.