SQL

Question 1

Structured Query Language

Answer 1

SQL, a programming language used to manipulate and query data in relational databases

Question 2

Relational database management system

Answer 2

RDBMS, a class of programs that can be use4d to create, update, and administer a relational database

Question 3

Relational database

Answer 3

a type of database in which the relationships between the data points matter, and that requires a programming language to pull desired data

Question 4

Field

Answer 4

A column in a database table

Question 5

CRUD functionality

Answer 5

Ability to Create, Read, Update, Delete

Question 6

Record

Answer 6

A row in a database table

Question 7

KPI

Answer 7

Key Performance Indicators

Question 8

Schema

Answer 8

The structure of database or table, indicating how the data is organized and connected

Question 9

Aliasing

Answer 9

Temporarily renaming a field with a name that exists only for the duration of the query and doesn’t change the underlying data

Question 10

Scripts

Answer 10

(within SQL) a series of commands to be executed in a program

Question 11

Comparison operators

Answer 11

Mathematical symbols that compare two values

Question 12

logical operators

Answer 12

Operators that test whether a given condition is mett

Question 13

Primay Key

Answer 13

A field that uniquely identifies the records in a table

Question 14

Foreign key

Answer 14

A field that refers to the primary key in another table, therby linking two tables together

Question 15

Parent table

Answer 15

The table that stores the primary key

Question 16

Child table

Answer 16

a table that uses a foreign key to reference the parent table

Question 17

one-to-one relationship

Answer 17

A relationship where a single record in one table is related to a single record in another table, and neither column has duplicate records

Question 18

One-to-many relationship

Answer 18

A relationship where a single record in one table is related to multiple records in anotherr table

Question 19

Common table expression

Answer 19

CTE, a temporary table or other result set that you can define and reference within a single query

Question 20

Subquery

Answer 20

A query nested inside of another query, often used for some calculation or conditional logic that provides data to be used in the main part of the query