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:

Our next online course starting date is Monday 19 November 2012

Enquires or Enrolment:

Email: courses@expert.com.hk
or
Phone: + 61 3 9700 6260 (9am-5pm Australian Eastern time Monday to Friday)

©2000-2012 Expert IT Consulting & Training Melburne Australia