http://www.expert.com.hk/australia/online-courses/index.htm

Home	Dreamweaver	VB.NET	XML	C#	VBScript	ASP	eMarketing
Contact	ColdFusion	ASP.NET	JSP	JScript	Fireworks	SQL	Advanced Java
How it works	ActionScript	Intro Java	Perl	Flash	HTML	PHP	Adv JavaScript

10-week Online SQL Course

Understanding SQL statements is essential for writing efficient web-based data manipulation programs. You will learn:

What is SQL?
Building Database and tables
SQL Queries
SQL data type syntax
Basics
Select statement
The LIKE statement and wildcard patterns
Use the WHERE clause to specify a criteria for the selection
Use AND and OR to join two or more conditions in a WHERE clause.
Use BETWEEN....AND to find data in a range.
use the DISTINCT keyword to return only different values in a column.
Use ORDER BY to return rows in ascending or descending order.
Using the INSERT statement to insert new rows into a table
Using the UPDATE statement to update or change rows in a table.
Using the built-in COUNT function
Using other SQL built-in functions
Use the GROUP BY function
Using the HAVING statement
Use aliases for column names and table names
Delete records using SQL
SQL join, inner join, left join and right join statements
Use the ALTER TABLE, CREATE TABLE & DROP TABLE statements
Create Tables with Table constraints using SQL
Getting information from more than one table
Compound Conditions
Logical Operators
Aggregate Operators
Fields manipulation
Using Unions
The IN Operator
Finding duplicate records

Cost: $295 (Australian dollars) including course notes and lots of examples and exercises. You will have your own instructor whom you can ask as many questions as possible by email. You have the option of completing the course between 4 to 10 weeks.

Next online course starting date:

Our next online course starting date is Monday 12 November 2012

Enquires or Enrolment:

Email: melbourne@expert.com.hk
or
Phone: (03) 9700 6260