dashDB SQL for Functions, Grouping, Union, Subqueries and Updates - eLearning - K04003G

Description

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

1. dashDB environment
2. 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 - solutions
3. UNION
Single report
UNION rules
UNION vs UNION ALL
SQL challenges
SQL challenges - solutions
4. Using subqueries
Subqueries
Subquery predicates
Restrictions and reminders
SQL challenges
SQL challenges - solutions
5. Maintaining data
Working data
Views
Working with the data
Prototyping change SQL with a unit of work
Reminders
SQL challenges
SQL challenges - solutions

Aim

Please refer to course overview

Participant requirements

dashDB SQL for Basic Queries or equivalent experience or knowledge

Participant

Developers, Database Administrators, System Programmers