Training

Popular Courses

IBM

MICROSOFT

Enterprise Architecture (EA)

SOA

Java/Java EE

Cloud Computing

Agile

Mobile computing

SCHEDULED CLASSES

COURSE
MAP

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

VIRTUAL CLASSROOMS

ROOM RENTALS

Contact Training Sales

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

439 University Av
Suite 820
Toronto, ON
M5G 1Y8

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

 

Home > Training > DB2 >

WA1297 SQL Workshop for DB2 Training and Courseware

This comprehensive 2 day workshop provides the hands on experience to effectively apply Structured Query Language (SQL) to many business problems.
Objectives:
  After completing this course the student should be able to:
  • understand the concepts of a relational database system.
  • understand the concepts of entity and referential Integrity.
  • write comprehensive SQL queries to access data on DB2 .
  • code SQL queries to insert, update or delete rows on DB2.
  • code basic SQL to create views, tables or indexes.
Target Audience:
  Programmers, Analysts, Project leaders, managers and end users, who need to access data on a DB2 type, relational database.
Prerequisites
  Previous experience with a computer system.
Duration
  Two days.

Course Outline

Day 1: Basic Theory

  • SQL Introduction
  • SPUFI or command center (CLP)
  • Lab 1
  • SQL Basics
  • Lab 2
  • SQL Basics (continued)
  • Lab 3

Day 2: SQL Table Joins

  • Lab 4
  • SQL Subselect
  • Lab 5
  • DML and Objects
  • Lab 6
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
More Details
Outline Course Outline
Buy This Course

Buy on-site and customized class

*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.