- 6 hours
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.
Programmers and DBAs responsible for defining and maintaining DB2 databases.
Completion of the 'Introduction to RDBMSs and DB2' course, or equivalent knowledge.
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
Creating a Basic Database
DB2 Data Types
Creating a Table
Creating an Index
Dropping a Table
Altering a Table
Primary, Unique and Foreign Keys
Running SQL Statements on the Mainframe Using SPUFI
IBM Data Studio and DB2
Tables and Views Associated with the DB2 Catalog
Using SQL to Display DB2 Catalog Tables
Using IBM Data Studio to Display DB2 Catalog Information