- 5 hours
The Db2 Fundamentals course describes what Db2 is, how it is used and the components that comprise its structure. An overview of the SQL language, which is used to communicate with Db2, is provided along with details on how it is used with SPUFI.
Personnel requiring an introduction to Db2 and SQL.
Basic knowledge of Data Processing concepts
After completing this course, the student will be able to:
- Identify how Db2 is used and by whom
- Describe conceptually how Db2 processes work
- Code basic SQL statements
- Use SPUFI to process SQL statements
What is Db2 and how is it used?
Understanding the Db2 Environment
How Applications and Programs Access Db2 Data
Db2 and SQL
Db2 Data Structures
Db2 Catalogs and Directories
Db2 Active and Archive Logs
Db2 Buffer Pools
Db2 and the Sysplex
Methods used to Execute SQL
Accessing Db2 Data Using the SELECT Statement
SQL Functions and Expressions
Filtering and Sorting Data
Inserting Data into Tables
Deleting Table Data
Updating Existing Table Data
What is SPUFI?
Entering Input and Output Requirements into SPUFI
Defining SPUFI Processing Options and Defaults
Interpreting SPUFI Output