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.
Before taking this course, students should have general knowledge of data processing concepts and some programming experience helpful.