Db2 - Db2 Fundamentals v12
Duration
5 hours
Overview
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.
Audience
Personnel requiring an introduction to Db2 and SQL
Prerequisites
Basic knowledge of Data Processing concepts.
Objectives
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
Course Content
Overview of Db2
What is Db2 and how is it used?
Db2 Users
Understanding the Db2 Environment
Db2 Components
Db2 Tools
Db2 Internals
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
Overview of SQL
Methods used to Execute SQL
SQL Syntax
Accessing Db2 Data Using the SELECT Statement
SQL Functions and Expressions
Filtering and Sorting Data
Creating Tables
Inserting Data into Tables
Deleting Table Data
Updating Existing Table Data
SQL and SPUFI
What is SPUFI?
Accessing SPUFI
Entering Input and Output Requirements into SPUFI
Defining SPUFI Processing Options and Defaults
Interpreting SPUFI Output
Batch SPUFI