Каталог курсов

Курсы IBM

DB2 SQL Workshop

 
Код курса  Код: CE121UA    Заявка  Предварительная запись    Продолжительность  Кол-во часов: 16 , Кол-во дней: 2


IBM.gif

Description

This course is available in these other formats: Self Paced Virtual | Web Based
This course provides an introduction to the SQL language.
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.

Objectives


  • 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

Audience


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

PreRequisites


You should have:

  • Basic computer literacy
  • Basic editing skills
Database skills are not required.

Topics


  1. Introduction
  2. Simple SQL Queries
  3. Retrieving Data from Multiple Tables
  4. Scalar Functions and Arithmetic
  5. Column Functions and Grouping
  6. UNION and UNION ALL
  7. Using Subqueries
  8. Maintaining data

Related


You may also be interested in the following courses
This course provides you with information about the functions of IBM's DB2, a relational database
manager which may be installed ...

DB2 Family Fundamentals (WBT) 1E031UA
This course teaches you how to make use of advanced SQL techniques to access DB2 databases in
different environments. This ...


Дополнительную информацию по учебным программам IBM в Украине вы можете получить на сайте: www.ibm.com/training/ua (Учебный центр в Украине).


Ссылка курса обучения
Назад в раздел





Для предварительной записи на курсы или
уточнения информации позвоните по телефонам:
(044) 492-29-29, 594-98-98
e-mail: training@muk.com.ua

Или заполните заявку online.

Свежие новости

23.11.2020 Новый виток развития: Учебный центр МУК - Amazon Web Services Training Partner
Учебный центр МУК - Amazon Web Services Training Partner!

06.11.2020 Достичь совершенства: Oracle открывает ССоЕ на базе Учебного центра МУК
Группа компаний МУК и компания Oracle подписали контракт о запуске нового и стратегически важного проекта Oracle Cloud Center of Excellence (ССоЕ) на базе Учебного центра МУК

12.10.2020 Oracle Cloud Center of Excellence Launch in Ukraine

24.09.2020 MUK Cloud: Microsoft Modern Workplace & Teamwork: обзор и настройка сервиса | 29 сентября 2020