Introduction to SQL
SQL, SELECT , FROM, WHERE,HAVING,GROUP BY, ORDER BY
JOINS: LEFT OUTER JOIN, RIGHT OUTER JOIN,EQUI JOIN
History and Evolution of Database
What is RDBMS
Desining Relational Database , Codds Rules , Normalization
Defining A Database
Creating Tables to store data
Establish relationship between tables
Defining a column, imposing constraints on a column
DB2 Program preparation: DCLGEN DBRM, BIND PLAN , PACKAGE and COLLECTION
SQL EDITORS: SPUFI/QMF
COBOL PROGRAM USING DB2 TABLES ONLY
COBOL PROGRAM USING DB2 TABLES AND NON-VSAM FILES
COBOL PROGRAM USING DB2 TABLES AND VSAM FILES
COBOL PROGRAM USING DB2 TABLES, NON-VSAM AND VSAM FILES
COBOL DB2 PROGRAM USING CURSORS
COBOL DB2 PROGRAM USING CURSORS FOR UPDATE OF COLUMNS
COBOL PROGRAMS TO INSERT ROWS INTO DB2 TABLES
COBOL PROGRAM TO DELETE ROWS FROM DB2 TABLES
COBOL DB2 PROGRAM USING CURSOR TO RETRIEVE DATA FROM MORE THAN ONE TABLE
COBOL PROGRAM TO MATCH DATA FROM ANOTHER TABLE USING SINGLETON QUERY