IBM Analytics

K04009G : dashDB SQL for Subqueries, Functions, Procedures, and Performance

Course Duration

1 Day

Delivery

WBT

Overview

Overview Course Curriculum Training Schedule Exam & Certification FAQs

This course is intended for Developers, Database Administrators, and System Programmers who require further insight into the SQL language.

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

What You'll Learn

Please refer to course overview

Who Should Attend

This course is intended for Developers, Database Administrators, and System Programmers who require further insight into the SQL language.

Prerequisites

dashDB SQL for Basic Queries (K04001)
dashDB SQL for tables, views, advanced queries, and analytic constructs (K04004)
Or equivalent experience or knowledge

Learning Journey

Coming Soon...

1. Using Subqueries

Subquery in a basic predicate
Subquery with IN predicate
Subquery with a NOT IN predicate
Subquery with ORDER BY
Subquery with ALL predicate
Subquery with ANY or SOME predicate
Subquery with EXISTS predicate
Activity
SQL challenges

2. Using correlated subqueries

Correlated subquery with an EXISTS predicate
Scalar fullselect as a correlated subquery
Update statement including a subquery
Activity
SQL Challenges

3. Scalar functions (other than DATE/TIME functions)

Scalar function – SUBSTR – substring
Scalar function – POSSTR – string position
Scalar function – COALESCE/VALUE
Scalar function – DECIMAL
Scalar function – ROUND
Scalar function – DIGITS
Scalar function – SQRT and POWER
Scalar function – CHAR with arguments other than date/time
Scalar function – LENGTH
Scalar functions – LTRIM/RTRIM – Left TRIM/Right Trim
Activity
SQL challenges

4. Scalar functions – DATE/TIME functions

DATE, TIME, and TIMESTAMP formats
Scalar function – CHAR with date/time arguments
Scalar functions – date related (part 1)
Scalar functions – date related (part 2)
Scalar functions – time related
Labelled DATE/TIME durations
Activity
SQL challenges

5. Table expressions

Nested table expressions
Nested table expressions in Joins
Common table expressions (CTEs)
SQL challenges

6. Recursive SQL

SQL challenges

7. Introduction to UDTs, UDFs, and stored procedures

User-defined distinct Types (UDTs)
User-defined functions (UDFs)
Sourced user-defined functions
External user-defined functions
User-defined SQL functions
User-defined stored procedures
Activity
SQL challenges

8. SQL and dashDB performance

Note on indexes
dashDB optimizer
Index overview
Clustered and non-clustered indexes
Index utilization
Predicate processing
General guidelines – correlated subqueries
General guidelines – minimize dashDB sorts
General guidelines – view usage
General guidelines – expressions
General guidelines – NOT EQUAL predicates
General guidelines – arithmetic
General guidelines – conversion
General guidelines – retrieve only necessary data
Monitor the SQL workload and use the EXPLAIN facility
SQL challenges

Instructors

Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)

10 Courses

Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)

10 Courses

Frequently Asked Questions (FAQs)

Why get IBM certified?

IBM certifications validate your skills and expertise in a wide range of technologies, including hybrid cloud, data & AI, security, IT infrastructure, and business applications.
These certifications are globally recognized and can help you advance your career, increase your earning potential, and demonstrate your commitment to professional development.
IBM-certified professionals are in high demand, making them valuable assets to any organization seeking to leverage IBM's innovative solutions.
What to expect for the examination?

IBM offers a variety of certification exams at different levels (Basic, Intermediate, and Advanced) covering various technologies and job roles.
Exams typically consist of multiple-choice questions and may include scenario-based questions that assess your ability to apply your knowledge in real-world situations.
Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
How long is IBM certification valid for?

The validity period of IBM certifications varies. Some certifications, particularly those focused on specific product versions or technologies, may have expiration dates.
However, many IBM certifications, especially those focused on broader skills or newer technologies, do not have an expiration date.
Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
Why take this course with Trainocate?

Here’s what sets us apart:
- Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 24 countries (and counting!).
- Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.
- Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.
- Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.
- Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.
- Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

FAQs

Frequently Asked Questions

Improve yourself and your career by taking this course.

Enroll Now

More Courses By IBM

Browse All Courses

System Z

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name

Phone

I'm inquiring for

Myself

Company

Inquiry Details

By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.

You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.

K04009G : dashDB SQL for Subqueries, Functions, Procedures, and Performance

What You'll Learn

Who Should Attend

Prerequisites

Learning Journey

Instructors

Frequently Asked Questions (FAQs)

Why get IBM certified?

What to expect for the examination?

How long is IBM certification valid for?

Why take this course with Trainocate?

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

Frequently Asked Questions

Improve yourself and your career by taking this course.

More Courses By IBM

Advanced Parallel Sysplex Operations and Recovery Workshop

IBM Cognos Analytics: Author Reports Fundamentals v11.1.x

IBM z/OS Management Facility Implementation and Use 2.1

Ready to Take Your Business from Great to Awesome?

Enquire Now

Request More Information

Welcome Back!

Create account

Account Setup

Contact Details

Address