DB2 SQL Essentials

Wise

Course

In Gatwick

Price on request

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    3 Days

Upon completion of this lab-oriented course, the delegate should be competent to code SQL SELECT, INSERT, UPDATE and DELETE statements to manipulate relational data stored in one-or-more tables.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

At least 6 months experience in an MVS
environment.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

Subjects

  • DB2

Course programme

Audience:Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners.Prerequisites:At least 6 months experience in an MVS environment.Summary:This course focuses on the scope and limits of SQL operations such as:
  • Overview of Data Definition Language (DDL): Create/Alter/Drop DB2 objects
  • Data Manipulation Language (DML)
  • Predicates
  • NULL considerations
  • INNER JOINs
  • OUTER JOINs
  • UNIONs
  • CASE expressions
  • GROUP BY & HAVING
  • CAST operations
  • Subqueries (correlated & non-correlated)
  • Subselects
  • Column/scalar functions
Objectives:Upon completion of this lab-oriented course, the delegate should be competent to code SQL SELECT, INSERT, UPDATE and DELETE statements to manipulate relational data stored in one-or-more tables.

See related categories

DB2 SQL Essentials

Price on request

The best Other Database courses

See all

See all