Course 1, Module 2 Flashcards
(9 cards)
What is a Database?
A collection of data stored in a computer system
Databases can be used for various applications, such as storing user information, transaction records, and more.
Define Formula in the context of spreadsheets.
A set of instructions used to perform a calculation using the data in a spreadsheet
Formulas can include mathematical operations like addition, subtraction, multiplication, and division.
What is a Function in a spreadsheet?
A preset command that automatically performs a specified process or task using the data in a spreadsheet
Examples of functions include SUM, AVERAGE, and COUNT.
What does a Query refer to?
A request for data or information from a database
Queries can be used to extract specific information based on certain criteria.
What is Query language?
A computer programming language used to communicate with a database
Query languages allow users to create, read, update, and delete data in databases.
Who are Stakeholders?
People who invest time and resources into a project and are interested in its outcome
Stakeholders can include project managers, team members, clients, and investors.
Define Structured Query Language.
A computer programming language used to communicate with a database
SQL is widely used for managing and manipulating relational databases.
What is a Spreadsheet?
A digital worksheet
Spreadsheets are used for organizing, analyzing, and storing data in tabular form.
What does SQL stand for?
Structured Query Language
SQL is an essential skill for data analysts and database administrators.
