trainocate-ibm-training-b
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. 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

  • Prerequisites

    dashDB SQL for Basic Queries or equivalent experience or knowledge

    Certification

    Schedule

    Show Schedule for:




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