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