Db2 13 – Introduction to Db2
Duration
4 hours
Overview
The Introducing Db2 course discusses the platforms on which Db2 can be implemented, and the core features that can be found with all Db2 versions. You will look at common Db2 components and see how they are used to store and manage Db2 data. An overview of IBM Data Studio is also presented, explaining how it is used to work with relational database management systems such as Db2.
Audience
Any individual requiring an overview of Db2 and its general functions.
Prerequisites
Basic knowledge of database and data processing concepts.
Objectives
After completing this course, the student should be able to:
- Describe the platforms that Db2 can run on, and the product differences
- Identify the basic objects used by Db2 to store data
- Describe the core features of IBM Data Studio
Course Content
What is Db2
Db2 Supported Operating Systems
Db2 Licensing
Associated Db2 Products
Using SQL
Client APIs and Drivers
Stored Procedures
Distributed Access
Admin Console
Db2 Assets and Resources
Db2 Instances
Db2 Databases
Schemas
Tables and Table Spaces
Partitions
Table Components
Data Types
Defining Constraints
Global Variables
Special Registers
Db2 Catalog
Introduction to IBM Data Studio
What is IBM Data Studio?
Data Studio Features
Working with Views
Perspectives
Workspaces
Data Source Explorer
Working with Data
Running SQL