Database-ics
Rows are known as...
What are records?
The query that selects everything from the Personnel table.
What does the following query do? SELECT * FROM Personnel;
In a SQL query, specifies the table that data is selected from.
What is the FROM clause?
The way to check if something is the opposite of NULL.
What is NOT NULL?
WHERE something IS NOT NULL;
Columns are known as...
What are fields?
The very last part to be written/typed for each SQL query.
What is a thing-a-muh-jiggy/a-whose-ee-whats-it or BETTER YET, a semi-colon? ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
Used to select unique inidividual records in specified columns.
What is a DISTINCT clause?
SQL stands for...
What is Structured Query Language?
The pieces of information that come after the word SELECT and before the word FROM are known as...
What are fields?
This is the word that would be used between two conditions if we are only looking for one of the conitions to be True.
What is an OR clause?
The query to select all information from the Customers table if Country is Spain and CustomerName is Adam.
What is
SELECT * FROM Customers
WHERE Country = "Spain" AND CustomerName = "Adam";
The word(s) that comes after FROM in a SQL query is...
When a data point is blank or empty, it is considered...
What is NULL?
Specifies how data is sorted in a results set.
What is the ORDER BY clause?
The query for the following info: select the names from the customers table if the name starts with "K" and ends with "a".
SELECT names FROM customers
WHERE names LIKE "K%a";
The words that get used in a WHERE statement are known as...
What are fields/values?
This is the character (wildcard character to be exact) that is used to substitute any other character(s) in a string. Typically it is used after the following format:
WHERE something LIKE
What is the percentage symbol?
Ex:
SELECT sql_people FROM miller
WHERE name LIKE "%a%" OR name LIKE "%e%" OR name LIKE "%i%" OR name LIKE "%o%" OR name LIKE "%u%";
This clause allows you to check/test for a specific range in your query.
What is a BETWEEN clause?
This practice is generally allowed in most databases, enabling users to use lower and upper case characters to write queries.
Hint: think back to how Python worked with upper and lower case; it's the opposite style of this.
What is case insensitivity?