Training Categories DB2 SQL Workshop

DB2 SQL Workshop

DB2 SQL Workshop Course Details:

This course provides an introduction to the SQL language.

Note: This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.

 

    Apr 5 2023
    April 5 - 6, 2023 | 9:30 AM - 5:30 PM (EST)

    Date: 04/05/2023 - 04/06/2023 (Wednesday - Thursday) | 9:30 AM - 5:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 SQL Workshop

    April 5 - 6, 2023 | 9:30 AM - 5:30 PM (EST) | Virtual Classroom Live

    How Did You Hear of Global IT Training?

    Join Our Email List?

    May 10 2023
    May 10 - 11, 2023 | 9:30 AM - 5:30 PM (EST)

    Date: 05/10/2023 - 05/11/2023 (Wednesday - Thursday) | 9:30 AM - 5:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 SQL Workshop

    May 10 - 11, 2023 | 9:30 AM - 5:30 PM (EST) | Virtual Classroom Live

    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jun 14 2023
    June 14 - 15, 2023 | 9:30 AM - 5:30 PM (EST)

    Date: 06/14/2023 - 06/15/2023 (Wednesday - Thursday) | 9:30 AM - 5:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 SQL Workshop

    June 14 - 15, 2023 | 9:30 AM - 5:30 PM (EST) | Virtual Classroom Live

    How Did You Hear of Global IT Training?

    Join Our Email List?

    Aug 2 2023
    August 2 - 3, 2023 | 9:30 AM - 5:30 PM (EST)

    Date: 08/02/2023 - 08/03/2023 (Wednesday - Thursday) | 9:30 AM - 5:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 SQL Workshop

    August 2 - 3, 2023 | 9:30 AM - 5:30 PM (EST) | Virtual Classroom Live

    How Did You Hear of Global IT Training?

    Join Our Email List?

    Sep 14 2023
    September 14 - 15, 2023 | 9:30 AM - 5:30 PM (EST)

    Date: 09/14/2023 - 09/15/2023 (Thursday - Friday) | 9:30 AM - 5:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 SQL Workshop

    September 14 - 15, 2023 | 9:30 AM - 5:30 PM (EST) | Virtual Classroom Live

    How Did You Hear of Global IT Training?

    Join Our Email List?


*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • 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
  • Basic computer literacy
  • Basic editing skills

Note: Database skills are not required.

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).

Ready to Jumpstart Your IT Career?

CONTACT US NOW!