trainocate-ibm-training
Home > Vendors > ibm > k04003g

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

Overview

Duration: 1 day
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

Objectives

Please refer to course overview

Audience

Developers, Database Administrators, System Programmers

Content

1. dash DB 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

Prerequisites

dash DB SQL for Basic Queries or equivalent experience or knowledge

Certification

Schedule




Enquire Now
 
 
 
 
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy