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

Code: K04003G-WBT


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. /terms


Developers, Database Administrators, System Programmers


dashDB SQL for Basic Queries or equivalent experience or knowledge


Please refer to course overview

Course Outline

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

Price (ex. VAT)

€ 820,00 per person


1 days


Please send us a message with the form below

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)


We will contact you to discuss your requirements