implement with SQL · csHrevisionBook

Gallery

csHrevisionBook

Revision planning

Explore

Database development

use the table below track your revision progress to key ideas in database implementation (SQL)

drag rows up as you progress

update your confidence level

update quizlet setting, you can add more then one activity option as you complete them

add personal reminder notes

revise key ideas in implementation

revise key ideas in implementation

status

key-point 1

key-point 2

I can use key-points to

confidence level

quizlet done

reminders

learned

learned key point

drag learned items here

flashcard

learned

tested

Count

revising

key point being revised

drag revising items here

flashcard

Count

to do

SQL queries

Describe, give examples and use SQL operations for pre-populated relational databases, with three or more linked tables.

select

Use SQL select

from

Use SQL from

where

Use SQL where

order by

Use SQL order by

group by

Use SQL group by

aggregate function

min, max, count, sum, average

Use SQL aggregate functions (MIN, MAX, COUNT, SUM, AVG)

insert

Use SQL insert

delete

Use SQL delete

update

Use SQL update

wildcards

multiple characters %, single character _, LIKE

Use wildcards and LIKE

computed value

Use computed values (row calculations)

alias

Use alias (table, column)

Count

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.