One of the most common approaches to coding stored procedures is using the SQL PL language. A key advantage is the ability to work entirely within the IBM Data Studio environment and accomplish DB2 SQL PL development, deployment, and testing. This course covers an overall review of stored procedures, the SQL PL language, and the process of developing, deploying, and testing SQL PL stored procedures using the IBM Data Studio tool. Hands on coding of many stored procedures are part of the class.
Analysts and programmers involved in the development of DB2 LUW SQL PL Stored Procedures.
Upon successful completion of this course, the student will be able to
Understanding of relational database concepts and SQL syntax (DB2 SQL For Everyone or equivalent).