The First Step is to become familiar with the basics of the SQL language :-
SQL is very powerful because it consists of only 4 statements,
sometimes referred to as CRUD :-
1) Create - INSERT - to store new data
2) Read - SELECT - to retrieve data
3) Update - UPDATE - to change or modify data.
4) Delete - DELETE - delete or remove data
For example, you could create a table of STUDENTS data, then find all the students
from Richmond by saying :-
SELECT first_name, UPPER(last_name) FROM students WHERE address_town = 'Richmond'
ORDER BY last_name;
This would give you, for example :-
Barry WILLIAMS
A CRUD matrix is a table showing which parts of an application contain an
SQL statement, which is a CRUD operation which affects which parts of a database.
