Intro to Excel
Define what data looks like and how it can be used.
What is a datatype?
In Vscode: ctrl n is new file, ctrl s is save, for macs command n is new file and command s for save
What is create a new file and save file?
[Name with space]
What is the syntax to identify a field-name that includes a space?
A collection of data stored in a format that can easily be accessed.
What is a database?
This uniquely identifies a row in a table.
What is a primary key?
'Invented' the relational database.
Who is E.F. Codd?
True and False are representatives of what data type?
What is a Boolean?
Data is stored in tables that are linked together based on how they relate
What is a Relational Database?
Selects everything from the Personnel table.
What does the following query do? SELECT * FROM Personnel;
Key shows the equation of a calculated cell.
What is F2?
NOT AND OR
What is the order of operations for compound WHERE statements?
Occurs when multiple records in one table are related to multiple records in another table
What is a many-to-many relationship?
Data that is stored in tables that are not linked(don't understand SQL)
What is NoSQL?
Allows you to specify pattern matches for data retrieval values.
What does IN allow you to do in SQL?
In Vscode: Ctrl+Shift+`
What is create a new terminal?
Use the syntax /* */ or --
What is How do you add comments to SQL?
Select * from Customers
Where CustomerName Like (‘%ana%’, ‘%anp%’) ;
What is a FIRST NAME INCLUDES the sequence of letters "ana" and LAST NAME INCLUDES sequence of letters "anp"?
A data type in standard SQL used to store large amounts of data. It is basically a binary string of variable length, stored as a sequence of bytes or octets.
What is BLOB?
WHERE Weight is between 2000 and 3000 OR Where Weight is > 1999 and < 3001 OR WHERE Weight is >= to 2000 and <=3000
What WHERE clause will select weight values between 2000 and 3000?
Adds $ signs to a cell's coordinates which turns the cell into an ABSOLUTE
What is F4?