• IBM DB2 Database SQL Fundamentals eLearning

IBM DB2 Database SQL Fundamentals

This course provides students with the technical skills required to write SQL queries for IBM DB2 9.7 to 11.5. This course is the foundation for all DB2-related disciplines; namely, Database Administration, Database Development and Business Intelligence.


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


  • Describe the basic architecture and concepts of IBM DB2
  • Understand the similarities and differences between SQL and other computer languages
  • 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
  • Execute stored procedures
  • Program with SQL
  • Implement error handling
  • Implement transactions

Write a review

Please login or register to review

IBM DB2 Database SQL Fundamentals eLearning

  • Brand: Weblearning Publishing
  • Product Code: IBM DB2 Database SQL Fundamentals eLearning
  • Reward Points: 100
  • Availability: In Stock
  • £89.99
  • £59.99

  • Price in reward points: 1200

  • 2 or more £54.99
  • 3 or more £51.99

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

Big Data Unlimited

Big Data Unlimited

Big Data Unlimited Cloud Learning SubscriptionThe Big Data  Unlimited Cloud Learning Subsc..

£365.00 £399.00

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training ApplianceThis Big Data & Data Science VM Training Applia..

£249.00 £279.00

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171 This course introduces stude..

£124.00 £149.99

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