Dette kurset har ingen planlagt dato.
|Listepris||Set by Partner|
SQL is a very powerful programming and database language that is widely used in business today. For example, SQL can be used to perform interactive database queries as well as to extract data from a server and pass that data to a Java applet running on a client PC. SQL is frequently used in i system high-level languages as an alternate means to access the database.
This course is designed to teach i programmers and highly skilled i system users how to access the database using SQL. Students will learn how to create, maintain, and query the database using the interactive SQL interface and System i Navigator.
This course provides lectures and hands on labs in a face-to-face classroom setting. This course is also offered in a live virtual classroom environment (ILO - Instructor Led Online) with hands-on labs: IBM i DB2 and SQL School - ILO (OV470NO).
This intermediate course is designed primarily for experienced IBM i programmers. However, very skilled i system users who want to learn how to use the SQL programming language as a means to access the DB2 for i database may also consider attending this class. Students will learn how to create, maintain, and query the database using the interactive SQL interface and System i Navigator.
This course is not recommended for users who need to perform simple queries. Query for IBM i is an end user oriented tool designed for this purpose. You can learn about Query for IBM i by attending such courses as OS020 - Query/400 Workshop.
This course is not recommended for users who need to perform WebQuery queries. WebQuery for IBM i is an end user, programmer and administrator oriented tool designed for this purpose. You can learn about WebQuery for IBM i by attending such courses as OV550 - DB2 WebQuery for Advanced Users, Developers and Administrators.