dashDB SQL for Functions, Grouping, Union, Subqueries and Updates [K04003GW]

8 Hrs

Corporate training

Course Description

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


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


Developers, Database Administrators, System Programmers


No certification available.


dashDB SQL for Basic Queries or equivalent experience or knowledge


Please contact us for upcoming schedules. Email Us