DB2 SQL Workshop
Kursun kodu
CE121UA
Müddət
2 Gün, 16 Saat
Kursun təsviri
Məqsədlər
Tələblər
Kursun proqramı
Kursun təsviri
Course overview
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.
Məqsədlər
Course 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
Tələblər
Course 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
Kursun proqramı
Course topics
- 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
Ən yaxın kurs üçün qeydiyyat
DB2 SQL Workshop
Kursun kodu:
CE121UA
Müddət:
2 Gün, 16 Saat
