Learn SQL
What's a relational database?
A database that organizes information into one or more tables.
What would you need to complete the associated UPDATE statement? UPDATE ________ SET height = 6 WHERE id = 1;
A table name.
What does DELETE FROM do?
Deletes rows from a table.
What is SQL designed to do?
SQL is a programming language designed to manipulate and manage data stored in relational databases.
What's a table?
A collection of data organized into rows and columns.
What's a statement?
A string of characters that the database recognizes as a valid command.
This is the correct format?
DELETE FROM icecream WHERE flavors is NULL;
What is a null value?
A value that represents missing or unknown data.
Which clause is used with the ALTER TABLE statement?
ADD COLUMN
What do Constraints do?
Add information about how a column can be used.
What does INSERT INTO do?
Adds a new row to a table.
What would be correct syntax for a CREATE TABLE statement?
CREATE TABLE meals ( name TEXT, rating INTEGER );
What does ALTER TABLE do?
Changes an existing table.
What does CREATE TABLE do?
Creates a new table.
What does UPDATE do?
Edits a row in a table.
What does the INSERT statement do?
Insert new rows into a table.
What are common data types in SQL?
Integer, Text, Date, Real.
What is the purpose of the * character?
It selects every column in the table.
What does SELECT do?
Queries data from a table.
What does SQL stand for?
Structured Query Language.
What is a relational database?
a database that organizes information into one or more tables.