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.