• IBM DB2 Database Design & Development

IBM DB2 Database Design & Development

This database training for beginners and advanced developers introduces and defines the terminology, concepts, and skills you need to understand database objects, security requirements, graphical tools, basic database administration, SQL scripts and writing database queries, in addition to executing stored procedures.


On successful Completion of this course you will be able to:


  • Understand DB2 Terminology
  • Describe the Basic Architecture and Concepts of IBM DB2
  • Describe and work with DB2 Database Management Tools
  • Install DB2 Data Studio
  • Understand Data Modeling and Database Design
  • State the purpose of a business model
  • Identify an Entity-Relational Diagram (ERD) model
  • List several DB2 column data types
  • Identify non-standard column and table names
  • Identify the characteristics of a primary key and a foreign key
  • State the purpose of referential integrity
  • State the purpose of triggers
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in DB2
  • Modify data using SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets

Write a review

Please login or register to review

IBM DB2 Database Design & Development

  • Brand: Weblearning Publishing
  • Product Code: IBM DB2 Database Design & Development
  • Reward Points: 100
  • Availability: In Stock
  • £89.99
  • £69.99

  • Price in reward points: 1200

  • 2 or more £63.99
  • 4 or more £59.99

Available Options


Related Products

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£23.99 £29.99

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..

£79.99 £99.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

Database Administration Unlimited

Database Administration Unlimited

Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..

£320.00 £355.00

Oracle Database 23ai Data Warehousing Fundamentals

Oracle Database 23ai Data Warehousing Fundamentals

Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..

£110.99 £129.99

Oracle Database 23ai: SQL Workshop

Oracle Database 23ai: SQL Workshop

Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..

£84.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Data Science Unlimited

Data Science Unlimited

Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..

£310.00 £348.00

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..

£310.00 £348.00

Oracle Database 23ai: New Features for Developers

Oracle Database 23ai: New Features for Developers

Oracle Database 23ai: New Features for Developers This course focuses on the latest advancements ..

£124.00 £149.99

Tags: Database Management, Oracle Database, DB2, SQL, DBA