Duration
5 days
Course Outline
- Introduction to IBM DB2
- What is DB2?
- DB2 Editions
- DB2 Schema
- Db2 Installation
- Relational Database
- Table Relationship
- Primary Key
- Foreign key
- Normalization
- DB2 data types
- Overview SQL language
- DDL Create, Alter and Drop
- Create/drop schema
- Create/drop table
- Referential integrity and constraints
- DML Insert, update and delete statement.
- DCL Grant and Revoke
- Simple select statement
- Colum aliases
- Arithmetic expression
- Define NULL
- Duplicated rows
- Filter using WHERE
- Comparison operators
- Logical operators
- Sorting Data Using ORDER BY
- Group Functions
- Group BY
- Having
- Ranking function
- Join tables
- Inner join
- Outer joins (LEFT, RIGHT, FULL)
- Use ANTI JOINS
- Self-Join
- SQL Functions
- Numeric Functions
- Text Functions
- Data/Time Functions
- Conversion Function CAST
- Case Statement
- Summarizing data using INSERT IN TO statement
- Set Operators
- Use UNION and UNION ALL
- Use EXCEPT and INTERCEPT
- Sub queries
- Sub queries in where
- Sub queries to select from other select statement
- Sub queries to join with inner query
- Data Import and Export CSV files
- Import data from CSV into DB2 table
- Export DB2 table into CSV file
- Export query result into CSV file
- Views
- Stored Procedure
- Triggers
- Recursive SQL using while
- DBeaver for Data Migration across Platforms
- Final Project
Programme scope, delivery arrangements and suitability are confirmed during enquiry.