Friday, December 5, 2014

Structured Query Language (SQL) - Select From Where?

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net
In this third session on SQL Barry Collier looks at how information is extracted from a database using SELECT statements.
The session covers the following points:
  • simple SELECT FROM statement
  • conditional SELECT WHERE statements
  • conditional SELECT Expression statements
  • comparison operators
  • SQL Group Functions
  • SQL GROUP BY clause
  • SQL HAVING Clause
  • logical operators.
Students will find the content of this Adobe Connect session most helpful for unit ICAPRG425A in both our Certificate IVs and Diploma courses.
Click the corresponding link in the column to the right to access the recording.

No comments: