SQL Quiz #2 5/6/19

Ace your homework & exams now with Quizwiz!

Syntax Rules

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

Clause

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

SQL Defined

SQL is a non procedural language used to manipulate and retrieve data from relational DBMSs. The focus is on what to retrieve, delete, or insert.

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

Asterisk wildcard Character(*)

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

Brackets wildcard character ([])

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

LIKE operator

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

NOT operator

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

IN operator

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

Query

a question or command you pose concerning data from the database

Statement

keywords and data supplied within an SQL query

Arithmetic Operators

plus(+) minus(-) divide(/) modulus(%) multiply(*)

Keywords

reserved words that allow you to communicate with a database

Comparison Operators

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

SELECT

used to tell the database which column(s) to display

FROM

used to tell the database which table to retrieve the columns from


Related study sets

Skills - Assessment 2 (NCLEX Questions)

View Set

Chapter 22 Chapter Review - Endocrine and Nervous System

View Set

Chapter 17- Inflation, Unemployment & Federal Reserve Policy

View Set

CH. 12 & 13: Major & Trace Minerals

View Set

Biology- Unit 2- Book & lecture notes - Genetics -ch 7, MS2, ch 8, MS3

View Set

What's Out There: Exploring a Science Text in A Black Hole Is NOT a Hole

View Set

Robert Cialdini's 6 principles of influence

View Set