What does SQL stand for?

What are the uses of a SQL?

The different data types whcih are often used in a SQL.

How SQL works?

For each field in the table, you need to speicfy a data type. Some common SQL data types are shown behind.

CREATE TABLE students (studentID INTEGER PRIMARY KEY, forename TEXT, surname TEXT, date_of_birth DATE, year_group INTEGER)

Once you've created an empty table you'll need to add records to it. You use INSERT INFO command. If you are inserting a complete record you don't need to speicfy the field but if it is incomplete you do.

To update a reocrd you can use UPDATE-SET-WHERE.