Home > Computer > Databases and SQL > Interskill Learning > Database Curriculum > 2.2 Manage Data Definitions with DB2 UDB
Provided by: Interskill Learning

2.2 Manage Data Definitions with DB2 UDB

DB2

 Interskill Learning
This is course 2 of 5 in the DB2 - Database Management System Series. The course is delivered via e-Learning. It can be accessed online, at any time, place or location with internet access, or delivered through your own internal LMS (if applicable). The course is available as part of the DB2 - Database Management System Series, or in a Mainframe Bundle, comprising of the 100 most popular mainframe e-Learning titles.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Course Level:introductory
Duration:3 hours
Training Presented in:English
Training Provided by Interskill Learning
Click here for more information or to take this course
2.2 Manage Data Definitions with DB2 UDB
Duration

2 to 3 hours

Overview Audience

Programmers and DBAs requiring training in defining and building DB2 databases.

Prerequisites

Basic knowledge of DB2 UDB, 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 UDB 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 UDB Control Center to Display the Catalog Graphically

Manage Data Definitions with DB2 UDB Mastery Test
About The Training Provider: Interskill Learning
Interskill Learning - Interskill Learning is a worldwide leader in the provision of e-learning, delivering reliable, quality learning solutions since 1991 to over 1500 organisations. With 1000s of titles to chose from in mainframe, desktop, IT and business subject areas, Interskill offers a comprehensive training solution for your entire workforce, regardless of their department, location or language. With three...
Click here for more information or to take this course
Home > Computer > Databases and SQL > Interskill Learning > Database Curriculum > 2.2 Manage Data Definitions with DB2 UDB
Advertise With Us
Do you offer db2 training?
Custom Search
tcw11-v473M-08/26/11-19:01:30-()[B]-[A]-[B] -06:26:26