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 11 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.
- become familiar with fundamental DB2 objects.
- learn more about DB2's security mechanism.
Who should attend?
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.
Dates and Fees
1 Day
- $ 397 (CAD) Up to 3 - $ 737 Up to 6 - $ 1,104 Plus - $ 187 Sorry, no classes are currently scheduled, please contact us to request a class
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