Basic SQL and APIs

Front

What does SQL stand for?

Back

Structured Query Language

Front

What is a query in a database system?

Back

A way to ask questions of the data in the system

Front

What does the 'SELECT' keyword do in SQL?

Back

It retrieves data from the database.

Front

What does the 'WHERE' keyword do in SQL?

Back

It filters the results based on a specified condition.

Front

How do you select specific fields from a table in SQL?

Back

Use the 'SELECT' keyword followed by the field names.

Front

What is the purpose of the 'FROM' keyword in SQL?

Back

It specifies the tables to select data from

Front

What is the purpose of the 'ORDER BY' keyword in SQL?

Back

It specifies the order of the results.

Front

What does API stand for?

Back

Application Programming Interface

Front

What is the purpose of an API?

Back

To enable communication and interaction between software applications.