Key points about this course
Duration: 2 Days*Dates & Prices Enquire
Send us your message.X
We have your course. Please kindly fill below your contact details to receive full course information and pricing.
This 2-day workshop looks at how to use the SQL language within IBM DB2 database systems to interact with and manipulate data. It provides universal instruction which covers the use of SQL in all DB2 environments, including z/OS, VM/VSE, iSeries, Linux, UNIX and Windows. By the end of the course, you will understand how SQL works and how to write basic queries to retrieve data and carry out arithmetic operations.
The course covers the following topics:
Simple SQL Queries
Retrieving Data from Multiple Tables
Scalar Functions and Arithmetic
Column Functions and Grouping
UNION and UNION ALL
By the end of the course, you will be able to:
Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses
Code inner joins and non-correlated subqueries
Use SQL arithmetic operations
Use scalar and column functions
Use UNION and UNION ALL
INSERT, UPDATE and DELETE rows
Code simple CREATE TABLE and CREATE VIEW statements
Who should attend?
The course is aimed at end-users, programmers, application designers, database administrators, system administrators and anybody else requiring basic knowledge of SQL.
You should have basic PC skills and editing skills before attending.
There is no exam with this course.
Select your preferred delivery method
Choose a Region
Choose a Location
Choose a Month
Best price in the industry
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Various delivery methods
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell