Caricamento...
CE121G

DB2 SQL Workshop

Prezzo

€ 1,000.00
(Iva esclusa)

Scheda tecnica

Scarica

Giorni

2 gg

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

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, db administrators, and system admin.

You should have:

  • Basic computer literacy
  • Basic editing skills

Database skills are not required.

  • 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
Sede Data P
Roma 26/09/2019
Roma 24/10/2019
Milano 14/11/2019
Bologna 19/12/2019
Milano 06/02/2020
Roma 20/02/2020
Bologna 05/03/2020
Milano 16/04/2020
Milano 02/07/2020
Bologna 16/07/2020
Roma 24/09/2020