KT-CE121 DB2 SQL Workshop Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


DB2 SQL Workshop


Description: 

This course replaces course SQL Workshop (CE120)

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.

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

Skills taught:

  • 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

 
Click here to view the Course Outline
     
Prerequisite: 

You should have:

  • Basic computer literacy
  • Basic editing skills
  • Database skills are not required
 
   
     
Duration: 
2 Days  
     
     

View Printer Friendly Page

 

Course Schedule
  Start Date  City  Price  
 8/28/2017
 $1400

To Inquire About Future Classes

Request a class date

if one is not scheduled.