dashDB SQL for Functions, Grouping, Union, Subqueries and Updates - eLearning (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
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