Fiszki: SQL | Quizlet

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/31

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

32 Terms

1
New cards

ASC keyword

Used to sort data in ascending order.

2
New cards

Data type

Specifies the type of data that a column can hold (e.g., text and numbers).

3
New cards

DESC keyword

Used to sort data in descending order

4
New cards

ORDER BY clause

Retrieves the name of one or more columns from the SELECT statement, and sorts (ascending or descending) the output.

5
New cards

Client

A single-user computer that interfaces with the multiple-user server.

6
New cards

Client/server database system

A system that divides processing between client computers and a database server.

7
New cards

Database

A collection of electronically stored organized files.

8
New cards

Server

A multiple-user computer that provides shared database connection, interfacing, and processing services.

9
New cards

Field

Column that runs vertically within a table.

10
New cards

Foreign key

Link records of one type with those of another type.

11
New cards

Keys

Uniquely identify a row or record in a table.

12
New cards

Normalization

A three-step technique used to organize data attributes in a more efficient, reliable, flexible, and maintainable structure.

13
New cards

Pprimary key

A field whose value uniquely identifies every row in a table.

14
New cards

Row

A record that represents a collection of information relating to an item in a table.

15
New cards

Table

Structured file containing rows and columns.

16
New cards

SQL Defined

SQL is a nonprocedural language that is used to manipulate and retrieve data from relational DBMSs such as Microsoft Access, DB2, Sybase, and Microsoft SQL Server. It is considered nonprocedural because of the way operations are carried out. Unlike procedural computer languages like Basic and C, which are concerned with how to perform operations, SQL describes what needs to be processed. The focus is on what to retrieve, delete, or insert.

17
New cards

Query

A question or command you pose concerning data from the database.

18
New cards

Parts of a query include the following:
Clause

A segment of an SQL statement combined to form a complete SQL statement.

19
New cards

Parts of a query include the following:
Keywords

Reserved words that allow you to communicate with a database.

20
New cards

Parts of a query include the following:
Statement

Keywords and data supplied within an SQL query.

21
New cards

Keywords:
FROM keyword

Used to tell the database which table to retrieve the columns from.

22
New cards

Keywords:
SELECT keyword

Used to tell the database which column(s) to display.

23
New cards

Syntax Rules

Syntax refers to the rules that govern how a programming language must be written.

24
New cards

Comparison Operators

knowt flashcard image
25
New cards

Comparison Operators

The comparison operators are used to compare expressions. An expression is any data type that returns a value

26
New cards

Arithmetic Operators

Plus (+)
Minus (-)
Divide (/)
Modulus (%)
Multiply (*)

27
New cards

Sorting Data Using the WHERE Clause

The ability to sort data further enhances the data-retrieval process. Sorting data involves filtering and arranging retrieved data in a customized fashion. In SQL, this is achieved by using the following clauses:
GROUP BY
HAVING
ORDER BY
STARTING WITH
WHERE

28
New cards

Asterisk wildcard character (*)

When used with the LIKE operator, you can match any number of occurrences of any character.

29
New cards

Brackets wildcard character ( [] )

When used with the LIKE operator, you can specify a set of characters that match a character in a specific position.

30
New cards

LIKE operator

A character operator. When used in conjunction with asterisks or brackets, matches parts of a value within a table.

31
New cards

IN operator

A miscellaneous operator that provides a shorter method for specifying a range of conditions.

32
New cards

NOT operator

A logical operator used to match any condition opposite of the one defined.