Db2 Concepts and SQL for Mainframe & LUW

Catalog Home Databases, Business Intelligence & Data Science Db2 for LUW
Your Training Location:  

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.

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

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

< >

Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account


Social Media