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.

Structured Query Language (SQL) Introduction

Image courtesy of Master isolated images
/ FreeDigitalPhotos.net

This is the first session in a series on SQL. In this session Barry Collier looks at analysing data in preparation for creating a database and then creating the database using SQL.

The session covers the following points: analysing data in terms of how it would be applied in a database creating a database using SQL loading data from a text file generated from a spreadsheet running SQL in a command line environment (MySQL Server 5.6)

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.

Installation and Evaluation

Image courtesy of Robert Cochrane
/ FreeDigitalPhotos.net

This is the ninth session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers installation and evaluation.

The session covers the following points: videoing the installation evaluation

Students will find the content of this Adobe Connect session most helpful for Support Assessment E.

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

User Requirements

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This is the eight session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers user requirements.

The session covers the following points: user requirements hardware selection and purchase installation plan

Students will find the content of this Adobe Connect session most helpful for Support Assessment D.

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

Resolve Software Problems

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This is the seventh session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers undertaking software maintenance procedures.

Jeremy looks at the whole process from undertaking software maintenance according to maintenance procedures maintain accurate records according to orgainsational guidlines resolve a defined range of equipment and software problems flow charts

Students will find the content of this Adobe Connect session most helpful for Support Assessment C.

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

Diagnostics & Maintenance

Image courtesy of cooldesign
/ FreeDigitalPhotos.net

This is the sixth session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers diagnosing and maintaining a personal computer

Jeremy looks at the whole process from recommendation location and maintenance guidelines diagnostic and maintenance functions updating software and developing a maintenance schedule

Students will find the content of this Adobe Connect session most helpful for Support Assessment A.

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

Dreamspark - Downloading Windows 7v2

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This session run by Jeremy Kilpatrick covers everything you wanted to know about Microsoft's Dreamspark offer but were afraid to ask.

View the session to learn how to download and install free software from Microsoft which is only available to students of the Western Sydney Institute TAFE NSW.

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

Troubleshooting & Diagnosing Windows

Image courtesy of dan
/ FreeDigitalPhotos.net

This is the fifth session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers troubleshooting Windows 7.

He also covers using diagnostic tolls for both Windows and Ubuntu as well as viruses and virus removal.

Students will find the content of this Adobe Connect session most helpful for Operating Systems Assessment D.

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

Creating User Accounts in Linux with Terminal

Image courtesy of stockimages
/ FreeDigitalPhotos.net

This is the fourth session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers creating user accounts in Linux.

Jeremy demonstrates this using Terminal which is command line utility.

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

Installing a Virtual Machine

Image courtesy of arztsamui
/ FreeDigitalPhotos.net

This is the third session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers installing a virtual machine (VM).

He actually covers two different VMs: VMPlayer and Virtual Box. Also Jeremy covers installing Linux Ubuntu and Windows 7 in a virtual machine. He wraps up the session covering users and groups in Linux and Optimising Windows.

Students will find the content of this Adobe Connect session helpful for Operating Systems Assessment C.

Click on the link to the right to view the recording of the session.

Software Audit - Belarc / Backup

Image courtesy of Stuart Miles
/ FreeDigitalPhotos.net

This is the second session in the series on Certificate III Information, Digital Media & Technology - Support. In this session Jeremy Kilpatrick covers using auditing software from Belarc as well performing backups and restores in Windows 7 & 8.

Students will find the content of this Adobe Connect session most helpful for Operating Systems Assessment F.

Click on the link to the right to view the recording of the session.

Users & Groups / Group Policy / Set file permissions

Image courtesy of renjith krishnan
/ FreeDigitalPhotos.net

This is the first session in a series of sessions on Certificate III Information, Digital Media & Technology - Support. In this session Information Technology Teacher, Jeremy Kilpatrick provides an in depth look at setting up user accounts in Windows 7 and 8.

Students will find the content of this Adobe Connect session most helpful for Operating Systems Assessment E.

Click on the link to the right to view the recording of the session.