EncartaLabs

DB2 SQL

( Duration: 2 Days )

The DB2 SQL training course is appropriate for those working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for those working in an Informix environment.

By attending DB2 SQL workshop, attendees will learn 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 statements

  • Basic computer literacy
  • Basic editing skills

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

COURSE AGENDA

1

Introduction

2

Simple SQL Queries

3

Retrieving Data from Multiple Tables

4

Scalar Functions and Arithmetic

5

Column Functions and Grouping

6

UNION and UNION ALL

7

Using Subqueries

8

Maintaining data

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top