Course Details
Course Description:
The DB2 SQL Workshop course is a 2-day course that is designed to provide students an introduction to the SQL language.
Note: This course is appropriate for learners working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for learners working in an Informix environment.
?
Topics covered in the course include:
- Coding SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses
- Coding inner joins and non-correlated subqueries
- Using SQL arithmetic operations
- Using scalar and column functions
- Using UNION and UNION ALL
- INSERT, UPDATE and DELETE rows
- Coding simple CREATE TABLE and CREATE VIEW statements
Target Student:
This introductory course is for students 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).
Prerequisites:
- Basic computer literacy
- Basic editing skills
Note: Database skills are not required.
Course Outline
- Introduction
- Simple SQL Queries
- Retrieving Data from Multiple Tables
- Scalar Functions and Arithmetic
- Column Functions and Grouping
- UNION and UNION ALL
- Using Subqueries
- Maintaining data
- Basic computer literacy
- Basic editing skills
Note: Database skills are not required.
Virtual Live Instructor
Free Training Materials
Convenient Scheduling
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
We offer private IBM group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how IBM Private Group Training from Business Computer Skills can help your team.
