This course provides an introduction to the SQL language.
This course is appropriate for individuals working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for individuals working in an Informix environment.
Course Length: 2 day(s)
Course Price: $1670 CAD
Available Course Formats:
- Instructor Led Online
- Simple SQL Queries
- Retrieving Data from Multiple Tables
- Scalar Functions and Arithmetic
- Column Functions and Grouping
- UNION and UNION ALL
- Using Subqueries
- Maintaining data
This basic course is for everyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language (DML).
You should have:
- Basic computer literacy
- Basic editing skills
Database skills are not required.
Instructor Led In Classroom
Newcomp can directly deliver IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.
Currently, in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.
Instructor Led Online
Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples
ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.