- Home
- Catalog
- Courses
- Database Curriculum
- Manage Data Definitions with DB2
Manage Data Definitions with DB2
Duration
2 to 3 hours
Overview
Audience
Programmers and DBAs requiring training in defining and building DB2 databases
Prerequisites
Basic knowledge of DB2, relational databases, and system design
Objectives
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
Course Content
DDL – Defining Database Objects
DB2 Objects
DDL Statements
Authorities
Creating a Basic Database
DDL – Defining a Table
Table Structure
DB2 Data Types
Create a Table
Create an Index
Drop a Table
Alter a Table
Referential Integrity
Code Referential Integrity
Code Check Constraints
Using SPUFI and Command Center to Access DB2
Using SPUFI on the Mainframe to Run SQL Statements
Using Control Center to Run SQL Statements
Viewing Database Objects - The Catalog
Some of the Tables That Make Up the System Catalog
Using SQL to Display System Catalog Tables
Using Control Center to Display the Catalog Graphically
Manage Data Definitions with DB2 UDB Mastery Test
Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at 770-872-4278
