Thursday, March 21, 2019

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.