Introduction to Structured Query Language (SQL) - Chapter 2 Part 1

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/58

flashcard set

Earn XP

Description and Tags

Vocabulary flashcards covering core SQL concepts, syntax, and foundational terms from Chapter 2 Part 1.

59 Terms

1
New cards

SQL (Structured Query Language)

A data sublanguage used to communicate with and manipulate relational databases; developed by IBM in the 1970s; ubiquitous across DBMS; not a full programming language.

2
New cards

DDL

Data Definition Language; SQL commands used to define or modify the database schema (e.g., creating tables, relationships, and structures).

3
New cards

DML

Data Manipulation Language; SQL statements used for querying, inserting, updating, and deleting data (e.g., SELECT, INSERT, UPDATE, DELETE).

4
New cards

DQL

Data Query Language; a subset of SQL focused on querying data; SELECT is the primary DQL command.

5
New cards

TCL

Transaction Control Language; commands that manage transactions and their boundaries (BEGIN/COMMIT/ROLLBACK).

6
New cards

DCL

Data Control Language; commands that grant or revoke database permissions (GRANT, REVOKE).

7
New cards

SELECT FROM WHERE framework

The fundamental structure of an SQL query: SELECT {columns}, FROM {tables}, WHERE {conditions}.

8
New cards

DISTINCT

Keyword to remove duplicate rows from a query’s results.

9
New cards

TOP

Clause to limit the number of rows returned by a query (e.g., TOP 5).

10
New cards

TOP PERCENT

Variant of TOP that returns a percentage of rows from the result set.

11
New cards

ORDER BY

Clause to sort query results by one or more columns in ascending or descending order.

12
New cards

GROUP BY

Clause to group rows for aggregation, enabling calculations like SUM, COUNT per group.

13
New cards

HAVING

Clause to filter groups after aggregation, similar to WHERE for groups.

14
New cards

BETWEEN

Operator to filter values within a specified range (inclusive).

15
New cards

LIKE

Pattern-matching operator using wildcards _ (single char) and % (any sequence).

16
New cards

IN

Operator to specify a set of possible values for a column.

17
New cards

IS NULL

Operator to test whether a column contains NULL values.

18
New cards

AND/OR/NOT

Logical operators to combine or negate conditions in WHERE clauses.

19
New cards

SUM/AVG/MIN/MAX/COUNT

Aggregate functions used to perform calculations on column data (e.g., SUM, COUNT, AVG, MIN, MAX).

20
New cards

SUBQUERY

A query nested inside another query; can derive values for the outer query.

21
New cards

JOIN

Operation to combine data from two or more tables based on a related column (ON specifies the join condition).

22
New cards

OUTER JOIN

JOIN variant that includes rows with no matching rows in one table (LEFT/RIGHT/FULL OUTER JOIN).

23
New cards

UNION/INTERSECT/EXCEPT

Set operators to combine or compare result sets from queries.

24
New cards

ANSI SQL-92

SQL standard endorsed by ANSI in 1992 (SQL-92); modern versions add features like XML/JSON support.

25
New cards

Data warehouse

Central repository for integrated data from multiple sources used to support BI analysis and decision making.

26
New cards

Data extraction

Process of extracting data from operational databases into an offline store for BI use.

27
New cards

Semicolon

Statement terminator in SQL; ends each SQL statement in many DBMS.

28
New cards

SQL (Structured Query Language)

A data sublanguage used to communicate with and manipulate relational databases; developed by IBM in the 1970s; ubiquitous across DBMS; not a full programming language.

29
New cards

DDL

Data Definition Language; SQL commands used to define or modify the database schema (e.g., creating tables, relationships, and structures).

30
New cards

DML

Data Manipulation Language; SQL statements used for querying, inserting, updating, and deleting data (e.g., SELECT, INSERT, UPDATE, DELETE).

31
New cards

DQL

Data Query Language; a subset of SQL focused on querying data; SELECT is the primary DQL command.

32
New cards

TCL

Transaction Control Language; commands that manage transactions and their boundaries (BEGIN/COMMIT/ROLLBACK).

33
New cards

DCL

Data Control Language; commands that grant or revoke database permissions (GRANT, REVOKE).

34
New cards

SELECT FROM WHERE framework

The fundamental structure of an SQL query: SELECT {columns}, FROM {tables}, WHERE {conditions}.

35
New cards

DISTINCT

Keyword to remove duplicate rows from a query’s results.

36
New cards

TOP

Clause to limit the number of rows returned by a query (e.g., TOP 5).

37
New cards

TOP PERCENT

Variant of TOP that returns a percentage of rows from the result set.

38
New cards

ORDER BY

Clause to sort query results by one or more columns in ascending or descending order.

39
New cards

GROUP BY

Clause to group rows for aggregation, enabling calculations like SUM, COUNT per group.

40
New cards

HAVING

Clause to filter groups after aggregation, similar to WHERE for groups.

41
New cards

BETWEEN

Operator to filter values within a specified range (inclusive).

42
New cards

LIKE

Pattern-matching operator using wildcards _ (single char) and % (any sequence).

43
New cards

IN

Operator to specify a set of possible values for a column.

44
New cards

IS NULL

Operator to test whether a column contains NULL values.

45
New cards

AND/OR/NOT

Logical operators to combine or negate conditions in WHERE clauses.

46
New cards

SUM/AVG/MIN/MAX/COUNT

Aggregate functions used to perform calculations on column data (e.g., SUM, COUNT, AVG, MIN, MAX).

47
New cards

SUBQUERY

A query nested inside another query; can derive values for the outer query.

48
New cards

JOIN

Operation to combine data from two or more tables based on a related column (ON specifies the join condition).

49
New cards

OUTER JOIN

JOIN variant that includes rows with no matching rows in one table (LEFT/RIGHT/FULL OUTER JOIN).

50
New cards

UNION/INTERSECT/EXCEPT

Set operators to combine or compare result sets from queries.

51
New cards

ANSI SQL-92

SQL standard endorsed by ANSI in 1992 (SQL-92); modern versions add features like XML/JSON support.

52
New cards

Data warehouse

Central repository for integrated data from multiple sources used to support BI analysis and decision making.

53
New cards

Data extraction

Process of extracting data from operational databases into an offline store for BI use.

54
New cards

Semicolon

Statement terminator in SQL; ends each SQL statement in many DBMS.

55
New cards

PRIMARY KEY

A column or set of columns that uniquely identifies each row in a table.

56
New cards

FOREIGN KEY

A column or set of columns that refers to the primary key in another table, establishing a link between them.

57
New cards

ALIAS (AS)

Temporary name given to a table or a column in an SQL query to make it more readable or to simplify complex queries.

58
New cards

CONSTRAINT

Rules enforced on data columns in a table to limit the type of data that can go into a table (e.g., PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL).

59
New cards

UNION ALL

Set operator that combines the result sets of two or more SELECT statements, retaining duplicate rows.