DB2 UDB SQL Coding
- Recommended Duration:
- 3 Days
- Version
- Course is suitable for shops still running DB2 UDB version 7; some exercises will not apply.
- Benefits
- Students who complete this course will be able to code SQL statements to access DB2 UDB using both the Command-Line Processor (CLP) and Control Center graphical interface programs.
- Audience
- Persons who need to work with DB2 UDB Databases.
- Prerequisites
- The student should have familiarity with the environment used in the classroom (Windows, Unix, or Linux).
- Major Topics
-
- Relational Database Concepts
- DB2 UDB Concepts
- Command-Line Processor (CLP)
- Interactive Tools and Control Center
- SELECT
- UPDATE/DELETE/INSERT
- COMMIT/ROLLBACK
- Joined and Nested Queries
- SQL functions and analytics
- Creating DB2 tables and Views
- DB2 UDB Objects
- Catalog Tables/Dictionary
- Locking Mechanism
- Security and Authorization
- Exercises
- There are seven hands-on exercises.