SQL Flashcards

Question	Answer
What does SQL stand for?	Structured Query Language (SQL)
What are the uses of a SQL?	The uses are that it can be used to create, update, and query (search) databases. It consists of standard commands called statements.
The different data types whcih are often used in a SQL.	Image: Screen Shot 2017 11 29 At 18.04.01 (binary/octet-stream)
How SQL works?	The first thing that every database needs is a table. The SQL statement CREATE TABLE creates a database table.
For each field in the table, you need to speicfy a data type. Some common SQL data types are shown behind.	Image: Screen Shot 2017 11 29 At 17.50.56 (binary/octet-stream)
CREATE TABLE students (studentID INTEGER PRIMARY KEY, forename TEXT, surname TEXT, date_of_birth DATE, year_group INTEGER)	This code creates a table with five fields: studentID, forename, surname, date_of_birth and year_group. It gives the data type of each field and makes studentID the primary key
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.	INSERT INFO students VALUES (01, Uwais, Edris, 10 December 2001, 11)
To update a reocrd you can use UPDATE-SET-WHERE.	UPDATE students SET date_of_birth = 30 December 2001 WHERE studentID = 01

Resource summary

	Created by uwais edris over 6 years ago