Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Introduction to Structured Query Language (SQL)

memorize.ai (lvl 286)

(0)

48 cards

()

Section 1

Preview this deck

like

Front

1 / 48

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 14, 2020

Cards (48)

Section 1

(48 cards)

like

Front

checks whether attribute value matches given string pattern

Back

and

Front

requires all conditional expressions to be true

Back

recursive query

Front

table joined to itself using alias

Back

in

Front

checks whether attribute value matches any value within value list

Back

avg

Front

returns average of all values for given column

Back

check

Front

validates data in an attribute

Back

having

Front

restricts selection of grouped rows based on a condition

Back

is null

Front

checks whether attribute value is null

Back

where

Front

restricts selection of rows based on conditional expression

Back

primary key

Front

defines primary key for a table

Back

order by

Front

orders selected rows based on one or more attributes

Back

not null

Front

ensures that column will not have null values

Back

alter table

Front

modifies a table's definition (adds, modifies, or deletes attributes or constraints)

Back

max

Front

returns maximum value found in given column

Back

create table as

Front

creates a new table based on query in user's database schema

Back

database schema

Front

logical group of database objects related to each other (ex: tables, indexes)

Back

unique

Front

ensures that column will not have duplicate values

Back

authentication

Front

process DBMS uses to verify that only registered users access database required for creation tables

Back

sum

Front

returns sum of values for given column

Back

create schema authorization

Front

creates a database schema

Back

drop index

Front

permanently deletes index

Back

subquery

Front

query embedded/nested inside another query

Back

delete

Front

deletes one or more rows from a table

Back

group by

Front

groups selected rows based on one or more attributes

Back

create index

Front

creates an index for a table

Back

rollback

Front

restores data to original values

Back

cascading order sequence

Front

multilevel ordered sequence

Back

comparison operators

Front

=, <, >, <=, >=, <>, != (used in conditional expressions)

Back

distinct

Front

limits values to unique values

Back

drop table

Front

permanently deletes a table (and its data)

Back

commit

Front

permanently saves data changes

Back

create view

Front

creates dynamic subset of rows and columns from one or more tables

Back

alias

Front

alternate name given to column or table in any SQL statement to improve readablility

Back

foreign key

Front

defines foreign key for a table

Back

logical operators

Front

AND/OR/NOT (used in conditional expressions)

Back

update

Front

modifies an attribute's values in one or more table's rows

Back

between

Front

checks whether attribute value is within a range

Back

exists

Front

checks whether subquery returns any rows

Back

min

Front

returns minimum value found in given column

Back

default

Front

defines default value for a column (when no value is given)

Back

not

Front

used to negate result of conditional expression

Back

count

Front

returns number of rows with non-null values for given column

Back

insert

Front

inserts row(s) into table

Back

or

Front

requires only one of conditional expressions to be true

Back

drop view

Front

permanently deletes a view

Back

create table

Front

creates a new table in user's database schema

Back

Rule of Precedence

Front

establish order in which computations are completed Order: Operations within parentheses Power operations Multiplications and divisions Additions and subtractions

Back

select

Front

selects attributes from rows in one or more tables or views

Back