Friday, December 12, 2014

SQL - Joining Select Statements

Image courtesy of Master isolated images
/ FreeDigitalPhotos.net
In this fourth session on SQL Barry Collier looks at how information is extracted from a database using joined SELECT statements.
The session covers the following points:
  • LIKE clause
  • IN operator
  • UPDATE command
  • DELETE command
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • UNION.
Students will find the content of this Adobe Connect session most helpful for unit ICAPRG425A in both our Certificate IVs and Diploma courses.
Download a zip file containing SQL and Data files to create the bankdb database here.
Click the corresponding link in the column to the right to access the recording.

No comments: