EncartaLabs

Embedded SQL

( Duration: 2 Days )

COURSE AGENDA

1

SQL Overview

2

Compare SQL/DDL with DDS

3

DB2 for i & System i Navigator

4

Embedded SQL Overview

5

Interactive SQL

6

Coding Embedded SQL

7

Using Host Variables

8

Retrieving Multiple Rows

9

Compiling Embedded SQL in RPG

10

SQL Error Handling

11

SQL Performance

12

Use the QAQQINI file

13

Use Visual Explain

14

Use Commitment Control for database integrity

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