KT-CE120 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
 
 


SQL Workshop


Description: 

This course is the classroom delivered version of Instructor Led Online Course 3E120.

This course provides an introduction to the SQL language and applies to the entire DB2 Family, and Informix. 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.

Skills taught

Upon completion of this course, you should be able to:

  • 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 state

 
Click here to view the Course Outline
     
Prerequisite: 

Audience 

This is a basic course anyone 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
 
   
     
Duration: 
2 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.