Flashcards

SQL

Cameron Morton IT Year 7 English 15 cards

Cards in this deck (15)

1What does SQL stand for?SQL Stands for Structured Query Language.
2What is SQL?SQL is the programming language we use to create databases.
3How many data types are there?There are 5.
4What are the different data types?Character, Real, Integer, Boolean and String.
5SELECTWhich fields do you want to show in your search results
6FROMFrom which table
7WHEREWhat is your search criteria
8ORDER BYWhich field would you like to sort in ascending or descending order
9What form is SQL data inThey are usually in tables
10what does "=" meanequal to.
11what does "!=" meannot equal to.
12what does ">" meanGreater than.
13what does "<" meanLess than.
14what does ">=" meanGreater than or equal.
15what does "<=" meanLess than or equal to.

Description: Year 7 IT Flashcards on SQL, created by Cameron Morton on 21/04/2021.
Created by: Cameron Morton
Views: 0
Rating