- 5 hours
The Manage Data Definitions with DB2 course explains how the SQL Data Definition Language (DDL) is used to define DB2 databases and database objects. The course also provides details describing how SQL statements are run and the methods used to view database objects.
Programmers and DBAs requiring training in defining and building DB2 databases.
Basic knowledge of DB2, relational databases, and system design.
After completing this course, the student will be able to:
- Define DB2 databases and objects by using SQL Data Definition Language (DDL)
- Identify database definitions
Creating a Basic Database
DB2 Data Types
Create a Table
Create an Index
Drop a Table
Alter a Table
Code Referential Integrity
Code Check Constraints
Using SPUFI on the Mainframe to Run SQL Statements
Using DB2 Data Studio to Run SQL Statements
Some of the Tables That Make Up the System Catalog
Using SQL to Display System Catalog Tables
Using DB2 Data Studio to Display the Catalog Graphically