Db2 - Manage Data Definitions with Db2 v12
Duration
6 hours
Overview
The Manage Data Definitions with Db2 course describes how SQL is used to define a Db2 database and its associated objects. It looks at SQL statement syntax and the methods used to invoke SQL statements.
Audience
Programmers and DBAs requiring training in defining and building Db2 databases
Prerequisites
Completion of the 'Introduction to RDBMSs and Db2' course, or equivalent knowledge.
Objectives
After completing this course, the student will be able to:
- Use SQL code to create databases, table spaces and tables
- Identify Db2 table and index attributes
- Identify database definitions
Course Content
Defining Database Objects
Db2 Objects
SQL 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
Primary, Unique and Foreign Keys
Referential Integrity
Check Constraints
Using SPUFI and Db2 Data Studio to Access Db2
Running SQL Statements on the Mainframe Using SPUFI
IBM Data Studio and Db2
Viewing Database Objects - The Catalog
Tables and Views Associated with the Db2 Catalog
Using SQL to Display Db2 Catalog Tables
Using IBM Data Studio to Display Db2 Catalog Information