Web Based Training

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

This course teaches developers, database administrators, and system programmers various features of SQL, including column functions, grouping, unions, subqueries, and maintaining data.

Grundlagen Englisch
quofox Qualitätssiegel

126,38 €

inkl. 19% MwSt

106,20 € netto

In Warenkorb legen

Beschreibung

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

Ziel

Please refer to course overview

Anforderungen an die Teilnehmer

dashDB SQL for Basic Queries or equivalent experience or knowledge

Teilnehmer

Developers, Database Administrators, System Programmers


Das könnte Dich auch interessieren

Problem melden


Danke

für Ihr Interesse an diesem Produkt.

Wir setzen uns umgehend mit dem Anbieter in Verbindung und werden in Kürze neue Termine anbieten.
Spätestens in 14 Tagen werden wir Sie über die neuen Termine informieren.

Solange finden Sie das Produkt in Ihrer Wunschliste wieder.