Db2 11.5 for LUW: SQL Workshop for Experienced Users

Formation : 14751

RÉFÉRENCE INTERNE DE LA FORMATION :

TDS_CL732G

Description de la formation

This course teaches how to make use of advanced SQL techniques. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows environments. 


Along with a review of some basic relational database concepts, this course covers some of the OLAP features of Db2, including GROUP and RANK functions. Learners will explore coding joins, using the CASE expressions, the CAST function, and code advance SQL constructs, such as recursive SQL and table expressions.


Learners will also participate in hands-on exercises to practice writing complex queries and subqueries.


Mise à jour 19/12/2024

Destinataires de la formation

This course is intended for individuals seeking to make use of SQL techniques to access Db2 databases in different environments. This course is appropriate for customers working in Db2 environments for Linux, UNIX, and Windows.

Mots-clés en rapport avec la formation

IBM CL732G Db2 11.5 for LUW: SQL Workshop for Experienced Users