PHP Include files

Image courtesy of iStock by Getty Images.

View the recording
PHP Include Files 66:29 min

In this session on Using PHP Include Files OTEN teacher, Barry Collier covers aspects of Incorporating PHP Include files using a local web server.

This session covers the following points: PHP tags Running PHP in the browser Using incudes Relativity of links

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page & ICTWEB503 Create web-based programs in the Diploma of Website Development course.

Using a Local Web Server

Image courtesy of iStock by Getty Images.

View the recording
Using a local web server 48:42 min

In this session on Using a Local Web Server OTEN teacher, Barry Collier covers aspects of running a web server on your own computer.

This session covers the following points: different web servers locating the root folder enabling the server localhost security considerations

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page & ICTWEB503 Create web-based programs in the Diploma of Website Development course.

Developing Complex SQL Statements

"Confused Character Means Bewildered Puzzled Or Purplexed" by Stuart Miles Image courtesy of Freedigitalphotos.net

View the recording
Developing Complex SQL Statements 49:02 min

In this session on Developing Complex Select Statements OTEN teacher, Barry Collier continues on from the previous session.

This session covers the following points: joins inner join left join right join full join self join union nested queries

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.

Developing Select Statements

Image courtesy of study.com

View the recording
Using MySQL Workbench 2 60:03 min

In this session on Developing Select Statements OTEN teacher, Barry Collier continues on from the previous session.

This session covers the following points: Select Statement from Absolute Tables and Databases Alias Where Clause Where Clause Operators Group By Having Clause

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.

Developing a MySQL Database

Image MySQL logo
courtesy of Oracle

View the recording
Using MySQL Workbench 2 60:56 min

In this session on Developing a MySQL Database OTEN teacher, Barry Collier continues on from the MySQL session Using Workbench 2, delivered on the 20th Feb 2019.

This session covers the following points: Creating tables Foreign Keys Relationships Inserting Values Updating Tables Select Statements

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.

Pre-loading Images

Image courtesy of istockphoto

View the recording Pre-loading Images

In this session on JavaScript OTEN teacher, Barry Collier covers pre-loading images.

The session will cover some of the assessment tasks for unit ICTWEB502 Create dynamic web pages Practical Assignment B.

It builds on past sessions delivered for this unit. It is directed at Diploma of Website Development students who are working through or about to commence unit ICTWEB502.

JavaScript Functions 3

Image courtesy of istockphoto

View the recording JavaScript Functions 3

In this session on JavaScript OTEN teacher, Barry Collier covers developing a function using JavaScript to assemble image slices.

The session will cover some of the assessment tasks for unit ICTWEB502 Create dynamic web pages Practical Assignment A.

It builds on past sessions delivered for this unit. It is directed at Diploma of Website Development students who are working through or about to commence unit ICTWEB502.