Question

Write a paragraph to discuss why understanding SQL is important for understanding data security issues (Hint: discuss SQL Injection)

Answer 1

SQL injection attack is where attacker will execute wrong SQL statements to access the secure data

These attacks will happens it web applications where programmer will form the queries by appending to strings
ex:

select * from student where ping='45'

so now we will display all data related to student 45

Injection example

if user give input like this 45 OR 1=1

than the query we will form is

select * from student where id='45' OR 1=1

so now attacker will be able to see all students data

so understand the security we need to understand how the sql works to avoud the incidents