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:
Post a Comment