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
0
Search
status
key-point 1
key-point 2
I can use key-points to
confidence level
quizlet done
reminders
learned
1
learned key point
drag learned items here
flashcardlearnedtested
1
Count
revising
1
key point being revised
drag revising items here
flashcard
1
Count
to do
9
tables
link tables, column, row
create related tables to implement design including all data dictionary requirements
SQL
select
use SELECT to write SQL code for a query
from
use FROM to write SQL code for a query
where
condition, logical operators AND, OR
use WHERE to write SQL code for a query, including (>, <, =, AND, OR)
order by
use ORDER BY to write SQL code for a query
join
equi-join
use an equi-join (WHERE) to write SQL code for joining tables
insert row
use INSERT to write SQL code for adding a row of data
update
use UPDATE to write SQL code for changing data values
delete row
use DELETE to write SQL code for removing a row data
9
Count
11
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.