implement with SQL · n5revisionBook

n5revisionBook

Revision planning

Web development

Database development

Software development

Computer systems

Questions

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

flashcardlearnedtested

Count

revising

key point being revised

drag revising items here

flashcard

Count

to do

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

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.