Why take this course?
After completing this course, you will be able to
- describe the major characteristics of the Relational Model.
- recognize the basic components of the DB2 product, and its major operating platforms.
- understand referential integrity.
- understand basic Structured Query Language programs.
- understand how DB2 affects the application development environment and process.
1 Day : Fee - $ 697.00 (CAD) : 
Multi-seat - $ 497.00 (CAD)
Multi-seat - $ 497.00 (CAD)- become familiar with fundamental DB2 objects, including Universal Data Base support.
- learn more about DB2's security mechanism.
Anyone who uses DB2-based applications in their day-to-day work will also benefit from this seminar.Any prerequisites?No database experience is necessary, although you should be familiar with basic data processing concepts.
What topics are covered
Relational Database Concepts
- The Relational Model
- Structure
- Keys
- Integrity
- Manipulation
- Data Models
- Mapping business data
- Entity types
- Relationships
- Attributes
DB2 Components and Features
- DB2 Objects
- Database
- Storage Group
- Tablespace
- Table
- Column
- Index
- Indexspace
- View
- Synonym
- Alias
- Object Dependency
- Column datatypes
- Primary key
- Foreign key
- Referential integrity
The z/OS DB2 Environment
- DB2 environment
- The DB2 subsytem
- DB2 attachments
- DB2 connections
- DB2 access
- Application development tools
- The DB2 catalog
- Using the catalog
- Catalog tables
- Security
Introduction to SQL
- What is SQL?
- The base language
- Executing an SQL statement
- Simple SELECT statement
- SPUFI Demo