Db2 Concepts and SQL for Mainframe & LUW

  This course can be requested in your area here.

This course provides and introduction to Db2 concepts, as well as SQL. Students will learn the basics of writing queries and advanced topics of joining multiple tables. Participants will learn how to create Db2 tables, indexes and views. Students will learn the best practices for updating data in Db2 databases, as well as security. An introduction to stored procedures includes a discussion of cursor and non-cursor processing.

3 Days/Lecture & Lab

This course is designed for application programmers and programmer/analysts who will be using SQL to create and retrieve data from Db2 databases. This course can be taught on either Db2 LUW or Mainframe platforms.

  • Db2 Concepts and Terminology
  • Basic and Advanced SQL Topics
  • Implementing Security
  • Db2 Physical Storage
  • Creation of Tables, Indexes, and Views
  • Cursor and Non-Cursor Processing
  • Stored Procedures

Before taking this course, students should have general knowledge of data processing concepts and some programming experience helpful.


Copyright © 2018 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media