Kursen har inget datum.
|Listpris||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 System i high-level languages as an alternate means to access the database.
This course is designed to teach System i programmers and highly skilled System i users how to access the DB2 UDB database using the SQL. Students will learn how to create, maintain, and query the database using the interactive SQL interface and iSeries Navigator.
This course is designed primarily for experienced System i programmers. However, very skilled System i users who want to learn how to use the SQL programming language as a means to access the DB2 UDB for iSeries database may also consider attending this class.
This course is not recommended for users who need to perform simple queries. Query/400 is an end user oriented tool designed for this purpose. You can learn about Query/400 by attending such courses as AS01/S6188 - Query 400 Workshop.
Before attending this class, the student should be able to:
These skills can be gained by attending OL49/S6149 System i Application Programming Facilities Workshop.
For those students who need to learn about the iSeries DB2 database features and functions, attendance at OL45/S6145, DB2 UDB for System i Fundamentals, prior to this class, is recommended. System i users who want to attend this class may not have a broad programming background. However, some prior experience in programming would facilitate their learning experience.