When does class start/end?
Classes begin promptly at 9:00 am, and typically end at 5:00 pm.
This IBM Web-Based Training (WBT) is Self-Paced and includes: - Instructional content available online for duration of course - Visuals without hands-on lab exercises This course teaches developers,...
Read More
This IBM Web-Based Training (WBT) is Self-Paced and includes:
- Instructional content available online for duration of course
- Visuals without hands-on lab exercises
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
Please refer to course overview
Developers, Database Administrators, System Programmers
dashDB SQL for Basic Queries or equivalent experience or knowledge
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