SQL Query Language
Course Code:DPZ112
Course Type:Short-course
Qualification: There is no associated qualification; however delegates receive a Central Sussex College Attendance certificate on completion.
Duration: Half Day (5 hours)
Date/Venue/Cost:
08 February 2012, Horsham Training Centre, £95.00
04 May 2012, Horsham Training Centre, £95.00
04 July 2012, Horsham Training Centre, £95.00
Suitable For: Delegates wishing to understand the syntax of SQL.
Entry By: Direct Entry
Entry Requirements:
Some previous database experience would be an advantage.
Course Content:
This course provides an introduction to the SQL syntax. Topics covered include:
- Select Statement
- Conditional Selection
- Equal to / Greater than / Less than
- Compound Conditions
- And
- Or
- Between
- Like
- Not Like
- Inner Join
- Outer Join
- Eliminating Duplicates
- Aggregate Functions
- Max / Min / Count / AVG / SUM
- Creating New Tables
- Deleting Data
- Updating Data
