Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

31 cards

()

Section 1

Preview this deck

WHERE

Front

1 / 31

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 1, 2020

Cards (31)

Section 1

(31 cards)

WHERE

Front

selects rows conditionally

Back

Can you return null as a value?

Front

yes

Back

calculated columns

Front

results of queries where math was used

Back

database schema

Front

collection of tables related to keys

Back

FROM [table]

Front

get it from the table [table]

Back

how to rename a field

Front

SELECT [field] as [new name] FROM [table]

Back

how to order results

Front

end with: ORDER BY [field 1/column number] DESC/ASC

Back

always start a query with

Front

SELECT

Back

LTRIM syntax

Front

LTRIM(string) removes leading blanks

Back

*

Front

all of the fields

Back

UPPER syntax

Front

UPPER([field]) gives strings all in upper case

Back

SUBSTR syntax

Front

SUBSTR([field], starting_int, num_characters)

Back

purpose of relational databases

Front

avoids data duplication saves space saves errors

Back

can a cell be null

Front

yes

Back

Can you refer to renamed fields in WHERE clauses?

Front

yes

Back

if then else blocks in sql

Front

CASE WHEN [boolean] THEN [statement] ELSE [statement] END AS [name]

Back

relational databases consist of

Front

tables

Back

records

Front

unlimited number of rows each row contains data for each prescribed colum

Back

What happens if the number of characters in SUBSTR is negative?

Front

returns the string [number of characters] before the starting int

Back

key

Front

field or ordered set or fields whose data uniquely identify a record

Back

AND lets you

Front

filter on multiple conditions

Back

use for keys

Front

to make relationships

Back

LENGTH syntax

Front

LENGTH([field]) returns the number of characters in the given record

Back

What happens if the starting int in SUBSTR is negative?

Front

counts from the end of the string where to start

Back

string type length

Front

either set to be varying or fixed

Back

field

Front

fixed number of columns each column has a data type and length

Back

Can you order by calculated columns?

Front

yes

Back

view

Front

when a query's result is stored

Back

examples of unstructured binary data

Front

audio, images

Back

query

Front

statement describing a data request

Back

do records have an order?

Front

no

Back