+48 22 208 28 61    szkolenia@cts.com.pl

dashDB SQL for Functions, Grouping, Union, Subqueries and Updates – k04003gwpl

Course #:

Duration: 1 Days

This course teaches developers, database administrators, and system programmers various features of SQL, including column functions, grouping, unions, subqueries, and maintaining data.

Note: Guided eLearning is a self-paced offering which includes web-based content for self-study and videos (including audio) that demonstrate activities.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course. http://www.ibm.com/training/terms


Please refer to course overview


Developers, Database Administrators, System Programmers


dashDB SQL for Basic Queries or equivalent experience or knowledge


1. dashDB environment2. Column functions and grouping • SQL functions • Beware of NULLs • GROUP BY and HAVING • Important rule for column functions • Restrictions • Conceptual execution of a SELECT • SQL challenges • SQL challenges - solutions3. UNION • Single report • UNION rules • UNION vs UNION ALL • SQL challenges • SQL challenges - solutions4. Using subqueries • Subqueries • Subquery predicates • Restrictions and reminders • SQL challenges • SQL challenges - solutions5. Maintaining data • Working data • Views • Working with the data • Prototyping change SQL with a unit of work • Reminders • SQL challenges • SQL challenges - solutions

Contact us regarding the training