Kursbeskrivning: Accessing the DB2 UDB for System i Database Using SQL

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.

Visa den här kursen i andra länder

Roadmaps:

• End User

Tillbaka till toppen

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.

Tillbaka till toppen

Before attending this class, the student should be able to:

• Use a Windows-based PC
• Navigate and use a Windows-based desktop
• Navigate System i menus
• Use System i commands
• List the data types that are supported by the i5/OS database
• Explain the use of the data types supported by the i5/OS database

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.

Tillbaka till toppen

After attending this class, the student should be able to:

• Use Data Definition Language (DDL) to describe tables and views
• Use UPDATE, INSERT, ALTER and DELETE to modify SQL tables and maintain a database
• Use the SELECT statement to extract data from tables and views
• Code SQL queries that include column and scalar functions
• Code SQL queries that include inner and outer joins
• Use SQL Query Manager
• Describe several features of QMF for Windows

Tillbaka till toppen

Course units:

• SQL Concepts
• Extracting Data Using SELECT
• Functions
• JOIN and UNION
• SubSELECTs
• Query Tools
• Database Maintenance

Tillbaka till toppen

Course language might be English, pls check if important.

Tillbaka till toppen