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

10-week online SQL Course

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

What is SQL?
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
SQL Join, inner join, left join and right join statements
Use the ALTER TABLE, CREATE TABLE & DROP TABLE statements
Getting information from more than one table
Compound Conditions
Logical Operators
Aggregate Operators
Fields manipulation

Cost: $US155 (US 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 (Ecourse) starting date:

Monday 27 July 2009

Enquiries or Enrolment:

Email: courses@expert.com.hk
or
Phone: +613 9700 6260