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.

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.

Structured Query Language (SQL) - Modifying Tables and Loading Data

Image courtesy of artur84
/ FreeDigitalPhotos.net

This is the second session in a series on SQL. In this session Barry Collier builds on the database developed using MySQL from the first session and shows how to load its tables with data. The first part of the session is devoted to explaining and setting up the environment the that the MySQL Server operates in. The second part looks at developing the bankdb database.

The session covers the following points: configuring MySQL for automatic start up configuring the Windows environment to find MySQL basic command line commands loading data from a tab delimited text file altering a table inserting values.

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.

Implement Maintenance Procedures

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This session refers to the Certificate IV Information Technology Support course. In this session Jeremy Kilpatrick covers Migrate to new technology and Provide IT advice to clients.

The session covers the following points: Develop an SLA Comparison table Identify ISP features Wireless routers Maintenance strategies consistency of Internet connectivity software versions current continuity of IT services

Students will find the content of this Adobe Connect session most helpful for Implement maintenance procedures - Assessment 1.

Click the corresponding link in the column to the right to access the recording.

Provide IT Advice to Clients

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This is the eleventh session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick also covers Migrate to new technology and Provide IT advice to clients.

The session covers the following points: Cloud Technology setting up online storage online storage comparison online storage features and benefits Testing of current technology Writing reports on emerging technologies

Students will find the content of this Adobe Connect session most helpful for Migrate to new technology / Provide It advice to clients - Assessment B.

Click the corresponding link in the column to the right to access the recording.

Migrate to New Technology

Image courtesy of Panpote
/ FreeDigitalPhotos.net

This is the tenth session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers Migrate to new technology and Provide IT advice to clients.

The session covers the following points: Research emerging technologies Example of emerging technologies Writing reports on emerging technologies

Students will find the content of this Adobe Connect session most helpful for Migrate to new technology / Provide It advice to clients - Assessment A.

Click the corresponding link in the column to the right to access the recording.